CMS install problems

[AlbertoMeyer]

I'm making a website that uses CMS. I set up an AMPPS server and everything was ok. When trying to upload to my server, I'm getting this error "Invalid query: Invalid default value for 'last_update_date'"

Settings are right. Any additional tips?

No tables are created. I am trying to run the SQL on manual, but give an erro.

[Pablo]

This is most likely related to the format of the date field in the database.

In the MYSQL database, set default value for last_update_date to '0000-00-00 00:00:00'.
This works for me.

[AlbertoMeyer]

Not working. It´s a MySQL directive for MYSQL 5.7. I have to deactivate the NO_ZERO_DATE setting and I don´t know how.

[Pablo]

Did you set a default date in the database? That should work.

[AlbertoMeyer]

Pablo, the script is not running or creating the tables. Accuses error in

`last_update_date` timestamp NOT NULL default '0000-00-00 00:00:00',

I don't know how to solve this. It's sad because it's an important site for me and without the CMS I'll have to see another alternative. As it is my production server, I have to be careful not to make mistakes and take down other hosted sites.

I know that is not a WYSWYG problem, but can affect customers.

[Pablo]

I'm sorry, I cannot help you with the server configuration. I do not know every variation of every server.
However, if your server does not support this SQL then you will have to change the syntax.
For example, you can try to remove the 'default' part

So, instead of

Code: Select all

`last_update_date` timestamp NOT NULL default '0000-00-00 00:00:00',

use

Code: Select all

`last_update_date` timestamp,

[AlbertoMeyer]

#1067 - Valor padrão (default) inválido para 'last_update_date'

Means Invalid default fo Last_update_date. I have tried it before. I create the databse without last_update_dat, than i create the field manually. Then i update de default. No good. Same error. I just update de set no zero state. No luck. I think update to 8.0 will solve, but it is too risky for my other sites.

[AlbertoMeyer]

Solution was modify your script and put default value for '1970-01-01 00:00:01'
This is the first valid date now (range).
I have run the script before in PHP My Admin with Aloow invalid dates too. So, i don´t know exactly what works.
The default script on CMS upload was wrong, works on old Mysqls
Thanks for the help, Pablo!