MYSQL deploy - MariaDB

[vk1dc]

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

[F4BPO]

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

[IW3HMH]

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