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:Rolando1213 wrote: ↑Thu Mar 21, 2019 6:13 amHello, 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
https://stackoverflow.com/questions/231 ... e-in-mysql
A2 Hosting features: Shared Turbo Boost, Managed Warp 1, Unmanaged Hyper 1, and Warp 2 Turbo
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.
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.
Who is online
Users browsing this forum: No registered users and 57 guests