Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Checkout Problem - Database Error


Recommended Posts



I was doing some testing with my store's checkout procedure. I had done this before and everything seemed to go well. However, this morning I get the following error:


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


insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('1', '1', now(), '1', '')




I'm guessing this is a database error, but I'm not too well-versed in MySQL to say for sure. Can anyone explain this to me and/or offer me a solution? Perhaps a preventative measure that might stop future occurrences of this?



Link to comment
Share on other sites

After asking around at a MySQL forum, the explanation I got was:


"It cant find 'orders_status_id' in the database."


If my memory serves me correctly, doesn't osC setup the database and its required fields? If so, then how could it be missing?? And what is the recommended way of correcting this problem?? Please help!


Thanks in advance.

Link to comment
Share on other sites


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

  • Create New...