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

Sessions table creation error on MariaDB

Open cappuccio opened this issue 6 years ago • 1 comments

Hi, i tried to use this module to store my sessions, but I'm encountering an error when it tries to create a dedicated table to store the sessions:

Unhandled rejection Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, 'expired' datetime not null)' at line 1

It is clearly due to the fact that the json format is only supported by MariaDB 10.2+.

cappuccio avatar Aug 01 '19 08:08 cappuccio

Related to #50

adarshmadrecha avatar Nov 05 '19 07:11 adarshmadrecha