This is a 6.x-4.3 ecommerce site upgraded from Drupal 5. When I try and check out, I get this error. I'm assuming it's literally some missing columns. I searched around the code to see what I could be missing, and how to re-create the fields, but no luck.
Can anyone help with these?

Thanks,
adam

user warning: Unknown column 'approval_code' in 'field list' query: INSERT INTO ec_receipt (ecid, type, extern_id, currency, amount, allocated, balance, status, response_text, description, created, changed, auth_net_subscr_id, approval_code) VALUES (24, 'authorize_net_aim_cc', '', 'USD', 0.03, 0, 0.03, 0, '', '', 1303312721, 1303312721, '', '') in /var/www/vhosts/.../httpdocs/includes/common.inc on line 3538.
·                             user warning: Duplicate entry '0' for key 'PRIMARY' query: INSERT INTO ec_transaction (ecid, type, mail, payment_method, allocation, workflow, shippable, currency, gross, allocated, balance, created, changed, duedate, token) VALUES (24, 'ec_cart', 'someone@somewhere.com', 'authorize_net_aim_cc', 0, 1, 0, 'USD', 0.02, 0, 0.02, 1303312721, 1303312721, 0, '') in /var/www/vhosts/.../httpdocs/includes/common.inc on line 3538.

Comments

gordon’s picture

gordon commented
Project: e-Commerce » e-Commerce | Authorize.net Payments
Version: 6.x-4.3 » 6.x-1.x-dev
Component: ec_checkout » Code
Priority: Normal » Critical

This is actually a issue with the upgrade in authorize_net. Transferring now.

nimzie’s picture

nimzie commented

Thanks for your attention gordon. I'm not familiar with "transferring" of an issue. I'm assuming it's in the right place now?
Has anyone got any insight as to this issue, and how I could fix or work around?
sincerely,
adam

nimzie’s picture

nimzie commented

Hi All, Still wondering how I am able to fix / work with this. I'm new to the authorize.net / ecommerce bits of Drupal and could really use a hand...

nimzie’s picture

nimzie commented

I am wondering if anyone can work on this bug with me. I'm about to have to gut this project and replace with different modules - which will make me sad...

johngonole’s picture

johngonole commented
Issue summary: View changes

Trying to reach out to Gordon. I'm a user of the E-commerce module latest drupal-6 version. I've always use PayPal however today they are having a major issue not just with my site but others in that they will not allow those wishing to pay with credit cards to checkout without first signing up for PayPal.

At any rate I've had it with PayPal and I'm hoping perhaps the authorize.net module or the eway module still works with the drupal-6 version of e-commerce.

Please reach out to me at mail@pdhlibrary.com

johngonole’s picture

johngonole commented

OK just a warning to other users who use this module. I installed this on my test site and basically ran in to the same errors above. then I installed it on another test site that is an exact clone of my production website. Same error. Only worse. When I disabled this module it completely broke my entire checkout and I've had to restore the website several times as I try to figure out how to get rid of it without breaking my site. This cloned site is running PHP 5.3.8 and this probably the biggest difference from my older test site which is already on a much newer version of PHP.

Bottom line is that unless this module is revived by the developer do not even attempt to install this module. If you do want to try it out than make sure you make a complete backup of your website that can be quickly restored because most likely this will break your site.