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

FN

Faisal Nadeem

Asked

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

    ok done it was the problem with maria db version i upgrade it and it’s work fine

  • MS

    Mian Saleem

    Answered

    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