connect-session-knex icon indicating copy to clipboard operation
connect-session-knex copied to clipboard

Connect-session-knex does not work with older versions of mysql

Open zenaculo opened this issue 5 years ago • 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

zenaculo avatar Jul 02 '20 14:07 zenaculo

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

zenaculo avatar Jul 02 '20 14:07 zenaculo