Guest Posted March 19, 2003 Share Posted March 19, 2003 I wonder what error this is and how to fix it.. It comes up when i try to enter http://www.convoymail.no/catalog/checkout_process.php 1054 - Unknown column 'comments' in 'field list' insert into orders (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, date_purchased, orders_status, comments, currency, currency_value) values ('2', 'Christian Tveitan', 'ingen', 'Bokelundveien 5', '', 'Stokke', '3160', 'Vestfold', 'Norway', '33364933', '[email protected]', '1', 'Christian Tveitan', 'ingen', 'Bokelundveien 5', '', 'Stokke', '3160', 'Vestfold', 'Norway', '1', 'Christian Tveitan', 'ingen', 'Bokelundveien 5', '', 'Stokke', '3160', 'Vestfold', 'Norway', '1', 'Cash on Delivery', '', '', '', '', now(), '1', '', 'NOK', '1.00000000') [TEP STOP] Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 basically you have an insert statement that is trying to add data to a field in the database that doesn't exist. More precisely, in an insert statement in checkout_process.php 'comments' has been named as a field in the table 'orders' and this field does not exist in the table 'orders' hope this makes it as clear as mud :wink: cheesr barry Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 Anyone now how to fix this?? Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 try and keep questions on the forum, that way other people can get the benefit of the solution. first of all: what snapshot or release are you using. have you done any modifications? these answers will help us to help you. cheers barry Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2003 Share Posted March 19, 2003 try and keep questions on the forum, that way other people can get the benefit of the solution. first of all: what snapshot or release are you using. have you done any modifications? these answers will help us to help you. cheers barry I use snap shot 2.2 Haven?t done any mod excpt some credit card modules.. It has worked a long time.. This happend suddenly.. I realy need help to get it to work again... Link to comment Share on other sites More sharing options...
wizardsandwars Posted March 19, 2003 Share Posted March 19, 2003 does a 'Comments" field exist in the orders database? If not, does one of the CC modules you have installed try to insert comments into a comments field that doesn't exist? That's what it looks like to me. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
Tarnadair Posted March 19, 2003 Share Posted March 19, 2003 You'll have to compare your snapshot and the file versions used in the credit card modules. Specifically, I think you'll find your problem is because they moved the order "comments" from the "order" table to the "order_status_history" table on version 1.21 of checkout_process.php. You can see the change in cvs here: http://cvs.tep.sourceforge.net/cgi-bin/vie...out_process.php Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.