Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Checkout Problem - Database Error


Guest

Recommended Posts

Hello,

 

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', '')

 

[TEP STOP]

 

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?

 

Thanks

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

Archived

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

×
×
  • Create New...