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

[ashlyn]

I have a small note at the bottom of the page in admin/customers/orders when I try to edit a certain order

 

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

 

select new_value, old_value, date_added, customer_notified from orders_status_history where orders_id = '2' order by orders_status_history_id desc

 

[TEP STOP]

 

I added the following to localisation/orders_status to get the orders to show in admin.. Received (default), Sent and Processing. These options show when I try to edit an order, but I get redirected to a new page with just this below printed on it

 

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

 

insert into orders_status_history (orders_id, new_value, old_value, date_added, customer_notified) values ('2', '2', '1', now(), '1')

 

[TEP STOP]

 

What is this, and how can I fix it? Any help much appreciated. This cart is going live this week and I'm finding bugs here and there.. It's probably something I did, but I just can't figure it out..

Many Thanks

[ashlyn]

PS, I just got a confirmation email that my order had been "sent". I did set it to that in admin and it is now listed as sent in admin also. I just don't like those error messages..

 

Thanks again

[ashlyn]

Don't know why but I fixed it. I just uploaded another copy of the orders.php file to admin and it's all working now..

 

Gremlins? :roll: