Can’t get Rates to work

Posted in

I just upgraded from 2.0 to 3.0 and I cannot get the new Rates to work. I went into Settings -> Commissions and used the buttons to generate rate entries from existing data, then changed from referral rate (legacy) to Rates. When I go to Rates and select New Rate and then Create, it does not create a new entry. It still says “no entry found”.

3 Responses to Can’t get Rates to work

  1. antonio February 9, 2018 at 6:46 pm #

    Hi James,
    The entry should be added, something is wrong. Please try enabling WordPress debug, editing your wp-config.php file and replace the following line:
    define('WP_DEBUG', false);
    with these lines:
    define('WP_DEBUG', true);
    define('WP_DEBUG_LOG', true);
    define('WP_DEBUG_DISPLAY', false);

    Then try to add a new rate entry. A new debug.log file must be created in your wp-content folder is there is a problem.
    Please send me this file to antonio[at]itthinx[dot]com indicating this topic.
    Kind Regards,
    Antonio B.

  2. James February 13, 2018 at 2:39 am #

    Hi Antonia,

    I think I discovered the problem. I manually copied the new Affiliates Pro 3.0.0 to my server via FTP. I did not update via wordpress. Now two table entries are missing as found in the debug log.

    [edited].wp_aff_rates doesn’t exist in my tables.

    I can manually go back to 2.18.1 if needed. Should I do this? Only problem is the plugin didn’t give me the “update” option since I needed the updated features in 3.0.0.

    Please advise. Debug log errors attached.

    -James

    [13-Feb-2018 02:26:26 UTC] WordPress database error Table ‘[edited].wp_aff_rates’ doesn’t exist for query SELECT rate_id FROM wp_aff_rates WHERE 1=1 AND type = ‘rate’ AND affiliate_id IS NULL AND group_id IS NULL AND object_id IS NULL AND term_id IS NULL AND level IS NULL AND integration IS NULL ORDER BY rate_id ASC LIMIT 1 made by do_action(‘affiliates_page_affiliates-admin-rates’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Affiliates_Rates_WordPress::affiliates_admin_rates, Affiliates_Rates_Table::render, Affiliates_Rate->exists, Affiliates_Rate::get_rate, Affiliates_Database_WordPress->get_objects

    [13-Feb-2018 02:26:26 UTC] WordPress database error Table ‘[edited].wp_aff_rates’ doesn’t exist for query INSERT INTO wp_aff_rates SET type = ‘rate’,value = ‘0.05’,description = ‘default’ made by do_action(‘affiliates_page_affiliates-admin-rates’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Affiliates_Rates_WordPress::affiliates_admin_rates, Affiliates_Rates_Table::render, Affiliates_Rate->create, Affiliates_Database_WordPress->query

    • antonio February 13, 2018 at 4:50 pm #

      Hi James,
      Please check that you have NOT selected the ‘Delete all plugin data on deactivation’ option from Affiliates->Settings:General. Then try to deactivate the plugin, and reactive it.
      If the problem persists, then try to go back to 2.8.1 and update.
      For security, first of all, make a full backup.
      Kind Regards,
      Antonio B.