Opencart same error as old post no replies

System hostname
web1.smtp-jet.com (216.18.219.188)
Operating system Ubuntu Linux 20.04.1
Webmin version 1.970
Usermin version 1.812
Virtualmin version 6.14 Pro

Hello,

Can I get help with the following issue.
This post explains the issue:
Opencart Script

I have a simple 3 domain system.
web1 there is nothing on it. It is a webserver and nothing currently installed.
for the SQL DB credentials I used the web1 credentials on the screenshot posted.
For email address I just added an existing email address.

I get a server 500 error and I am not sure why.
I would assume at this point it is user error, LOL , but your help is appreciated.

As the post claims, the database looks like it is there, but fails during install, but then you can go to serverxyz.com/opencart and get to the installer but I cannot get it to save settings, and complete install.


Then when clicking continue it gives the server 500 error.
server500

During setup, it passes all pre-requisites, writable directories, files, etc…
but I would get server 500 error, or right away get

Fatal error: Uncaught Exception: Error: Variable 'sql_mode’ can’t be set to the value of 'MYSQL40 '”

My first thought was maybe another server setting or PHP setting that needed changed.

Known Issue with MySQL version 8
Following this Article
Go to:
/install/model/install.php
edit the file and delete exactly this text:

$db->query("SET @@session.sql_mode = 'MYSQL40'");

Re-run setup.

This topic was automatically closed 4 days after the last reply. New replies are no longer allowed.