MS1 To MS2 Upgrading features Got error.

[bac3]

I found several relevant post and they still no solution:

http://www.oscommerce.com/forums/index.php?sho...=0entry236358

 

:angry:

 

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 ('86', '1', now(), '1', '')

 

old structure:

 

create table orders_status_history (
 orders_status_history_id int(11) not null auto_increment,
 orders_id int(11) default '0' not null ,
 new_value int(5) default '0' not null ,
 old_value int(5) ,
 date_added datetime default '0000-00-00 00:00:00' not null ,
 customer_notified int(1) default '0' ,
 PRIMARY KEY (orders_status_history_id)
);

 

What is new_values and old_values refers to new dB structures?

 

DROP TABLE IF EXISTS orders_status_history;
CREATE TABLE orders_status_history (
  orders_status_history_id int NOT NULL auto_increment,
  orders_id int NOT NULL,
  orders_status_id int(5) NOT NULL,
  date_added datetime NOT NULL,
  customer_notified int(1) DEFAULT '0',
  comments text,
  PRIMARY KEY (orders_status_history_id)
);

 

What is orders_status_id? How do i know new_values is orders_status_id or older_values is orders_status_id?

[bac3]

I know how to fix it , i afarid my previous order history will got error.