Affiliates Users Generating PHP Errors Upon Registration

—

by

Jay

Hi,

Ok, so I have a WordPress multisite setup consisting of Affiliates Pro, s2Member Integration and Affiliates Users.

The plugins have been activated on a per-site basis (i.e. NOT network activated).

Everything works perfectly. However, looking at my logs every time a new referral is created upon registration, a series of PHP errors appear.

As I said, everything works fine, but I thought I’d point out these errors in the hope of fixing any bugs.

Here are the errors generated:

WordPress database error Table 'buydrive_wp.wp_aff_affiliates' doesn't exist for query INSERT INTO `wp_aff_affiliates` (`name`,`email`,`from_date`) VALUES ('testuser ','[EMAIL REDACTED]','2014-04-21') made by register_new_user, wp_create_user, wp_insert_user, do_action('user_register'), call_user_func_array, msum_add_roles, add_user_to_blog, do_action('add_user_to_blog'), call_user_func_array, Affiliates_Users::add_user_to_blog, Affiliates_Users::maybe_create_affiliate, Affiliates_Registration::store_affiliate

WordPress database error Table 'buydrive_wp.wp_aff_affiliates_users' doesn't exist for query SELECT wp_aff_affiliates.affiliate_id FROM wp_aff_affiliates_users LEFT JOIN wp_aff_affiliates ON wp_aff_affiliates_users.affiliate_id = wp_aff_affiliates.affiliate_id WHERE wp_aff_affiliates_users.user_id = 27 AND wp_aff_affiliates.status ='active' made by register_new_user, wp_create_user, wp_insert_user, do_action('user_register'), call_user_func_array, msum_add_roles, add_user_to_blog, do_action('add_user_to_blog'), call_user_func_array, Affiliates_Users::add_user_to_blog, Affiliates_Users::maybe_create_affiliate, affiliates_get_user_affiliate

WordPress database error Table 'buydrive_wp.wp_3_aff_affiliates' doesn't exist for query INSERT INTO `wp_3_aff_affiliates` (`name`,`email`,`from_date`) VALUES ('testuser ','[EMAIL REDACTED]','2014-04-21') made by register_new_user, wp_create_user, wp_insert_user, do_action('user_register'), call_user_func_array, msum_add_roles, add_user_to_blog, do_action('add_user_to_blog'), call_user_func_array, Affiliates_Users::add_user_to_blog, Affiliates_Users::maybe_create_affiliate, Affiliates_Registration::store_affiliate

WordPress database error Table 'buydrive_wp.wp_3_aff_affiliates_users' doesn't exist for query SELECT wp_3_aff_affiliates.affiliate_id FROM wp_3_aff_affiliates_users LEFT JOIN wp_3_aff_affiliates ON wp_3_aff_affiliates_users.affiliate_id = wp_3_aff_affiliates.affiliate_id WHERE wp_3_aff_affiliates_users.user_id = 27 AND wp_3_aff_affiliates.status ='active' made by register_new_user, wp_create_user, wp_insert_user, do_action('user_register'), call_user_func_array, msum_add_roles, add_user_to_blog, do_action('add_user_to_blog'), call_user_func_array, Affiliates_Users::add_user_to_blog, Affiliates_Users::maybe_create_affiliate, affiliates_get_user_affiliate

Any help?

Posted in

Comments

3 responses to “Affiliates Users Generating PHP Errors Upon Registration”

  1. Jay Avatar
    Jay

    Hi,

    That’s right, only one of my multisite websites has the plugins activated.

    So this is expected behaviour then, and nothing to worry about?

    Or should I just go ahead activate the plugins on each site?

    Thanks

    1. kento Avatar
      kento

      Hi Jay,

      It happens because the plugin fails to check a dependency, it shouldn’t be producing that error message so this can be considered a bug. I’ll review the plugin and make sure it makes the appropriate checks before getting to that stage where the error is produced. Thanks for pointing out the issue!

      I’ll post a follow-up here when the revised version is ready.

  2. kento Avatar
    kento

    Hi,

    This means that the Affiliates plugin and Affiliates Users plugin have not been activated on a particular site. The error messages say that a couple of the tables that these plugins use do not exist.

Share