Errors with new server fixed.

(Originally posted on: January 3, 2020

Server errors fixed. Setting changed – disable strict mode.


for my future reference:
in my.ini file (C:\wamp64\bin\mysql\mysql5.7.26)

uncomment this:

sql-mode=””

and comment out this line:
;sql-mode=”STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER”

See https://www.linode.com/community/questions/17070/how-can-i-disable-mysql-strict-mode

Leave a Reply

Your email address will not be published. Required fields are marked *