Error on setup

[paulocastellano]

Hi,

 

I have this error in setup install:

 

[WHMCS ChrisD]

Hello paulocastellano,

 

Thanks for your post on the WHMCS Community Forums.

 

In order to resolve this you will need to remove NO_ZERO_IN_DATE,NO_ZERO_DATE from the SQL Mode on your server in situations like this it is usually what is causing the issue. It is a new SQL mode, sometimes added by default that conflicts with the datetime default values.

 

For more information on SQL Modes, and how to set the SQL Mode for your MySQL environment, please refer to MySQL's official documentation available at the url below.

https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html

[twhiting9275]

Just another thought on this , in addition to what Chris mentioned.

 

Make SURE you're not running MySQL in strict mode. This is likely the cause of this, though what Chris mentioned could be valid as well.

[paulocastellano]

Hello paulocastellano,

 

Thanks for your post on the WHMCS Community Forums.

 

In order to resolve this you will need to remove NO_ZERO_IN_DATE,NO_ZERO_DATE from the SQL Mode on your server in situations like this it is usually what is causing the issue. It is a new SQL mode, sometimes added by default that conflicts with the datetime default values.

 

For more information on SQL Modes, and how to set the SQL Mode for your MySQL environment, please refer to MySQL's official documentation available at the url below.

https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html

 

 

Thanks, solved.