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
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.
Perfect 🙂
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
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.
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
Do I have to delete all my Affiliates Data ?
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 ?
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.