Post by 1stcomix » Tue Jan 28, 2014 10:08 pm

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
Last edited by 1stcomix on Sun Feb 02, 2014 8:12 am, edited 2 times in total.

New member

Posts

Joined
Tue Mar 13, 2012 3:59 pm

Post by MarketInSG » Wed Jan 29, 2014 1:29 am

go over to phpmyadmin and select your database, then select the table customer_group and add in the column 'name' with varchar (64)


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by 1stcomix » Wed Jan 29, 2014 9:41 pm

That fixed it. Thank You!

New member

Posts

Joined
Tue Mar 13, 2012 3:59 pm

User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by jmagro » Tue Jan 06, 2015 10:30 pm

Thank you. I just did this too. Works like a charm.

New member

Posts

Joined
Thu May 12, 2011 3:31 am
Who is online

Users browsing this forum: No registered users and 45 guests