Guest Posted March 1, 2003 Share Posted March 1, 2003 when i need to check my orders i get this error: 1054 - Unknown column 'comments' in 'field list' select 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, comments, currency, currency_value, verisign_ref, date_purchased, orders_status, last_modified from orders where orders_id = '9' [TEP STOP] i added the field manually and then i get a new error please help me Link to comment Share on other sites More sharing options...
Tarnadair Posted March 1, 2003 Share Posted March 1, 2003 I had the same problem after updating, etc. Check your admin/includes/classes/order.php against the appropriate version in cvs. Oscommerce is looking for the "comments" entry in the wrong table as it was moved. Link to comment Share on other sites More sharing options...
Guest Posted March 1, 2003 Share Posted March 1, 2003 thx tarnadair i got that fixed. i found out it was a credit card problem so i had to delete and re install the module... lol but im having another problem. i am going to u Verisign for my credit card i installed it right but after check out and stuff i click confirm and it says merchant account not found on the VeriSign site. I am in test mode for VeriSign anyone know how i can get this to work pleaseeee responde 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.