Plugin Contributor
Lap
(@lapzor)
HI,
Can you please share the full / exact error message from the logfile with us and let me know what version of Mailchimp for WordPress you are using? Thank you!
[27-Feb-2020 17:25:30 UTC] WordPress database error ALTER command denied to user 'user'@'localhost' for table 'wp_mailchimp_carts' for query ALTER TABLE wp_mailchimp_carts ADD PRIMARY KEY (email); made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, MailChimp_WooCommerce_Admin->options_update, MailChimp_WooCommerce_Admin->update_db_check
Version 4.75
thanks
Plugin Contributor
Lap
(@lapzor)
This error is not coming from our plugin. Seems like the MailChimp for WooCommerce plugin maybe?
I do recommend fully switching to Mailchimp for WordPress to solve the issue 😉
Hope that helps. If you have any questions, please let me know!
Well when I disable your plugin the errors stop. In fact in order for me to copy the error, I had to enable your plugin and then wait for the error and then disable it. Now the errors have stopped
The plugin i am disabling is:
MC4WP: Mailchimp for WordPress
Just so we are not getting confused
Thanks and odd
I will disable the plugin for woo-commerce and enable yours and see what is happening
Thanks
Plugin Contributor
Lap
(@lapzor)
I’m sad to hear that other plugins create conflicts like this with Mailchimp for WordPress plugin and pretty strange conflict as well as Mailchimp for WordPress doesn’t use the table wp_mailchimp_carts, doesn’t have hooks with the names MailChimp_WooCommerce_Admin->* and doesn’t alter tables unless *maybe* during some specific plugin update procedures.
I do know a number of our users have both our plugin and MailChimp for WooCommerce active at the same time, and while I don’t recommend that setup, this is the first time we hear about this error.
Hope that helps. If you have any questions, please let me know!
Yeap, the errors have gone so may have been an issue with having them both installed
Sorry and thanks
Plugin Contributor
Lap
(@lapzor)
Glad to hear you got it solved this way. Thanks for letting us know about the problem.