Opencart: SQL_MODE = 'MYSQL40'

[PrivateAlpha]

/install/model/install.php contains a query

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

that makes new installations hang on installation step 3.

Someone get rid of it please?

[jamesallsup]

What error do you get? What version of MySQL are you running?

MYSQL40 is a combined settings mode and is available in all of 5 and most of 4 - it is possible you are using an outdated for minimal version of MySQL.

http://dev.mysql.com/doc/refman/4.1/en/server-sql-mode.html#sqlmode_mysql40

http://dev.mysql.com/doc/refman/5.0/en/sql-mode.html

[miklcct]

This line causes error on MySQL 8.0. Please remove it.

[faizon101]

For those who are noobs (like me), what miklcct is saying (and it works) is:
navigate to your install.php file in the following directory
/install/model/install.php
edit the file and delete exactly this text:

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

Thank you miklcct!!!