Home Forums Plugin Support AffiliateWP MLM Spillover stop working

5 replies, 2 voices Last updated by Profile photo of Antonio Antonio 5 months, 1 week ago
  • Profile photo of AntonioAntonio
    Participant
    @remidastore
    #6868

    Hello
    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

    Attachments:
    You must be logged in to view attached files.
  • Profile photo of AntonioAntonio
    Participant
    @remidastore
    #6871

    [UPATE]
    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.

  • Profile photo of Christian FreemanChristian Freeman
    Participant
    @christianf
    #6921

    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?

  • Profile photo of AntonioAntonio
    Participant
    @remidastore
    #6925

    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 )

  • Profile photo of AntonioAntonio
    Participant
    @remidastore
    #6942
    This reply has been marked as private.
  • Profile photo of AntonioAntonio
    Participant
    @remidastore
    #6945

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