1054 - Unknown column 'c.customers_credit_account_status' in 'field list'

[Guest]

I hope I posted this in the right place... if not shoot me.. I didn't do it on purpose...

 

I installed the payment module and get the following error.

 

1054 - Unknown column 'c.customers_credit_account_status' in 'field list'

 

select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_credit_account_status, c.customers_credit_amount, c.customers_credit_status, c.customers_credit_left, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from customers c left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '2'

 

[TEP STOP]

 

I probably messed up something on install but could any of you give me some pointers about where to look and what to look for?

 

Thanks for your help.

 

Tim

[Guest]

I did not mention but I get this error when I try to edit or delete a customer file.

[insomniac2]

You can do this .. but if you have some sort of credit mod installed that placed the code customers_credit_account_status, in there ... you would have to doublecheck your installation.

 

If you know you don't need that customers_credit_account_status than do this:

 

Open your catalog/admin/customers.php

 

search for the queries that have customers_credit_account_status, in them and delete them.

Edited May 26, 2006 by insomniac2

[Guest]

I hope I posted this in the right place... if not shoot me.. I didn't do it on purpose...

 

I installed the payment module and get the following error.

 

 

Which payment module?

[Guest]

Which payment module?

 

Purchase order ver. 2.3 I thought I was putting this message under that thread...