Sage payment gateway issue in upgraded zencart 1.3.9

Recently i upgraded my zen-cart version from 1.3.8 to 1.3.9h. I am using GoDaddy linux hosting platform php 5.2.14 with curl enabled & MySQL 5.0. In my earlier version 1.3.8, i was using sage payment module (net1.php) from http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_48&products_id=580 and it was working fine.

After upgrading to 1.3.9h the gateway is not working properly. If i am using a test card 4111111111111111, then it shows the error message in address bar of bowser (https://example.com/store/index.php?main_page=checkout_payment&error_message=There+has+been+an+error+processing+your+credit+card.+Please+try+again.) and the page became blank.

If i am using a real card then, i am getting some error message "1062 Duplicate entry '0' for key 1
in:
[INSERT INTO orders_total (orders_id, title, text, value, class, sort_order) VALUES ('2413', 'Sub-Total:', '$45.00', '45', 'ot_subtotal', '100')]" in customer browser window but the card is debited and the transaction is showing in my merchant account. But the order is not reflecting in admin dashboard also.

So i would like to know Where is the problem ? I have upgraded 2/3 times, if is there any problem in up-gradation. Or this module is not compatible with 1.3.9.

Kindly Help.

~JP

Kind request to the author of this module to update this module.

Thanks,

~JPanda

Kind request to the author of this module to update this module.

I doubt that's going to happen. It was last updated in 2007 and is only valid for Zen Cart version 1.3.7.

There is a later one than that, provided by CEON, but even that free add-on is out of date and no longer supported from the Zen Cart site, only as a paid download from CEON's website.

Vger