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

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

Live page:

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 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:
24.08.2017 22:05
(Support Team)
User webdesigner
Name: Admin
Posts: 18745
Aw: How to fix "1054 Unknown column 'G.name_en-GB' in 'field list"

Problem in DB.

Your store without a license.
Buy a license key.

Copyrights MAXXmarketing GmbH. All Rights Reserved