Centova Technologies Forum

Centova Cast v3 => Bugs and issues => Topic started by: portsonic on September 22, 2018, 07:02:51 pm

Title: Control Panel Installation issue with MySQL
Post by: portsonic on September 22, 2018, 07:02:51 pm
On the initial screen for the Administrator Account and MySQL Database stuff, when I click Next, I get the following error in red just above the Administration Account stuff:

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

What do I need to do to fix this since I cannot proceed?
Title: Re: Control Panel Installation issue with MySQL
Post by: ruyihaoren on September 27, 2018, 10:10:29 am
On the initial screen for the Administrator Account and MySQL Database stuff, when I click Next, I get the following error in red just above the Administration Account stuff:

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

What do I need to do to fix this since I cannot proceed?

set sql_mode as below:
sql_mode='MYSQL40'
Title: Re: Control Panel Installation issue with MySQL
Post by: radyoapp on July 30, 2019, 05:27:02 pm
Hello there,

Where do we do the command you specify. Could you please give me some information?   :'(



On the initial screen for the Administrator Account and MySQL Database stuff, when I click Next, I get the following error in red just above the Administration Account stuff:

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

What do I need to do to fix this since I cannot proceed?

set sql_mode as below:
sql_mode='MYSQL40'
Title: Re: Control Panel Installation issue with MySQL
Post by: Dennis Fallon on August 01, 2019, 01:25:50 am
See if this post helps:
https://centova.com/forums/index.php?topic=5009.0