Connect-session-knex does not work with older versions of mysql
zenaculo opened this issue · 1 comments
I'm trying to perform a deployment of an app on Heroku that uses clearDB in version 5.5.62 that doesn't support json type fields.
I saw that recently there was a merge regarding issue #50 but I still have the error. I am using version 1.7.2.
Alternatively, how can I implement what was described in #50?
#UnhandledPromiseRejectionWarning: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json not null, expired datetime not null)' at line 1
Tks
By the way, I installed the last commit that performed the correction and it worked but I would like to understand what was reported here #50
"I decided to make my own table and use text instead of json while setting createTable to false which seems to work"
Thanks for your patience and sorry for the inconvenience of this issue