Help Critical error in Account history

[DK-Jensen]

Hi, Im getting this error :

 

1054 - Unknown column 'cc_transactionid' 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, currency, currency_value, date_purchased, orders_status, last_modified, cc_transactionid from orders where orders_id = '6'

 

[TEP STOP]

 

When a customor wants to see the Invoice on: (url to shop)/account_history_info.php/order_id/(invoice number)

 

I even get the error when i want to "Edit" the order in admin panel....

 

Whats the error you think?

[wheeloftime]

Hi, Im getting this error :

 

1054 - Unknown column 'cc_transactionid' 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, currency, currency_value, date_purchased, orders_status, last_modified, cc_transactionid from orders where orders_id = '6'

 

[TEP STOP]

 

When a customor wants to see the Invoice on: (url to shop)/account_history_info.php/order_id/(invoice number)

 

I even get the error when i want to "Edit" the order in admin panel....

 

Whats the error you think?

The cc_transactionid is not a default osC field so most likely you have installed a contribution for credit card handling and forgot to add that field to the database. Check the installation instructions again to see where it tells to run SQL statements on your database.

[DK-Jensen]

Thanks, Big help.... You where right... :D