Support

Home Forums Event Espresso Premium Mailchimp Addon – Database error

Mailchimp Addon – Database error

Posted: February 24, 2020 at 6:49 pm

Viewing 7 reply threads


melissa smith

February 24, 2020 at 6:49 pm

When I activated the Mailchimp addon, there was a database error that automatically put my website into maintenance mode until I deactivated the plugin.

Can you tell me what might have caused this and what I can do to fix it?


Josh

  • Support Staff

February 24, 2020 at 7:40 pm

Hi,

May I ask what was the error message, or did it say the data for the MailChimp add-on needs to be migrated (which should put Event Espresso into maintenance mode so you can run the database migration).


melissa smith

February 27, 2020 at 12:15 pm

[0] => Event Espresso Level 2 Maintenance mode is active. That means EE can not run ANY database queries until the necessary migration scripts have run which will take EE out of maintenance mode level 2. Please inform support of this error.. Stack-trace:#0 /var/www/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php(2984): EEM_Base->_do_wpdb_query('insert', Array)
#1 /var/www/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php(2789): EEM_Base->_insert_into_specific_table(Object(EE_Primary_Table), Array, false)
#2 /var/www/wp-content/plugins/event-espresso-core-reg/core/db_classes/EE_Base_Class.class.php(1851): EEM_Base->insert(Array)
#3 /var/www/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Change_Log.model.php(155): EE_Base_Class->save()
#4 /var/www/wp-content/plugins/eea-mailchimp/includes/EE_MCI_Controller.class.php(1187): EEM_Change_Log->log('mailchimp', Array, NULL)
#5 /var/www/wp-content/plugins/eea-mailchimp/includes/EE_MCI_Controller.class.php(117): EE_MCI_Controller->set_error(false)
#6 /var/www/wp-content/plugins/eea-mailchimp/includes/EE_MCI_Controller.class.php(99): EE_MCI_Controller->mci_is_api_key_valid('')
#7 /var/www/wp-content/plugins/eea-mailchimp/db/migration_scripts/2_0_0_stages/EE_DMS_2_0_0_mc_options.dmsstage.php(44): EE_MCI_Controller->__construct()
#8 /var/www/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_Data_Migration_Script_Stage.core.php(71): EE_DMS_2_0_0_mc_options->_migration_step(16)
#9 /var/www/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php(339): EE_Data_Migration_Script_Stage->migration_step(16)
#10 /var/www/wp-content/plugins/event-espresso-core-reg/core/EE_Data_Migration_Manager.core.php(664): EE_Data_Migration_Script_Base->migration_step(50)
#11 /var/www/wp-content/plugins/event-espresso-core-reg/core/EE_Data_Migration_Manager.core.php(780): EE_Data_Migration_Manager->migration_step()
#12 /var/www/wp-content/plugins/event-espresso-core-reg/admin_pages/maintenance/Maintenance_Admin_Page.core.php(362): EE_Data_Migration_Manager->response_to_migration_ajax_request()
#13 /var/www/wp-includes/class-wp-hook.php(288): Maintenance_Admin_Page->migration_step('')
#14 /var/www/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters('', Array)
#15 /var/www/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
#16 /var/www/wp-admin/admin-ajax.php(175): do_action('wp_ajax_migrati...')
#17 {main}
  • This reply was modified 4 years, 9 months ago by Tony. Reason: Removed majority of the migration report


Tony

  • Support Staff

February 27, 2020 at 12:36 pm

Hi Melissa,

Please update to the latest version of the MailChimp Add-on and retry.

If you go to Dashboard -> Plugins and don’t see an update available you can go to Event Espresso -> General Settings and hit save to force an update check.


melissa smith

February 27, 2020 at 12:57 pm

There are no plugin updates available, even after I force the update check. I have Version 2.4.4.p installed that I downloaded from your website yesterday.


Tony

  • Support Staff

February 27, 2020 at 1:14 pm

I pushed the update live today (about 15 minutes before I replied above).

The latest version is 2.4.5.p and has fixes for the error message you’ve reported.

You may need to update manually as the EE4 config hasn’t migrated yet.

De-activate and delete the current version of the EE4 MailChimp add-on.

Download the latest version from your account page and add it via Dashboard -> Plugins -> Add new -> Upload plugin.

Activate that version and continue with the migration, the above error should not be thrown and the migration should now work.


melissa smith

February 27, 2020 at 1:29 pm

*redacted*

  • This reply was modified 4 years, 9 months ago by Josh. Reason: same as before


Tony

  • Support Staff

February 27, 2020 at 2:03 pm

That’s the report from the previous migration (the line numbers don’t match up with the latest version), click ‘Next step’ at the bottom of the migration report and it should show you the option to continue the migration.

If not can you add a screenshot of the page you are on, please.

https://eventespresso.com/wiki/troubleshooting-checklist/#screenshots

If you click to continue with the latest version, the above error shouldn’t be thrown.

Viewing 7 reply threads

The support post ‘Mailchimp Addon – Database error’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso