arames Posted May 25, 2003 Posted May 25, 2003 I have the Old version 2.2 working great under http:/www.mydoamin.com/shop I have uploaded the new MS version under http://www.mydomain.com/testshop Now when I try to pass an order under the NEW version I get this strange 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 ('612', '1', now(), '1', 'this is a test. Hope it works') [TEP STOP] Please Help is Highly appreciated :oops:
arames Posted May 25, 2003 Author Posted May 25, 2003 I am desperate to get the new Version MS to get working... But everytime I try to pass an order I get: 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 ('612', '1', now(), '1', 'this is a test. Hope it works') [TEP STOP] Please, please please please HELP ME :oops: :(
hankfrid Posted May 25, 2003 Posted May 25, 2003 Your new snapshot is apparently using a copy of your older catalog database. New fields have probably been added between the versions you are using. I know I have seen numerous posts out here about just that field. If you do a search for *orders_status_id* you may find what you are looking for....don't forget to include the asterisks in the above search. HankFrid If I build it...they will come. If I don't try to build it.....I will never know!
hankfrid Posted May 25, 2003 Posted May 25, 2003 I found one in particular on a search that may prove helpful to you. It is http://www.oscommerce.com/forums/viewtopic.php...dersstatusid%2A Hope that helps, HankFrid If I build it...they will come. If I don't try to build it.....I will never know!
arames Posted May 25, 2003 Author Posted May 25, 2003 Thank you so much for your reply... :D I will check it out and come back to you if necessary. Thank you again :D
arames Posted May 28, 2003 Author Posted May 28, 2003 THey are talking about backing up, then reuploading the version.... But my only problem since I installed 2.2 MS.1 is that when people wants to pay the get: 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 ('612', '1', now(), '1', 'this is a test. Hope it works') [TEP STOP] can you please hel me since I am newbie in things called phpmyadmin ect... Your help is VERY MUCH appreciated :cry:
Recommended Posts
Archived
This topic is now archived and is closed to further replies.