URGENT: SQL error!

[zhexiang]

I got this SQL error:

 

1054 - Unknown column 'accountholder' 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,accountholder, bankname, routingnumber, accountnumber, checknumber, accountholder, bankname, routingnumber, accountnumber, checknumber, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '1'

 

Does anyone know where to look for this SQL...??? Is it orders.php or account_history_info or somehwere else?

[natewlew]

I don't know what page that is from but there are a few columns that don't exist in the orders table. Did you install a contribution and forget to run a .sql file on your database?

[davidinottawa]

I got this SQL error:

 

1054 - Unknown column 'accountholder' 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,accountholder, bankname, routingnumber, accountnumber, checknumber, accountholder, bankname, routingnumber, accountnumber, checknumber, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '1'

 

Does anyone know where to look for this SQL...??? Is it orders.php or account_history_info or somehwere else?

 

BACK UP YOUR FILES BEFORE MAKING ANY CHANGES !

 

I can't be certain, but it is likely coming from the query function within the order class in the /includes/classes/order.php file.

 

This is the original :

$order_query = tep_db_query("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 from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

 

 

You have likely installed a mod or something.

 

david in ottawa