Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

i need help with checking my orders


Recommended Posts

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'



i added the field manually and then i get a new error please help me

Link to comment
Share on other sites

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

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


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

  • Create New...