|
amirabile
|
January 26, 2024 at 9:42 am
Updating Event Espresso using WordPress Dashboard Updates today caused a database error.
WordPress database error: [Multiple primary key defined]
ALTER TABLE wp2w_esp_status ADD PRIMARY KEY (STS_ID)
An error has occurred:
EEH_Activation – create_database_tables – 690
Stack Trace:#0 /home/customer/www/cshni.org/public_html/wp-content/plugins/event-espresso-core-reg/core/helpers/EEH_Activation.helper.php(642): EventEspressocoreservicesdatabaseTableManager->createTable(‘wp2w_esp_status’, ‘STS_ID varchar(…’, ‘InnoDB’) #1 /home/customer/www/cshni.org/public_html/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php(682): EEH_Activation::create_table(‘esp_status’, ‘STS_ID varchar(…’, ‘InnoDB’, false) #2 /home/customer/www/cshni.org/public_html/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php(610): EE_Data_Migration_Script_Base->_create_table_and_catch_errors(‘esp_status’, ‘STS_ID varchar(…’, ‘ENGINE=InnoDB’, false) #3 /home/customer/www/cshni.org/public_html/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_DMS_Core_5_0_0.dms.php(748): EE_Data_Migration_Script_Base->_table_has_not_changed_since_previous(‘esp_status’, ‘STS_ID varchar(…’) #4 /home/customer/www/cshni.org/public_html/wp-content/plugins/event-espresso-core-reg/core/helpers/EEH_Activation.helper.php(685): EE_DMS_Core_5_0_0->schema_changes_before_migration() #5 /home/customer/www/cshni.org/public_html/wp-content/plugins/event-espresso-core-reg/core/helpers/EEH_Activation.helper.php(100): EEH_Activation::create_database_tables() #6 /home/customer/www/cshni.org/public_html/wp-content/plugins/event-espresso-core-reg/core/EE_System.core.php(570): EEH_Activation::initialize_db_and_folders() #7 /home/customer/www/cshni.org/public_html/wp-includes/class-wp-hook.php(324): EE_System->initialize_db_if_no_migrations_required(”) #8 /home/customer/www/cshni.org/public_html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(”, Array) #9 /home/customer/www/cshni.org/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #10 /home/customer/www/cshni.org/public_html/wp-content/plugins/event-espresso-core-reg/core/EE_System.core.php(1087): do_action(‘AHEE__EE_System…’) #11 /home/customer/www/cshni.org/public_html/wp-includes/class-wp-hook.php(324): EE_System->perform_activations_upgrades_and_migrations(”) #12 /home/customer/www/cshni.org/public_html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array) #13 /home/customer/www/cshni.org/public_html/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #14 /home/customer/www/cshni.org/public_html/wp-settings.php(643): do_action(‘init’) #15 /home/customer/www/cshni.org/public_html/wp-config.php(109): require_once(‘/home/customer/…’) #16 /home/customer/www/cshni.org/public_html/wp-load.php(50): require_once(‘/home/customer/…’) #17 /home/customer/www/cshni.org/public_html/wp-admin/admin-ajax.php(22): require_once(‘/home/customer/…’) #18 {main}
Please let me know what I need to do to resolve this error.
Best,
Anthony Mirabile
|
|
Tony
|
January 26, 2024 at 2:43 pm
Hi Anthony,
Are you still getting this error now or did it throw once and then EE ran afterwards? (I’m assuming the latter based on the error itself)
If no error is currently being thrown you can safely continue to use EE, the above is an error from a migration running on a table that already exists.
|
