Opencart same error as old post no replies

System hostname (
Operating system Ubuntu Linux 20.04.1
Webmin version 1.970
Usermin version 1.812
Virtualmin version 6.14 Pro


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 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.

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:
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.