OpenCart Community

I am trying to install Opencart on my hosting, but after step 3 i am getting to an http 500 error. After the error i did take a look inside my error.log and found this:

[Fri Nov 27 19:47:31.253173 2020] [fcgid:warn] mod_fcgid: stderr: PHP Fatal error: Uncaught Exception: Error: 0<br />Error No: 0<br />, referer: http://www.mywebsite.com/install/index. ... all/step_3
[Fri Nov 27 19:47:31.253240 2020] [fcgid:warn] mod_fcgid: stderr: INSERT INTO `oc_event` (`event_id`, `code`, `trigger`, `action`) VALUES, referer: http://www.mywebsite.com/install/index. ... all/step_3
[Fri Nov 27 19:47:31.253256 2020] [fcgid:warn] mod_fcgid: stderr: (1, 'voucher', 'catalog/model/checkout/order/addOrderHistory/after', 'extension/total/voucher/send');, referer: http://www.mywebsite.com/install/index. ... all/step_3
[Fri Nov 27 19:47:31.253259 2020] [fcgid:warn] mod_fcgid: stderr: in /var/www/vhosts/mywebsite.com/httpdocs/system/library/db/mysqli.php:43, referer: http://www.mywebsite.com/install/index. ... all/step_3
[Fri Nov 27 19:47:31.253268 2020] [fcgid:warn] mod_fcgid: stderr: Stack trace:, referer: http://www.mywebsite.com/install/index. ... all/step_3
[Fri Nov 27 19:47:31.253271 2020] [fcgid:warn] mod_fcgid: stderr: #0 /var/www/vhosts/mywebsite.com/httpdocs/system/library/db.php(45): DB\\MySQLi->query('\\n\\nINSERT INTO `...'), referer: http://www.mywebsite.com/install/index. ... all/step_3
[Fri Nov 27 19:47:31.253274 2020] [fcgid:warn] mod_fcgid: stderr: #1 /var/www/vhosts/mywebsite.com/httpdocs/install/model/install/install.php(26): DB->query('\\n\\nINSERT INTO `...'), referer: http://www.mywebsite.com/install/index. ... all/step_3
[Fri Nov 27 19:47:31.253277 2020] [fcgid:warn] mod_fcgid: stderr: #2 /var/www/vhosts/mywebsite.com/httpdocs/system/engine/loader.php(178): ModelInstallInstall->database(Array), referer: http://www.mywebsite.com/install/index. ... all/step_3
[Fri Nov 27 19:47:31.253280 2020] [fcgid:warn] mod_fcgid: stderr: #3 /var/www/vhosts/mywebsite.com/httpdocs/system/engine/proxy.php(25): Loader->{closure}(Array, Array), referer: http://www.mywebsite.com/install/index. ... all/step_3
[Fri Nov 27 19:47:31.253283 2020] [fcgid:warn] mod_fcgid: stderr: #4 /var/www/vhosts/mywebsite.com/httpdocs/install/controller/install/step_3.php(11): Proxy->__call('database', Array), referer: http://www.mywebsite.com/install/index. ... all/step_3
[Fri Nov 27 19:47:31.253286 2020] [fcgid:warn] mod_fcgid: stderr: #5 /var/www/vhosts/mywebsite.com/httpdocs/system/engine/action.php(51): ControllerInstallStep3->index(), referer: http://www.mywebsite.com/install/index. ... all/step_3
[Fri Nov 27 19:47:31.253289 2020] [fcgid:warn] mod_fcgid: stderr: #6 /var/www/vhosts/mywebsite.com/httpdocs/system/ in /var/www/vhosts/mywebsite.com/httpdocs/system/library/db/mysqli.php on line 43, referer: http://www.mywebsite.com/install/index. ... all/step_3

Opencart Version 2.3.0.2 Server Version: 10.3.24-MariaDB-cll-lve - MariaDB Server

I have found and tried the following possible solutions: Remove MYSQL40 from the install/model/install.php and cli_install but it didn't work and i have checked the file permissions.

Note: The tables of Opencart are getting created inside the database.

Hopefully someone has a solution!

Install the OC v3.0.3.6 instead. This should solve the issue you're addressing. In lower releases, you need to go to your PHPMyAdmin's Opencart database and remove the event table. Then, from your install/opencart.sql file. Look for the oc_event section. Take that entire code section and paste in into your SQL table on your PHPMyAdmin.

Ensure that the table prefix matches the one you're using. Then, launch the query. This should resolve the issue.

straightlight wrote: ↑

Sun Nov 29, 2020 1:47 am

Install the OC v3.0.3.6 instead. This should solve the issue you're addressing. In lower releases, you need to go to your PHPMyAdmin's Opencart database and remove the event table. Then, from your install/opencart.sql file. Look for the oc_event section. Take that entire code section and paste in into your SQL table on your PHPMyAdmin.

Ensure that the table prefix matches the one you're using. Then, launch the query. This should resolve the issue.

I have tried what you have said about running the query inside PHPMyAdmin's Opencart database but i did get an error on this query:
INSERT INTO `oc_event` (`event_id`, `code`, `trigger`, `action`) VALUES
(1, 'voucher', 'catalog/model/checkout/order/addOrderHistory/after', 'extension/total/voucher/send');

#1364 - Field 'status' doesn't have a default value

And now i have tried to install v3.0.3.6 and again an error on step 3 http 500:

- mod_fcgid: stderr: PHP Fatal error: Uncaught Exception: Error: Field 'sort_order' doesn't have a default value<br />Error No: 1364<br />, referer: http://www.mywebsite.com/install/index. ... all/step_3
- mod_fcgid: stderr: INSERT INTO `oc_event` (`event_id`, `code`, `trigger`, `action`, `status`) VALUES, referer: http://www.mywebsite.com/install/index. ... all/step_3
- mod_fcgid: stderr: (1, 'activity_customer_add', 'catalog/model/account/customer/addCustomer/after', 'event/activity/addCustomer', 1);, referer: http://www.mywebsite.com/install/index. ... all/step_3
- mod_fcgid: stderr: in /var/www/vhosts/mywebsite.com/httpdocs/system/library/db/mysqli.php:40, referer: http://www.mywebsite.com/install/index. ... all/step_3
- mod_fcgid: stderr: Stack trace:, referer: http://www.mywebsite.com/install/index. ... all/step_3
- mod_fcgid: stderr: #0 /var/www/vhosts/mywebsite.com/httpdocs/system/library/db.php(45): DB\\MySQLi->query('\\n\\nINSERT INTO `...'), referer: http://www.mywebsite.com/install/index. ... all/step_3
- mod_fcgid: stderr: #1 /var/www/vhosts/mywebsite.com/httpdocs/install/model/install/install.php(26): DB->query('\\n\\nINSERT INTO `...'), referer: http://www.mywebsite.com/install/index. ... all/step_3
- mod_fcgid: stderr: #2 /var/www/vhosts/mywebsite.com/httpdocs/system/engine/loader.php(248): ModelInstallInstall->database(Array), referer: http://www.mywebsite.com/install/index. ... all/step_3
- mod_fcgid: stderr: #3 /var/www/vhosts/mywebsite.com/httpdocs/system/engine/proxy.php(47): Loader->{closure}(Array, Array), referer: http://www.mywebsite.com/install/index. ... all/step_3
- mod_fcgid: stderr: #4 /var/www/vhosts/mywebsite.com/httpdocs/install/controller/install/step_3.php(11): Proxy->__call('database', Array), referer: http://www.mywebsite.com/install/index. ... all/step_3
- mod_fcgid: stderr: #5 /var/www/vhosts/mywebsite.com/httpdocs/system/engine/action.php(79): Controlle in /var/www/vhosts/mywebsite.com/httpdocs/system/library/db/mysqli.php on line 40, referer: http://www.mywebsite.com/install/index. ... all/step_3