Maria Db Json Error Sqlstate 42000 Syntax Error

Asked 5 years ago

SQL: unable to create tables, SQLSTATE[42000]: Syntax error or access violation: 1064 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, CHANGE `description` `description` json NULL DEFAULT NULL; # I' at line 1

Hi Saleem i am getting this error upon install at installation configuration please let me know what i am doing wrong thanks

FN
Faisal Nadeem
Answered 5 years ago
ok done it was the problem with maria db version i upgrade it and it's work fine
MS
Mian Saleem
Answered 5 years ago
Hello,

Yes, json support was added to 10.2 as I can remember. I am glad to know that you found the cause.

Thank you for updating
Login to Reply

0	Votes
2	Answers
788	Views

Question: Maria Db Json Error Sqlstate 42000 Syntax Error

Maria Db Json Error Sqlstate 42000 Syntax Error

SQL: unable to create tables, SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version f