Centova Technologies Forum

Centova Cast v3 => Bugs and issues => Topic started by: trumpetradio on January 15, 2019, 07:50:57 am

Title: strange error when finishing setup on new machine
Post by: trumpetradio on January 15, 2019, 07:50:57 am

I installed CC on a new server and I'm trying to finish the installation. I have entered all the proper info such as db name, user, password and db server, and now I get this error

Error populating database: Could not execute query: BLOB, TEXT, GEOMETRY or JSON column 'ignoremeta' can't have a default value

Any idea what I'm doing wrong? This is not my first time setting up a CC machine, but I never got this error before.

Title: Re: strange error when finishing setup on new machine
Post by: trumpetradio on January 15, 2019, 09:30:31 am

Fixed.
Had to enter mysql and input the following:
SET GLOBAL sql_mode='MYSQL40'

Title: Re: strange error when finishing setup on new machine
Post by: CrownHosting on March 11, 2020, 01:00:58 am

On Centos 8 with MySQL 8 we had to add to my.cnf:
sql_mode= NO_ENGINE_SUBSTITUTION

Title: Re: strange error when finishing setup on new machine
Post by: jfs277 on April 08, 2020, 09:05:23 am

Actually i found the issue the other day to fix it just go to  /usr/local/centovacast/system/centovacast.sql 

open centova.sql with a text editor like notepad ++
then find line that says `ignoremeta` text NOT NULL DEFAULT '',
change to `ignoremeta` text DEFAULT NULL,

once done try again
this fixed my issue and once the data base is setup you can go back and change back to `ignoremeta` text NOT NULL DEFAULT '', or leave it it will not beak the database if left