Page 1 of 1

mysql version 8.0

Posted: Sat Apr 03, 2021 6:52 pm
by shrinidhi
Is opencart 3.0.3.7 version support MySQL 8.0?

Re: mysql version 8.0

Posted: Sun Apr 04, 2021 5:46 pm
by johnp
I've got a copy running on PHP 8 fine. I installed it on 7.4 then switched over. I haven't done an install on PHP 8 from scratch. It's a default setup apart from having the Vqmod Manager extension installed.

Re: mysql version 8.0

Posted: Sun Apr 04, 2021 5:52 pm
by johnp
Sorry, I misread the OP's post. I mistook the question for PHP 8. I'll put my glasses on next time. :)

Re: mysql version 8.0

Posted: Mon Apr 05, 2021 10:48 pm
by JNeuhoff
Yes, it should run just fine on MySQL8.

The only change you may have to do is in the system/library/db/mysqli.php where the line

Code: Select all

$this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'");
should be replaced with

Code: Select all

$this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION'");