problem editing orders in admin area

[Dennis Thompson]

I'm getting this error message when I try and edit any order information from the admin area, e.g url: /admin/orders.php?page=1&oID=374&action=edit

 

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 = '374' order by date_added

[TEP STOP]

 

i recently updated my osc install from 2.2 MS1 CVS to 2.2 MS2 and only just noticed the problem today!

 

Does anybody know what this problem could be?

[Guest]

You are missing the orders_status_id column in your orders_status_history table. Check out the table in phpMyAdmin.

[Dennis Thompson]

How many fields should I put in when creating it through phpMyAdmin ?

 

Can you give me some SQL to create it?

 

Many thanks