Error related to old gravity forms leads table.

[aneumann-cafb]

We are seeing the following error when submitting a donation



We tracked this down to the following function in the latest version of the plugin.

/wp-content/plugins/gravity-forms-click-pledge/class.GFCnpPlugin.php

  /**
  * check whether this form entry's unique ID has already been used; if so, we've already done a payment attempt.
  * @param array $form
  * @return boolean
  */
  protected function hasFormBeenProcessed($form) {
    global $wpdb;
    $unique_id = RGFormsModel::get_form_unique_id($form['id']);
    $sql = "select lead_id from {$wpdb->prefix}rg_lead_meta where meta_key='gfcnp_unique_id' and meta_value = \"%s\"";
    $lead_id = $wpdb->get_var($wpdb->prepare($sql, $unique_id));
    return !empty($lead_id);
  }

From what I can see this table 'wp_rg_lead_meta' was deprecated since gravity forms 2.3. See https://docs.gravityforms.com/databa...rence/#changes

Although the plugin says it supports the following version.

Release 3.700.007/WP:v5.2.1/GF:v2.4.9.5: May 30, 2019

Any assistance would be appreciated!

[aneumann-cafb]

I think the following should work in both legacy and current gravity forms.

/**
  * check whether this form entry's unique ID has already been used; if so, we've already done a payment attempt.
  * @param array $form
  * @return boolean
  */
  protected function hasFormBeenProcessed($form) {
    global $wpdb;
    $unique_id = RGFormsModel::get_form_unique_id($form['id']);
    $entry_table_name = version_compare( GFFormsModel::get_database_version(), '2.3-dev-1', '<' ) ? GFFormsModel::get_lead_table_name() : GFFormsModel::get_entry_meta_table_name();
    $sql = "select * from {$entry_table_name} where meta_key='gfcnp_unique_id' and meta_value = \"%s\"";
    $lead = $wpdb->get_row($wpdb->prepare($sql, $unique_id));
    return !empty($lead);
  }

[CnP.Support.AM]

Good day @aneumann-cafb

Sorry for the inconvenience and thank you for notifying us. We reviewed and identified the issue. We are working on it and will release the patch by tomorrow or day after. We will keep you update.

[CnP.Support.AM]

Good day @aneumann-cafb

We have released the compatible version of Gravity Forms today: https://forums.clickandpledge.com/fo...te-and-bug-fix

Please update and let us know if you find any issues.