Guest Posted July 20, 2003 Posted July 20, 2003 I have been upgrading from an older version, and I think I almost have it, but when I try to run a test credit card order, I get : 1054 - Unknown column 'comments' in 'field list' insert into order(.....) TEP STOP looks like I am missing the comments field in my database, how can I add it, and does it have to be in the proper order?? Please help Doug
Rumble Posted July 20, 2003 Posted July 20, 2003 view the database of the new version you're updating to and there should be an insert line for the comments field, run that line of sql and it should add the field to your database! Reddy to Rumble Thank you osCommerce and all who Contribute to her!
Guest Posted July 20, 2003 Posted July 20, 2003 yes, I did get it fixed, by just manually adding it to a export of the data and tables, and then just ran it as a sql file. which seemed to fix that problem, but now I am getting another error: 1054 - Unknown column 'new_value' in 'field list' insert into orders_status_history (orders_id, new_value, date_added, customer_notified) values ('140', '1', now(), '1') [TEP STOP] this comes up when trying to process a transaction, not sure what page it is getting this new_value from, think it is on the checkout_process.php, but I cant seem to find it, anyone have any suggestions?? Doug
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.