MySQL error on web interface

squizer · **Author**

Hello,
The new version is very good, but I am having a little problem with MySQL on my players profils. (You can check the error on hlstats.squizer.cz ). Also I am including a screenshot.

squizer · 12-05-2019 , 06:27 Re: MySQL error on web interface

https://ibb.co/gMRQKSb

squizer · 12-05-2019 , 08:56 Re: MySQL error on web interface

SOLVED BY set global sql_mode=''; COMMAND RUNNING IN DATABASE

NomisCZ · *Last edited by NomisCZ; 12-07-2019 at 10:48.*

Starting from MySQL 5.7, the default value is more restrictive and this the reason why some users have problems with unexpected query failures after migration to 5.7 or 8.0.

Solution:

1. Change SQL mode globally in /etc/mysql/my.cnf

PHP Code:


			
[mysqld]
sql_mode=NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

2. Restart MySQL server - systemctl restart mysql OR service mysql restart