Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

i need help with checking my orders


Guest

Recommended Posts

Posted

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

Posted

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.

Posted

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

Archived

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

×
×
  • Create New...