problem with Affiliate Pro on www.kawaii.com

—

by

N

I can’t find a way to add a comment on a open support ticket, so I am sending this here as new ticket.

I re-installed wordpress on my site. This is the latest debug.log

Something with the column name: campaign_id seems to cause the trouble – how can I fix that !!!!

[01-Aug-2015 19:08:31 UTC] WordPress database error Duplicate column name ‘campaign_id’ for query ALTER TABLE u5sbqr_aff_hits
ADD COLUMN campaign_id BIGINT(20) UNSIGNED DEFAULT NULL,
ADD INDEX aff_hits_acm (affiliate_id, campaign_id); made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, affiliates_version_check, affiliates_update

[01-Aug-2015 19:10:54 UTC] WordPress database error Duplicate column name ‘campaign_id’ for query ALTER TABLE u5sbqr_aff_referrals
ADD COLUMN campaign_id BIGINT(20) UNSIGNED DEFAULT NULL,
ADD INDEX aff_referrals_ac (affiliate_id, campaign_id),
ADD INDEX aff_referrals_c (campaign_id); made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, affiliates_version_check, affiliates_update

Posted in

Comments

8 responses to “problem with Affiliate Pro on www.kawaii.com”

  1. Norman Avatar
    Norman

    Thanks Antonio,
    George already helped me to fix that problem
    ( I had to delete a option_version table in the database and reactivate the plugin) it works now.
    please close this ticket.

    1. antonio Avatar
      antonio

      Perfect 🙂

  2. Norman Avatar
    Norman

    Latest Debug File.

    [02-Aug-2015 19:03:44 UTC] WordPress database error Duplicate column name ‘campaign_id’ for query ALTER TABLE u5sbqr_aff_hits
    ADD COLUMN campaign_id BIGINT(20) UNSIGNED DEFAULT NULL,
    ADD INDEX aff_hits_acm (affiliate_id, campaign_id); made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, affiliates_version_check, affiliates_update
    [02-Aug-2015 19:03:44 UTC] WordPress database error Duplicate column name ‘campaign_id’ for query ALTER TABLE u5sbqr_aff_referrals
    ADD COLUMN campaign_id BIGINT(20) UNSIGNED DEFAULT NULL,
    ADD INDEX aff_referrals_ac (affiliate_id, campaign_id),
    ADD INDEX aff_referrals_c (campaign_id); made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, affiliates_version_check, affiliates_update

    [02-Aug-2015 19:03:45 UTC] WordPress database error Duplicate column name ‘campaign_id’ for query ALTER TABLE u5sbqr_aff_hits
    ADD COLUMN campaign_id BIGINT(20) UNSIGNED DEFAULT NULL,
    ADD INDEX aff_hits_acm (affiliate_id, campaign_id); made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, affiliates_version_check, affiliates_update
    [02-Aug-2015 19:03:45 UTC] WordPress database error Duplicate column name ‘campaign_id’ for query ALTER TABLE u5sbqr_aff_referrals
    ADD COLUMN campaign_id BIGINT(20) UNSIGNED DEFAULT NULL,
    ADD INDEX aff_referrals_ac (affiliate_id, campaign_id),
    ADD INDEX aff_referrals_c (campaign_id); made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, affiliates_version_check, affiliates_update

    1. antonio Avatar
      antonio

      Hi Norman,
      if you don’t have referrals data and affiliates data important (your affiliates program doesn’t run in production), you can try to delete the plugin with the option “Delete all plugin data on deactivation” selected (in Affiliates->Settings)
      Then reinstall the pro version.
      Kind regards,
      Antonio B.

  3. Norman Avatar
    Norman

    i went into my phpMyAdmin
    I only found one table that includes the word _options
    but there is no affiliates_plugin_version inside.

    I also searched the whole database for: affiliates_plugin_version
    and i could not get any results

  4. Norman Avatar
    Norman

    Do I have to delete all my Affiliates Data ?

  5. Norman Avatar
    Norman

    Antonio, thanks for the message.
    Actually I tried, but I am not able to find this information.
    I had regular Affiliates installed and than upgraded to Affiliate Pro.
    Is there a way you can fix that for me ? What do you recommend ?

  6. antonio Avatar
    antonio

    Hi Norman,
    this column is added when you have registered an Affiliates version older than 2.8.0. Maybe your system has recorder an incorrect plugin version.
    You can check it in your database, table wp_options, option_name = ‘affiliates_plugin_version’
    Regards,
    Antonio B.

Share