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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25854
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. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.