account_history_info error

[guest99]

When I try to look at the details of my orders with account_history_info.php (from the acount_history.php page or from the confirmation email) I get the following error:

 

----

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

 

select 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, tracking_no, ship_date, delivery_date, carrier_id from orders where orders_id = '5'

 

[TEP STOP]

----

 

I don't know what causes it, but I did try to install a tracking number contribution a while ago, then had to remove it because it wasn't working.

 

Any help or ideas?

 

Thanks

[gscreations]

When I try to look at the details of my orders with account_history_info.php (from the acount_history.php page or from the confirmation email) I get the following error:

 

----

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

 

select 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, tracking_no, ship_date, delivery_date, carrier_id from orders where orders_id = '5'

 

[TEP STOP]

----

 

I don't know what causes it, but I did try to install a tracking number contribution a while ago, then had to remove it because it wasn't working.

 

Any help or ideas?

 

Thanks

 

sounds like you didn't completely remove all of the tracking code

 

i.e maybe these: tracking_no, ship_date, delivery_date, carrier_id

 

check the contribution again and back track all steps, or use the back up copy you have that you saved before adding the contribution, oh you did do that yes ?

[guest99]

Thanks very much, that was the problem. I had forgotten to remove line from an SQL query in orders.php.