Error when comfirming order pls help!!!
chuko <[email protected]>
| Newsgroups | gmane.comp.web.oscommerce.devel |
|---|---|
| Message-ID | <455c00192af4884e7b5203a823d5d764@osCommerce-Forums> |
This message was sent from: Development
http://forums.oscommerce.com/viewtopic.php?p=153943#153943
----------------------------------------------------------------
When I 'confirm order', I got the following error message, can anyone help, thank you,
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', 'John Doe', '3345 Oxwell Drive', '', 'Duluth', '30096', 'Georgia', 'United States', '12345', '[email protected]', '2', 'John Doe', '3345 Oxwell Drive', '', 'Duluth', '30096', 'Georgia', 'United States', '2', 'Credit Card', 'Visa', 'Norman Kwong', '4005750110365242', '0904', now(), '1', '', 'USD', '1.00000000')
[TEP STOP]