Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problems Viewing An Order


Guest

Recommended Posts

I hope someone can help! When I click on a particular customer order, instead of the list of items ordered, and total, and the usual stuff, I get this:

---------------------------------------

1054 - Unknown column 'comments' in 'field list'

 

select 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, comments, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '360'

 

[TEP STOP]

-----------------------------------------

What does this mean? Can anyone help? Do you know what I can do to fix this problem?

 

Thanks in advance!

 

Azadeh

Link to comment
Share on other sites

Just to give more info... This problem appeared after I tried to up-grade a very old version of osCommerce. I wish I had just started from scratch to begin with but I did try to up-grade. Now everything is messed up! I am very much stuck!!!

 

Thanks for any help,

 

Azadeh :)

Link to comment
Share on other sites

Anyone?? Please help???

 

When I click packing slip or invoice this is what it says:

 

1054 - Unknown column 'comments' in 'field list'

 

select 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, comments, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '360'

 

[TEP STOP]

 

 

I have 7 orders which are paid for but I don't know what was ordered because of this! If you don't know what is wrong, can someone at least tell me how to look up what they ordered another way?

 

Please help! Thanks,

 

Azadeh

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...