Affiliates Rates Table Not Created Properly

—

by

James

Hello,

Please supply me with the code to generate the new rates table. It does not create the table correctly when installing 3.0.0+ and the new rates do not work.

I’ve deleted, re-installed, etc and it fails to auto update. I just need this darn table created and life should be peachy for me.

Errors in debug.log:
[05-Apr-2018 23:54:58 UTC] WordPress database error Table ‘cinchwp.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-settings’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Affiliates_Settings::admin_settings, do_action(‘affiliates_settings_section’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Affiliates_Admin_Menu_WordPress::affiliates_settings_section, Affiliates_Admin_Menu_WordPress::affiliates_admin_settings, Affiliates_Upgrade_3::form, Affiliates_Upgrade_3::create_all_rates, Affiliates_Upgrade_3::create_general_rate, Affiliates_Rate->exists_other, Affiliates_Rate->exists, Affiliates_Rate::get_rate, Affiliates_Database_WordPress->get_objects
[05-Apr-2018 23:54:58 UTC] WordPress database error Table ‘cinchwp.wp_aff_rates’ doesn’t exist for query INSERT INTO wp_aff_rates SET type = ‘rate’,value = ‘0.05’,description = ‘Automatically generated from general rate.’ made by do_action(‘affiliates_page_affiliates-admin-settings’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Affiliates_Settings::admin_settings, do_action(‘affiliates_settings_section’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Affiliates_Admin_Menu_WordPress::affiliates_settings_section, Affiliates_Admin_Menu_WordPress::affiliates_admin_settings, Affiliates_Upgrade_3::form, Affiliates_Upgrade_3::create_all_rates, Affiliates_Upgrade_3::create_general_rate, Affiliates_Rate->create, Affiliates_Database_WordPress->query

Posted in
Tags , , ,

Comments

3 responses to “Affiliates Rates Table Not Created Properly”

  1. James Avatar
    James

    Thank you Kento. Here is the history.

    1) manually updated from 2.0.18? To 3.0.x. Because my updater plugin serial was wrong and wasn’t giving me the auto update option.
    2) realized a table update was required for 3.0.
    3) manually reverted to 2.0.18 and fixed updater serial.
    4) used auto update. Did not complete successfully.
    5) deleted affiliates pro plugin.
    6) installed via zip file 3.0 successfully.
    7) table still does not exist.

    My server uses auth keys and is not easy to give temporary access. Please provide the MySQL query to create the table myself. If that doesn’t fix the problem. I will find a way to grant you access.

    Thank you.
    -Jim

    1. Kento Avatar
      Kento

      Many thanks Jim, I’m sending you the queries directly to your email right now – please test them and let me know if you need any further help.

  2. Kento Avatar
    Kento

    Hi James,

    The table should be created without any problems upon update but it seems that in this case something is preventing the system to have this work. Can we have a closer look at your setup to make sure that things will work properly and rule out any conflicts or errors? Please provide temporary admin and FTP access to support at itthinx dot com also to your phpMyAdmin and we will check this and create the missing table for you. If you just want the query to create the table please let me know, but I would really recommend to let us have a look to make sure things will go smoothly.

    Cheers

Share