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
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.
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'
I've sent a message to our developers to take a look at what you posted.
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
Here is the full text of the Gravity Forms Log showing the errors and then after I turned off Subscriptions, the successful transaction.
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?
