Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Error message after purchase in a.net AIM module


Recommended Posts

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', 'mnmitchell@gmail.com', '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')





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



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

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.

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