1054 unknown different messages

[claire310373]

Hi

I keep getting the following message when i try and update or invoice orders in admin, or when logged in as customer at confirmation (after checkout)

 

1054 - Unknown column 'cc_type' in 'field list'

 

select customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, cvvnumber, issue_number, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '5'

 

my payment methods are paypal nochex cheque/moneyorder & bank transfer.

 

Have searched forums, google and posted yesterday (in wrong place i think)..

any advice how to sort this or any ideas on how i can get more info will be much appreciated.

Thanks

claire

[strced]

Check your table structure (the orders table) with PhpMyAdmin and verify that it contains all the fields that you are running the query on. The field cc_type should be there unless you accidentally deleted it.