facebook: DataTypes.JSON issue

Open shaharyar123 opened this issue 9 years ago • 0 comments

i am facing the OAUTH issue when i assign datatype JSON to facebook and google. my database is mysql, getting this error :

Server failed to start due to error: SequelizeDatabaseError: ER_PARSE_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,twitterJSON,googleJSON,providerVARCHAR(255),saltVARCHAR(255' at line 1

if i set datatype : text or string then it works but i cant query on them.

How to store in JSON datatype in MySql ?

Mar 01 '17 15:03 shaharyar123