Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

error on final purchase confirmation!!!!!!!!!!!!!!!!!!!!!!!!


Guest

Recommended Posts

:(

hello does anyone know how to fix this ERROR!!!!! it pops up when a person clicks confirm order!

here is the error message:

 

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

 

insert into orders (customers_id, customers_name, 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_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, comments, currency, currency_value) values ('2', 'Marty Thurman', '3100 w cami ave', '', 'post falls', '83854', 'Idaho', 'United States', '222-222-2222', '[email protected]', '2', 'shjkh kusaman', '3600 w tami ave', '', 'post', '83356', 'Idaho', 'United States', '2', 'Cash on Delivery', '', '', '', '', now(), '1', '', 'USD', '1.00000000')

 

[TEP STOP]

 

 

 

thanks alot for your help!

Marty

Link to comment
Share on other sites

that's a lot of exclamation points.

 

what version of osc do you have? i have "comments" in the orders_status_history table in MS1.

 

in checkout_success.php, you can comment/take out/move the comments entry:

 

'comments' => $order->info['comments'])

 

should be in the $sql_data_array above this line:

 

tep_db_perform(TABLE_ORDERS, $sql_data_array);

 

but check your db and find out for sure which table your comments field is in.

 
Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...