Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error message after purchase in a.net AIM module


Recommended Posts

Posted

Hi All,

I recently installed Vger's authorize.net AIM module, and it works in both test and production mode (transactions are processed), but the customer gets this message after clicking "Confirm":

 

1054 - Unknown column 'comments' in 'field list'

 

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, comments, currency, currency_value) values ('2', 'Marisa Mitchell', '', '22 Valencia Ave', '', 'San Rafael', '94901', 'California', 'United States', '415 456 1216', '[email protected]', '2', 'Marisa Mitchell', '', '22 Valencia Ave', '', 'San Rafael', '94901', 'California', 'United States', '2', 'Marisa Mitchell', '', '22 Valencia Ave', '', 'San Rafael', '94901', 'California', 'United States', '2', 'Authorize.net AIM', 'Visa', 'Marisa Mitchell', '4007000000027', '0107', now(), '1', 'blah blah blah', 'USD', '1.00000000')

 

[TEP STOP]

 

 

Can someone help me figure out the bug? I'm not very experienced, bear in mind. I'd like to get my shop functioning by monday if possible. Everything else is ready to go.

 

Thanks in advance for any assistance!!

Marisa

 

www.tinyfootprintsbaby.com (in test mode right now)

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.

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...