Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

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


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'



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?



Link to comment
Share on other sites


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

  • Create New...