Support

May 11, 2023 at 4:27 am

Wordpress 6.1.1, PHP 7.4.28, MySQL 5.1.56

On updating from EE v4.something to EE v5.0.3 the site was stuck in maintenance mode. I deleted the .maintenance file.

On performing the “Data Update to Event Espresso 5.0.0” I got the following. Is this anything to worry about?

Data Update to Event Espresso 5.0.0 Completed
Migrated 12 records successfully during Event Venue Relations
Migrated 50 records successfully during Event Venue Relations
Migrated 50 records successfully during Event Venue Relations
Migrated 50 records successfully during Event Venue Relations
WordPress database error: [Invalid default value for 'FSB_submitted']
CREATE TABLE wp_esp_form_submission ( FSB_UUID varchar(25) NOT NULL, FSC_UUID varchar(25) NOT NULL, TXN_ID int(10) DEFAULT NULL, FSB_data mediumtext DEFAULT NULL, FSB_submitted datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (FSB_UUID), KEY FSC_UUID (FSC_UUID), KEY TXN_ID (TXN_ID) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
Stack Trace:#0 /nfs/home3/home3/j/username/websitename/wp-content/plugins/event-espresso-core-reg/core/helpers/EEH_Activation.helper.php(657): EventEspresso\core\services\database\TableManager->createTable('wp_esp_form_sub...', 'FSB_UUID varcha...', 'InnoDB') #1 /nfs/home3/home3/j/username/websitename/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php(681): EEH_Activation::create_table('esp_form_submis...', 'FSB_UUID varcha...', 'InnoDB', true) #2 /nfs/home3/home3/j/username/websitename/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php(486): EE_Data_Migration_Script_Base->_create_table_and_catch_errors('esp_form_submis...', 'FSB_UUID varcha...', 'ENGINE=InnoDB', true) #3 /nfs/home3/home3/j/username/websitename/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_DMS_Core_5_0_0.dms.php(350): EE_Data_Migration_Script_Base->_table_is_new_in_this_version('esp_form_submis...', 'FSB_UUID varcha...', 'ENGINE=InnoDB') #4 /nfs/home3/home3/j/username/websitename/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php(433): EE_DMS_Core_5_0_0->schema_changes_before_migration() #5 /nfs/home3/home3/j/username/websitename/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php(336): EE_Data_Migration_Script_Base->_maybe_do_schema_changes(true) #6 /nfs/home3/home3/j/username/websitename/wp-content/plugins/event-espresso-core-reg/core/EE_Data_Migration_Manager.core.php(721): EE_Data_Migration_Script_Base->migration_step(50) #7 /nfs/home3/home3/j/username/websitename/wp-content/plugins/event-espresso-core-reg/core/EE_Data_Migration_Manager.core.php(835): EE_Data_Migration_Manager->migration_step() #8 /nfs/home3/home3/j/username/websitename/wp-content/plugins/event-espresso-core-reg/admin_pages/maintenance/Maintenance_Admin_Page.core.php(387): EE_Data_Migration_Manager->response_to_migration_ajax_request() #9 /nfs/home3/home3/j/username/websitename/wp-includes/class-wp-hook.php(308): Maintenance_Admin_Page->migration_step('') #10 /nfs/home3/home3/j/username/websitename/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters('', Array) #11 /nfs/home3/home3/j/username/websitename/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #12 /nfs/home3/home3/j/username/websitename/wp-admin/admin-ajax.php(188): do_action('wp_ajax_migrati...') #13 {main}Migrated 50 records successfully during Event Venue Relations