Error Message

[Guest]

I just installed the Separate Price per customer contribution, version 4.0, and now I'm getting this error message when I try to bring up the customers list in the admin section:

 

1054 - Unknown column 'c.customers_group_id' in 'where clause'

 

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id, customers_groups cg where c.customers_group_id = cg.customers_group_id

 

[TEP STOP]

 

 

Anyone know how to get around this?

 

Thanks in advance!

[Guest]

I got it - I didn't notice that EMS MySQL manager had a problem with the following line in the install script:

 

ALTER TABLE customers

ADD customers_group_id smallint UNSIGNED NOT NULL default '0'

 

So I just ran these two lines, terminating w/ a semicolon, in the SQL editor and the field was added w/out a problem.