Guest Posted April 23, 2003 Share Posted April 23, 2003 :( 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 More sharing options...
josheli Posted April 23, 2003 Share Posted April 23, 2003 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 More sharing options...
josheli Posted April 23, 2003 Share Posted April 23, 2003 ooops. i meant checkout_process.php, NOT checkout_success.php. sorry. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.