Log4OM

Posted: **16 Jan 2020, 09:16**

Good evening

I am attempt to deploy the sql server. The sql server currently holds my LOG4OM v1 database. I have used a different name but on the same server. It is a mariaDB as MYSQL is rare on linux.(CentOS Server)

Code: Select all

2020-01-16 09:08:03.7185 ERROR:       [DbMysql][Deploy] : MYSQL Error while deploying database -2147467259 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                      ,
     `contestid`              VARCHAR(50)     DEFAU' at line 24
[EXCEPTION] 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                      ,
     `contestid`              VARCHAR(50)     DEFAU' at line 24 MySql.Data.MySqlClient.MySqlException (0x80004005): 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                      ,
     `contestid`              VARCHAR(50)     DEFAU' at line 24

not sure were to go. as log indicates a script error.

73's

de

Emma Cuthbert

VK1DC

Posted: **16 Jan 2020, 09:36**

Hi,

Got the same issue this mnorning you need to have Mariadb 10.2 minimum.
You can check the version by connection to your database

mysql -u root -p

Then i had to do an apt install mariadb-server to install the last mariadb-server 10.3.xxx

Then you do a mysql-update -u root -p

and you should be good to go

Thanks

Posted: **16 Jan 2020, 12:18**

More info about JSON field in MariaDB:
https://mariadb.com/kb/en/json-data-type/

Log4OM

MYSQL deploy - MariaDB

MYSQL deploy - MariaDB

Re: MYSQL deploy - MariaDB

Re: MYSQL deploy - MariaDB