Post by kevinnksk » Tue Jun 25, 2019 6:25 pm

I have issue in installation in step 3. that show the blank page. and below is the log in httpd error.log, please help.

i had try follow this below URL method but still not work.... add sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
https://stackoverflow.com/questions/231 ... e-in-mysql

my server version:
CentOS Linux release 7.6.1810 (Core)
mysql Ver 8.0.15 for Linux on x86_64
PHP 7.3.6
Apache/2.4.6


[Tue Jun 25 18:06:37.510430 2019] [php7:error] [pid 2613] [client 71.103.247.77:12461] PHP Fatal error: Uncaught Exception: Error: Variable 'sql_mode' can't be set to the value of 'MYSQL40'<br />Error No: 1231<br />SET @@session.sql_mode = 'MYSQL40' in /home/shop/web/opencart/system/library/db/mysqli.php:40\nStack trace:\n#0 /home/shop/web/opencart/system/library/db.php(45): DB\\MySQLi->query('SET @@session.s...')\n#1 /home/shop/web/opencart/install/model/install/install.php(35): DB->query('SET @@session.s...')\n#2 /home/shop/web/opencart/system/engine/loader.php(248): ModelInstallInstall->database(Array)\n#3 /home/shop/web/opencart/system/engine/proxy.php(47): Loader->{closure}(Array, Array)\n#4 /home/shop/web/opencart/install/controller/install/step_3.php(11): Proxy->__call('database', Array)\n#5 /home/shop/web/opencart/system/engine/action.php(79): ControllerInstallStep3->index()\n#6 /home/shop/web/opencart/system/engine/router.php(67): Action->execute(Object(Registry))\n#7 /home/shop/web/opencart/system/engine/router.php(56): Router->execute(Object(Action))\n#8 /home/shop/web/opencart/system/framew in /home/shop/web/opencart/system/library/db/mysqli.php on line 40, referer: https://shop.hk/opencart/install/index. ... all/step_3

Newbie

Posts

Joined
Tue Jun 25, 2019 6:15 pm

Post by straightlight » Tue Jun 25, 2019 8:24 pm

No OC version posted. However, try these instructions: https://github.com/copona/copona/commit ... c2d61721de .

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by kevinnksk » Tue Jun 25, 2019 9:29 pm

i only find this one, viewtopic.php?t=210653
but this not the solution for me, thanks a lot.

Newbie

Posts

Joined
Tue Jun 25, 2019 6:15 pm

Post by kevinnksk » Wed Jun 26, 2019 11:20 am

thanks all, i find the solution.
edit install.php and disable the query MYSQL40

vi /opencart/install/model/install/install.php

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

Newbie

Posts

Joined
Tue Jun 25, 2019 6:15 pm
Who is online

Users browsing this forum: No registered users and 136 guests