Guest Posted March 7, 2003 Posted March 7, 2003 The symptoms are listed here: http://www.oscommerce.com/forums/viewtopic.php?p=125850 1054 - Unknown column 'comments' in 'field list' insert into orders (.. yadda yadda 1054 - Unknown column 'new_value' in 'field list' insert into orders_status_history (orders_id, new_value, date_added, customer_notified) values ('22', '1', now(), '1') [TEP STOP] The comments field has moved from the order table to the orders_status_history and the new_value is now order_status in the order table. Had to change the checkout_process.php file to point the data to the right tables/fields. --------------- The problem is the following contributions with the MS1 db structure: Authorize.net CVV mod http://www.oscommerce.com/community/contributions,613 Authorize.net ADC mod http://www.oscommerce.com/community/contributions,725 The checkout_process.php file is trying to add data to a fields that no longer exist or have been moved and therefore stops in the process, not completeting the order and population of the db. We will get this added to the contrib. You can download the fixed file here: http://www.webhostsupply.com/osc/checkout_process.txt Then just change it from .txt to .php and place it in your /catalog/ dir. Quote
Guest Posted March 7, 2003 Posted March 7, 2003 Nearly forgot.... I figured out the problem but John Winningham from Genesis Internet was kind enough to properly fix the php code and will post it in the contrib section. http://www.genesis-internet.com/ Quote
d-woo Posted July 14, 2003 Posted July 14, 2003 Brad, When you upgraded to MS1 I know that the field comments is now not in the table orders but now in orders_status_history. When you upgraded, how (which SQL statements were used? )did you move the contents of comments from your pre MS1 table orders to the MS1 table orders_status_history? Are previous customers (from pre Quote
d-woo Posted July 14, 2003 Posted July 14, 2003 ....are customers from pre MS1 able to see their order history? Quote
d-woo Posted July 15, 2003 Posted July 15, 2003 Okay...I just discovered the answer. It was in the new MS2 installation in the extras folder. For anyone needing this, just run in the extras/pr21_to_pr22/order_comments.php file on your server. HTH Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.