Sqlite3store error constraint failed: NOT NULL constraint failed: sessions.expiry (1299) about scs HOT 4 CLOSED

I get same error also. My sqlite driver is modernc.org/sqlite.

from scs.

https://github.com/alexedwards/scs/blob/master/sqlite3store/sqlite3store.go#L51

Format the expiry , it will work.

from scs.

@LordPraslea I've tried to replicate this problem and I can't --- following the setup instructions in the README (https://github.com/alexedwards/scs/tree/master/sqlite3store) and using the example code, the expiry date seems to be set with no problems.

Could you provide some example code that demonstrates the issue?

from scs.

@LordPraslea Actually don't worry about the example. Looking through the SQLite docs I can see that julianday potentially doesn't work with all values returned by time.Time.String() and that's enough to go on.

I've pushed commit 84bd122 which should fix this --- it now converts the expiry to UTC and formats it to "2006-01-02T15:04:05.999" before doing the insert.

I'm going to close this, but please reopen if there continues to be a problem.

from scs.