I have upgraded opencart to the latest version from 2.0.3 and updated plugins.
I am still getting 500 errors in the admin when trying to load up product info and having issues in trying to find and fix the issues.
From the ssl_error log.
Code: Select all
[Wed May 10 13:44:14.364418 2017] [fcgid:warn] [pid 31155] [client 66.249.66.152:46754] mod_fcgid: stderr: PHP Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'teknomodeltrucks_new.oc_product_tab' doesn't exist<br />Error No: 1146<br />SELECT t.tab_id, td.name, pt.text, t.position, t.show_empty FROM oc_product_tab pt LEFT JOIN oc_tab t ON (pt.tab_id = t.tab_id) LEFT JOIN oc_tab_description td ON (t.tab_id = td.tab_id) WHERE pt.product_id = '2756' AND td.language_id = '1' AND pt.language_id = '1' AND t.status = '1' AND ( t.show_empty = '1' OR NOT pt.text REGEXP '^[[:space:]]*$' ) ORDER BY t.position, t.sort_order, td.name' in /home/hp3-linc1-nfs1-x/620/332620/user/htdocs/system/library/db/mysqli.php:40
[Wed May 10 13:44:14.365371 2017] [fcgid:warn] [pid 31155] [client 66.249.66.152:46754] mod_fcgid: stderr: Stack trace:
[Wed May 10 13:44:14.365378 2017] [fcgid:warn] [pid 31155] [client 66.249.66.152:46754] mod_fcgid: stderr: #0 /home/hp3-linc1-nfs1-x/620/332620/user/htdocs/system/library/db.php(16): DB\\MySQLi->query('SELECT t.tab_id...', Array)
[Wed May 10 13:44:14.365382 2017] [fcgid:warn] [pid 31155] [client 66.249.66.152:46754] mod_fcgid: stderr: #1 /home/hp3-linc1-nfs1-x/620/332620/user/htdocs/vqmod/vqcache/vq2-catalog_model_catalog_product.php(747): DB->query('SELECT t.tab_id...')
[Wed May 10 13:44:14.365385 2017] [fcgid:warn] [pid 31155] [client 66.249.66.152:46754] mod_fcgid: stderr: #2 [internal function]: ModelCatalogProduct->getProductTabs('2756')
[Wed May 10 13:44:14.365394 2017] [fcgid:warn] [pid 31155] [client 66.249.66.152:46754] mod_fcgid: stderr: #3
Another issue which maybe related to the same problem is the same seo value has been applied (I dont know why) to most items which I believe is causing a conflict, I have attempted to fix via a spreadsheet upload programme to clear the value but the issue still persists.
If you go to https://www.teknomodeltrucks.co.uk/inde ... path=55_39 and hover over an item you will see what the URL is. Interestingly the quick look is correct. This maybe a theme issue?
Many thanks for any help.
Regards
Neal