Post by nealt » Wed May 10, 2017 9:17 pm

Hi,

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
I have tried the fixes located here viewtopic.php?f=191&t=166012&sid=318cf4 ... 74fad22853

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

Newbie

Posts

Joined
Wed May 10, 2017 8:56 pm
Who is online

Users browsing this forum: No registered users and 17 guests