Page 1 of 1

[SOLVED] Error 1054 During Upgrade

Posted: Tue Jan 28, 2014 10:08 pm
by 1stcomix
I was going through the upgrade sequence from ver. 1.5.1.3 to ver. 1.5.6.1. At step 9 (Goto Admin->System Settings), when I click the 'edit' link under 'Settings', I get the following error ...

Notice: Error: Unknown column 'name' in 'order clause'
Error No: 1054
SELECT * FROM customer_group ORDER BY name ASC in /home/nstcom5/public_html/dev/system/database/mysql.php on line 50

Re: Error 1054 During Updrade

Posted: Wed Jan 29, 2014 1:29 am
by MarketInSG
go over to phpmyadmin and select your database, then select the table customer_group and add in the column 'name' with varchar (64)

Re: Error 1054 During Upgrade

Posted: Wed Jan 29, 2014 9:41 pm
by 1stcomix
That fixed it. Thank You!

Re: Error 1054 During Upgrade

Posted: Wed Jan 29, 2014 10:53 pm
by MarketInSG
glad to be of help :D

Re: [SOLVED] Error 1054 During Upgrade

Posted: Tue Jan 06, 2015 10:30 pm
by jmagro
Thank you. I just did this too. Works like a charm.