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?
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
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.
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.