PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

There was an error processing your credit card - NO ERROR CODE PROVIDED

  1. Hi all,

    I've got a problem that it appears many people experience, where I attempt to process a card and I receive this error "There was an error processing your credit card". The common solution of looking for an error code in the source isn't working because there isn't an error code being generated.

    Here's the form: https://bhutancanada.org/donations/
    Password to view is: Bhutan!@

    Your help would be greatly appreciated.

    Thank you

    Posted 6 years ago on Thursday May 9, 2013 | Permalink
  2. David Peralty
    Administrator

    Can you download and install our Logging plugin which can be found at the bottom of our Download Gravity Forms page please? This might help find out the source of the issue.

    Posted 6 years ago on Thursday May 9, 2013 | Permalink
  3. Thanks David. I've installed the plugin and turned logging on.

    Here's a snippet:

    '[09-May-2013 15:01:12] WordPress database error Column 'form_id' in where clause is ambiguous for query SELECT l.id, l.transaction_id, m.meta_value as payment_date
    FROM bwcp_rg_lead l
    INNER JOIN bwcp_rg_lead_meta m ON l.id = m.lead_id
    WHERE form_id=5
    AND payment_status = 'Active'
    AND meta_key = 'subscription_payment_date'
    AND meta_value < '2013-04-09 00:00:00' made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, GFAuthorizeNet::init, GFAuthorizeNet::process_renewals
    [09-May-2013 15:01:20] WordPress database error Column 'form_id' in where clause is ambiguous for query SELECT l.id, l.transaction_id, m.meta_value as payment_date
    FROM bwcp_rg_lead l
    INNER JOIN bwcp_rg_lead_meta m ON l.id = m.lead_id
    WHERE form_id=5
    AND payment_status = 'Active'
    AND meta_key = 'subscription_payment_date'
    AND meta_value < '2013-04-09 00:00:00' made by require('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, GFAuthorizeNet::init, GFAuthorizeNet::process_renewals
    [09-May-2013 15:22:27] WordPress database error Column 'form_id' in where clause is ambiguous for query SELECT l.id, l.transaction_id, m.meta_value as payment_date
    FROM bwcp_rg_lead l
    INNER JOIN bwcp_rg_lead_meta m ON l.id = m.lead_id
    WHERE form_id=5
    AND payment_status = 'Active'
    AND meta_key = 'subscription_payment_date'
    AND meta_value < '2013-04-09 00:00:00' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, GFAuthorizeNet::init, GFAuthorizeNet::process_renewals'

    Posted 6 years ago on Thursday May 9, 2013 | Permalink
  4. Any thoughts on this?

    Posted 6 years ago on Thursday May 9, 2013 | Permalink
  5. David Peralty
    Administrator

    I've sent a message to our developers to take a look at what you posted.

    Posted 6 years ago on Thursday May 9, 2013 | Permalink
  6. Thanks David. I have an update.

    I had the form set to "Subscriptions" as one of the options is an ongoing monthly donation. When I set the form back to "Products and Services" everything works.

    For now we have taken out the ongoing monthly donation option and set the form to the products and services settings. Please let your team know that.

    If they need admin access for testing, let me know.

    Many thanks

    Ben

    Posted 6 years ago on Thursday May 9, 2013 | Permalink
  7. Here is the full text of the Gravity Forms Log showing the errors and then after I turned off Subscriptions, the successful transaction.

    http://pastie.org/private/ybqsmzr1azyfvgvo2on4xq

    Posted 6 years ago on Thursday May 9, 2013 | Permalink
  8. Hi, jauntmedia,

    The issue is the error "ambiguous column" being thrown. There is an updated version of Authorize.net that fixes this bug that is not yet available for public download. I would like to email this version to you (v1.3.4). Is the email address attached to this profile where I would send it?

    Posted 6 years ago on Thursday May 9, 2013 | Permalink
  9. Thanks Dana. 1.3.4 just appeared in our plugins menu as an update. We will test now.

    Posted 6 years ago on Friday May 10, 2013 | Permalink