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 admin
Name: Admin
Posts: 19626
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. 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.