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

  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));

    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 11 years ago on Sunday December 30, 2012 | Permalink
  2. Thank you for that information. I will bring it to the attention of the development team.

    Posted 11 years ago on Sunday December 30, 2012 | Permalink
  3. I reported this a couple of weeks ago and it has been fixed in the latest version (v1.5 beta 1.6).

    Posted 11 years ago on Monday December 31, 2012 | Permalink
  4. 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 11 years ago on Monday December 31, 2012 | Permalink