Looking in the nginx log I see;
2020/10/08 15:42:39 [error] 677#677: *10 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Exception: Error: Variable 'sql_mode' can't be set to the value of 'MYSQL40'<br />Error No: 1231<br />SET @@session.sql_mode = 'MYSQL40' in /var/www/html/(my website).com/system/library/db/mysqli.php:40
Probably some kind of connection problem with the database but not clear how to debug it. I see a statement in mysqli.php;
$this->connection->query("SET SQL_MODE = ''");
Not clear on where this 'MYSQL40' is coming from. When I try executing that command manually I do see an error;
mysql> SET SQL_MODE = 'MYSQL40';
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'MYSQL40'
What can I try?
and handle an OC v.3.x Database, you'll nedd to use mysqli, to make
it work as planned.
I am no longer active at the Forum. Please do NOT send me Personal Mails,
they will no longer be replied to.
My Github OC Site: https://github.com/IP-CAM
4'100 + FREE OC Extensions, on the World's largest Github OC Repository Archive Site.
The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.
Programmer / Opencart Tester
viewtopic.php?f=199&t=218617&p=791484&h ... 40#p791484
Users browsing this forum: No registered users and 8 guests