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

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

We use cookies to optimize your experience on our site and assume you're OK with that if you stay.
OK, hide this message.

Affiliates · Contact · Jobs · Terms & Conditions · Privacy Policy · Documentation · Downloads · Useful Plugins · My Account

Share