Upgrade from 2.3.0 to 2.3.1 error

[Mircea]

Hello,

 

I'm trying to upgrade from 2.3.0 to 2.3.1 but I'm keep receiving this error:

Failed to import database codes. Error message: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'suspend_date'

 

Any solution to solve this error?

 

Thanks,

Mircea.

[Onur]

1 hour ago, Mircea said:

Hello,

 

I'm trying to upgrade from 2.3.0 to 2.3.1 but I'm keep receiving this error:

Failed to import database codes. Error message: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'suspend_date'

 

Any solution to solve this error?

 

Thanks,

Mircea.

Hi @Mircea

This is due to SQL strict mode being enabled. Please visit the link below for detailed information.

https://docs.wisecp.com/en/kb/mysql-strict-mode-issue

[Mircea]

Hello,

 

Problem solved after made that modification in my.cnf file.

 

Thanks,

Mircea