Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Authorize.net CVV and ADC fix for MS1


Guest

Recommended Posts

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.

Link to comment
Share on other sites

  • 4 months later...

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...