wp_aff_rates table does not exist

Hi,

We recently upgraded to Affiliate Pro so that we could enter rates, however, it appears that upgrading from the free to pro version a table was not created to store the rates and as a result we are unable to create any rates.

It appears that I am having a similar issue to what is occurring in this thread:

Affiliates Rates Table Not Created Properly

Here is a relevant error log:

[client 2605:a000:4b8b:9100:e13f:aa24:f5c7:828e:16342] WordPress database error Table ‘wp_fudgeraiser.wp_aff_rates’ doesn’t exist for query INSERT INTO wp_aff_rates SET type = ‘rate’,value = ‘0.10’,description = ‘Default Rate’ /* From [fudgeraiser.com/wp-admin/admin.php?page=affiliates-admin-rates] in [/nas/content/live/fudgeraiser/wp-content/plugins/affiliates-pro/lib/ext/wordpress/class-affiliates-database-wordpress.php:45] */ 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, referer: https://fudgeraiser.com/wp-admin/admin.php?page=affiliates-admin-rates&_wpnonce=dfa261e957&action=create-rate

If you could send me the queries needed to properly setup the table or provide any additional support that would be greatly appreciated.

Thanks!
Jon

3 Responses to wp_aff_rates table does not exist

  1. George September 12, 2019 at 7:29 pm #

    Hey Jon that’s great, thanks for notifying me.

    Cheers,
    George

  2. Damon September 12, 2019 at 4:13 pm #

    Hi George,

    Thank you. Deleting and re-installing the plugin corrected the issue and we are now able to save rates.

    Thanks!
    Jon

  3. George September 11, 2019 at 8:38 am #

    Hi Jon,

    Thanks for mentioning that issue. But may I ask since you upgraded and installed Affiliates Pro, did you always get that error, or did the Rates feature stop unexpectedly? The reason for asking is simply because there are plugins for WordPress that offer database optimisation features but eventually can delete database tables without any particular reason. An example is WP Optimize plugin but any other similar plugins that are able to alter or delete tables can have the same results and break your database producing such errors.

    The easiest way to fix this, would be to deactivate and delete Affiliates Pro plugin and then reinstall it. Your Affiliates data will be kept intact as long as you don’t activate the option to Delete data under Affiliates > Settings.

    Kind regards,
    George

Only authorized members can comment on this topic.

Log in

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