Post by Rolando1213 » Thu Mar 21, 2019 6:13 am

Hello, I have problem in installation after step 3 with sql database. Please help me.

Installation says this:

Fatal error: Uncaught exception 'Exception' with message 'Error: Variable 'sql_mode' can't be set to the value of 'MYSQL40'<br />Error No: 1231<br />SET @@session.sql_mode = 'MYSQL40'' in /www/g/o/u136715/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /www/g/o/u136715/public_html/system/library/db.php(45): DB\MySQLi->query('SET @@session.s...') #1 /www/g/o/u136715/public_html/install/model/install/install.php(35): DB->query('SET @@session.s...') #2 [internal function]: ModelInstallInstall->database(Array) #3 /www/g/o/u136715/public_html/system/engine/loader.php(248): call_user_func_array(Array, Array) #4 [internal function]: Loader->{closure}(Array, Array) #5 /www/g/o/u136715/public_html/system/engine/proxy.php(47): call_user_func_array(Object(Closure), Array) #6 /www/g/o/u136715/public_html/install/controller/install/step_3.php(11): Proxy->__call('database', Array) #7 /www/g/o/u136715/public_html/install/controller/install/step_3.php(11): Proxy->database(Array) #8 [internal function]: ControllerInstallStep3- in /www/g/o/u136715/public_html/system/library/db/mysqli.php on line 40

Newbie

Posts

Joined
Thu Mar 21, 2019 6:09 am

Post by rjcalifornia » Fri Mar 22, 2019 11:03 am

Rolando1213 wrote:
Thu Mar 21, 2019 6:13 am
Hello, I have problem in installation after step 3 with sql database. Please help me.

Installation says this:

Fatal error: Uncaught exception 'Exception' with message 'Error: Variable 'sql_mode' can't be set to the value of 'MYSQL40'<br />Error No: 1231<br />SET @@session.sql_mode = 'MYSQL40'' in /www/g/o/u136715/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /www/g/o/u136715/public_html/system/library/db.php(45): DB\MySQLi->query('SET @@session.s...') #1 /www/g/o/u136715/public_html/install/model/install/install.php(35): DB->query('SET @@session.s...') #2 [internal function]: ModelInstallInstall->database(Array) #3 /www/g/o/u136715/public_html/system/engine/loader.php(248): call_user_func_array(Array, Array) #4 [internal function]: Loader->{closure}(Array, Array) #5 /www/g/o/u136715/public_html/system/engine/proxy.php(47): call_user_func_array(Object(Closure), Array) #6 /www/g/o/u136715/public_html/install/controller/install/step_3.php(11): Proxy->__call('database', Array) #7 /www/g/o/u136715/public_html/install/controller/install/step_3.php(11): Proxy->database(Array) #8 [internal function]: ControllerInstallStep3- in /www/g/o/u136715/public_html/system/library/db/mysqli.php on line 40
This might be useful:

https://stackoverflow.com/questions/231 ... e-in-mysql

Image
A2 Hosting features: Shared Turbo Boost, Managed Warp 1, Unmanaged Hyper 1, and Warp 2 Turbo


Active Member

Posts

Joined
Fri Sep 02, 2011 1:19 pm
Location - Worldwide

Post by MohammedAlghaith » Thu Mar 25, 2021 2:47 pm

Hi ,
try this solution which worked with me
delete MYSQL40 from "SET @@session.sql_mode = ''" in install.php file
which located in install folder, the full path is:
opencart-3.0.3.7/install/model/install/install.php

goodluck.


Posts

Joined
Thu Mar 25, 2021 2:39 pm
Who is online

Users browsing this forum: No registered users and 57 guests