How to fix "1054 Unknown column 'G.name_en-GB' in 'field list"

24.08.2017 07:44
#1
shenkwen
Joomshopping forum user no avatar
Name: shenkwen
30.03.2012
Posts: 6
Quote
How to fix "1054 Unknown column 'G.name_en-GB' in 'field list"

Live page: http://bv.nycweb.io/index.php/traditional/cu73az

I have upgraded joomla 2.5 with JoomShopping 3.15.3 to Joomla 3.7.4 with JoomShopping 4.16.2. What I did was strictly following the instruction and make sure I didn't miss any upgrade package ( I think

On front end when I go to an item's page, I got this error shown on the page(without PHP error):1054 Unknown column 'G.name_en-GB' in 'field list'.

I've searched this forum, although many posts are about 1054 error, but they are about other fields, also their versions are different from mine. I've also checked this page https://www.webdesigner-profi.de/joomla-webdesign/shop/addons/check-db-structure-table-shop.html?lang=en and downloaded "Check DB structure table shop 1.0.10 (JoomShopping 3.20.1 / 4.10.2)", which is of the closest version I can find. But it says "No error found" when I did "test tables and fields".

How do I fix this?


Joomla: 3.7.4
JoomShopping: 4.16.2
PHP: 5.6
MySQL: 5.7.19
Website Url: http://bv.nycweb.io/index.php/traditional/cu73az
 
24.08.2017 22:05
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 18198
Quote
Aw: How to fix "1054 Unknown column 'G.name_en-GB' in 'field list"

Problem in DB.

Your store without a license.
https://www.webdesigner-profi.de/joomla-webdesign/shop/license-key/joomshopping-licensekey.html
Buy a license key.

 
Copyrights MAXXmarketing GmbH. All Rights Reserved