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.

userregistration 1.5beta1 wp_rg_lead_meta SQL bug

Gravity Support Forums » Plugin Support » Gravity Forms User Registration Add-On

  1. martham
    Member

    Hi.

    On line 98 of signups.php there is an SQL statement that has a hardcoded "wp_" prefix on the rg_lead_meta table name. I made this change:

    // oldline
//        return $wpdb->get_var($wpdb->prepare("SELECT meta_value FROM wp_rg_lead_meta WHERE lead_id = %d AND meta_key = 'activation_key'", $lead_id));
// new line
          return $wpdb->get_var($wpdb->prepare("SELECT meta_value FROM {$wpdb->prefix}rg_lead_meta WHERE lead_id = %d AND meta_key = 'activation_key'", $lead_id));
    Copy

    and it solved the problem I was having because the database I am currently working with uses an alternate table name prefix.

    cheers, Martha

    Posted 12 years ago on Sunday December 30, 2012 | Permalink

  2. Chris Hajer
    Key Master

    Thank you for that information. I will bring it to the attention of the development team.

    Posted 12 years ago on Sunday December 30, 2012 | Permalink

  3. Steve Holland
    Member

    I reported this a couple of weeks ago and it has been fixed in the latest version (v1.5 beta 1.6).

    Posted 12 years ago on Monday December 31, 2012 | Permalink

  4. Chris Hajer
    Key Master

    Thanks for the update Steve. Martha, if you would like a copy of 1.5beta6, please send me an email at chris@rocketgenius.com and I will email you the latest version. Thank you.

    Posted 12 years ago on Monday December 31, 2012 | Permalink