@codysq
Are you using WordPress SEO by Yoast by any change – this is a known conflict with that plugin – workaround details here:
https://subscribe2.wordpress.com/support/conflicts/
If not then try using core theme and disabling all other plugins. Then re-introduce your theme and plugins one at a time until you find the conflict.
Thread Starter
codysg
(@codysg)
@mattyrob
I tried switching to Twenty Seventeen, and disabling every plugin except subscribe2. I’m not even able to manually toggle users. I actually picked this up out of the error log, with user email omitted for privacy
[Thu Aug 10 21:20:57.367559 2017] [:error] [pid 5860] [client 66.90.136.117:29541] WordPress database error Unknown column ‘conf_date’ in ‘field list’ for query UPDATE wp_subscribe2 SET active=’1′, conf_date=CURDATE(), conf_time=CURTIME(), conf_ip=’Importer’ WHERE CAST(email as binary)=’REDACTED@REDACTED.COM’ /* From [independence.staging.wpengine.com/wp-admin/admin.php?page=s2_tools&orderby=date&order=desc] in [/nas/content/staging/independence/wp-content/plugins/subscribe2/classes/class-s2-core.php:797] */ made by do_action(‘subscribe2_page_s2_tools’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, s2_admin->subscribers_menu, require_once(‘/plugins/subscribe2/admin/subscribers.php’), s2class->toggle, referer: http://independence.staging.wpengine.com/wp-admin/admin.php?page=s2_tools&orderby=date&order=desc
@codysg
It would seem that you are either using an older version of Subscribe2 that doesn’t have all of the required columns for the importer you are using, or on upgrading at some point the columns have not been created as they should have been.
If you can access the database directly via PHPMyAdmin or similar the subscribe2 table should have the following columns:
id – the user id
email – the user email
active – if the user is active or not
date – date email was entered in form
time – time email was entered in form
ip – ip used to enter email in form
conf_date – date email was confirmed
conf_time – time email was confirmed
conf_ip – ip used to confirm email
If the column isn’t there you can create it, it would seem only the last three will be missing for you, con_date is a ‘DATE’ field, conference_time is ‘TIME’ and confidence_ip is ‘char(64)’.
Thread Starter
codysg
(@codysg)
@mattyrob
That worked, thanks for the help!
