Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error: 1054 In Admin Section v2.2 MS2


khokolate

Recommended Posts

I am getting the following error in a store I installed using the v2.2 MS2 with the PayPal IPN mod and Featured Products mod only.

 

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

select orders_status_id, date_added, customer_notified, comments from orders_status_history where orders_id = '12' order by date_added

[TEP STOP]

Link to comment
Share on other sites

Edit the admin/orders.php file and near the top you should find that query.

 

Change the orders_status_id to be orders_status_history_id and everything should be golden.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Ok this error was a result of MySQL not exporting the colums requested to the backup of the database and once I added the colums need by viewing the database layout image included with the MS2 files. I was able to see the colums missing. This issue has been resolved for me atleast.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...