Guest Posted May 13, 2003 Posted May 13, 2003 Im getting this error in a couple of places 1054 - Unknown column 'new_value' in 'field list' insert into orders_status_history (orders_id, new_value, date_added, customer_notified) values ('55', '1', now(), '1') [TEP STOP] The first one is in the admin > orders page and the other is when i use a third party test transaction such as 2checkout when i return to oscommerce from there site. Please help, i need the store to be open next week. Thanks in advance. pr
Guest Posted May 13, 2003 Posted May 13, 2003 I had a similar problem and the only way I fixed it was to start over with a new installion and I carefully merged the database data. I dont get it anymore , but what it ws that a value was conflicting. Good luck
Guest Posted May 13, 2003 Posted May 13, 2003 Im afraid its far too late for that...... Im sure its something to do with the Gift Voucher system but im not really a database wiz so its something i need to get help on. Thanks for the reply PR
wizardsandwars Posted May 13, 2003 Posted May 13, 2003 You just need to add a colum to the table. Do you have phpmyadmin? It normally comes estandard with cpanel. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
Guest Posted May 13, 2003 Posted May 13, 2003 Yes i have phpmyadmin and use it quite frequently. Not sure what parameters to set and in what table. This one is confusing. Thanks for the reply PR
wizardsandwars Posted May 13, 2003 Posted May 13, 2003 Well, in the 'orders_status_history ' table, you need to inser a column named 'new_value' right after the 'orders_id' column. You should make it a char 3, and it should not allow nulls. Hope that helps. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
Guest Posted May 13, 2003 Posted May 13, 2003 Thanks for the reply wizard, i created the new column in the database and it worked but then i got the same error but with 'old value', so i just did the same and added that. It seems to work fine now. Thanks for the reply, its really appreciated. Regards PR
wizardsandwars Posted May 13, 2003 Posted May 13, 2003 :wink: ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.