Installing opencart on a Ubuntu 20 server. I installed mysql, created an opencart user and database, granted the user permissions, and verified that I can log in as that user and do queries. Installed PHP7.3 with no problem. Installed and configured Nginx, unzipped and copied over the opencart files, set ownership, etc. The initial license webpage comes up, the second page shows pre-installation is all green. I enter the database credentials on the configuration page and hit continue, I get an error 500.
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?
Well MySql40 is most likely no longer a valid 'way', to access
and handle an OC v.3.x Database, you'll nedd to use mysqli, to make
it work as planned.
Ernie
and handle an OC v.3.x Database, you'll nedd to use mysqli, to make
it work as planned.
Ernie
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Already removed from master branch.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
I found the fix here, I should have done a forum search before posting sorry.
viewtopic.php?f=199&t=218617&p=791484&h ... 40#p791484
viewtopic.php?f=199&t=218617&p=791484&h ... 40#p791484
Who is online
Users browsing this forum: No registered users and 10 guests