Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


radmil

Recommended Posts

Dear all,

Please help,

 

When I try to see my order info it gets this message!!!

 

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, date_purchased, orders_status, last_modified from orders where orders_id = '3'

 

[TEP STOP]

http://www.vremeto.org - Weather in Stambolijski, 4210, BG
Link to comment
Share on other sites

I'm just migrating my old db to the latest version and came across this when importing the cust. stuff into the DB...

 

I found they've take the 'comments' field out of the 'orders' table. These comments are the ones you make in the 'admin' part for an order.

 

I'm now trying to figure out how the hell I import the cust data into me DB :(

 

Anyone else got issues?

 

John

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...