Author Topic: Failure at check out  (Read 3717 times)

Offline BrianHCombes

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Failure at check out
« on: March 27, 2019, 06:36:39 PM »
Hi,
All worked well prior to update to 1.2.14
Upon pressing the "Confirm Order" button an error pops up saying !error Application Error!. A waiting spinner also pops up and never times out.
However, the order is processed per my payment gateway (Authorize.net) but the shopping cart does not go to the "Thank You" page and does not notify my customers or my company of an order. The order DOES show in the Sales section of the Dashboard.

I was using the now deprecated version of Authorize.net_aim so I switched to the non AIM version extension. Unfortunately, having the same but slightly different problem with the added issue of payment method option not showing for the customer to select. I get around it by going to auto-detect (but only temporarily since I only take VISA and Mastercard.)

Note: The API for Authorize.net says they have changed the endpoints. This is my hunch as to the problem.

Please advise how to fix. Thanks!

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5777
  • Karma: +274/-2
    • View Profile
Re: Failure at check out
« Reply #1 on: March 28, 2019, 02:27:41 AM »
So do you use the very latest Authorize from 1.2.14? Try to re-save all Authorize extension settings in admin also check the AbanteCart error log in admin for the related errors

Offline maxter

  • Full Member
  • ***
  • Posts: 228
  • Karma: +64/-0
    • View Profile
Re: Failure at check out
« Reply #2 on: March 28, 2019, 07:32:37 AM »
If you still want to use AIM, you can get it from 1.2.13 version. Download 1.2.13 zip in the link below and get Authorize.net extension from there

https://github.com/abantecart/abantecart-src/releases


Offline BrianHCombes

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Failure at check out
« Reply #3 on: March 28, 2019, 11:31:45 AM »
Thanks for the responses.

Per Basara's comment I checked the error log and the problem is a missing MySQL database table.

Here's one of the error reports:
2019-03-27 21:24:42 - database error: AbanteCart core v.1.2.14 SQL Error: Table 'i758671_ac2.ac_product_stock_locations' doesn't exist
Error No: 1146

I'll double check and make sure I have the latest Authorize.net extension providing I'm able to stick with 1.2.14

Per maxter's comment, I'll drop back to 1.2.13 if needed. But hope to avoid that.

Thanks and I'll let you know.

Offline BrianHCombes

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Failure at check out
« Reply #4 on: March 28, 2019, 02:13:08 PM »
Went back to AbanteCart 1.2.13 and default_authorizenet_aim 1.0.1 and all is well.

Hope to upgrade latter when have time to test.

Note: I did verify I had the latest Authorize.net extension with AbanteCart 1.2.14 and still had the error.

Thanks!
« Last Edit: March 28, 2019, 02:16:03 PM by BrianHCombes »

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5777
  • Karma: +274/-2
    • View Profile
Re: Failure at check out
« Reply #5 on: March 29, 2019, 01:07:38 AM »
Here's one of the error reports:
2019-03-27 21:24:42 - database error: AbanteCart core v.1.2.14 SQL Error: Table 'i758671_ac2.ac_product_stock_locations' doesn't exist

Hi.
Error mean upgrade have missing SQL part. Database was not upgraded right

 

Powered by SMFPacks Social Login Mod