Home Forums Plugin Support AffiliateWP MLM Spillover stop working

5 replies, 2 voices Last updated by  Antonio 1 year, 1 month ago
  • Antonio

    Yesterday my client that runs affiliate Wp MLM on his site noticed me that the matrix is not more spilling over.

    So I’ve investigated:
    I’ve installed on a clean wordpress + woocommorce + affiliateWp ( last update so is 2.0.5)
    I’ve installed AffiliateWp MLM ( downloaded from my backoffice) and set all like in the attached picture (screenshot1).
    i’ve created 13 user (diretto1, diretto2, …, diretto13) and manually added to the affiliate 1
    I supposed that the diretto9 goes under diretto1 as spilled over but still add new affiliate at the first level of the matrix ( I suppose is something in AffiliateWp becouse before some upgrades the spillover worked fine) as you can see in the screenshot2

    You must be logged in to view attached files.
  • Antonio

    Checking the debug log I’ve found that sometimes MLM tries to write twice a field that as been alredy wrote.

    WordPress database error Duplicate entry ’13’ for key ‘PRIMARY’ for query INSERT INTO mrr_affiliate_wp_mlm_connections (affiliate_id, affiliate_parent_id, direct_affiliate_id, matrix_level) VALUES (’13’, ‘2’, ‘1’, ‘2’) made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, affwp_do_actions, do_action(‘affwp_add_affiliate’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, affwp_process_add_affiliate, affwp_add_affiliate, Affiliate_WP_DB_Affiliates->add, do_action(‘affwp_insert_affiliate’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, affwp_mlm_connect_affiliates, affwp_mlm_add_affiliate_connections

    In this case I’ve that configuration on the tab MISC on Affiliate WP Settings:

    Allow Affiliate Registration ON
    Require Approval: OFF
    Auto Register New Users: OFF

    If I add an user in wp-admin and the I affiliate him I’ve the above error.

  • Christian Freeman

    Hi Antonio,

    How exactly did you add the new affiliate to create this error? Did you add them via the Add New Affiliate screen, or using the affiliate registration button from the Edit User screen in WordPress?

  • Antonio

    I’m still investigating:
    It happens with the 2.05 version of affiliate Wp
    The problem comes when an affiliate is added on registration.

    I’m, this weekend, going to set a site from the scratch with Woocommerce, Affilaite Wp and Affiliate MLM + Ranks + Level and check.

    ( also I’ll test diff’rent version of PHP )

  • Antonio
    This reply has been marked as private.
  • Antonio

    I’ve made ( modifing another plugin) a Plugin that checks on affiliate registration form if the sponsor (referral link) is correct and allow the new user to insert by himself ( it search if the name written exist).
    Now I’ve to figure out how this modification locks your plugin.

You must be logged in to reply to this topic.