Support

Home Forums Event Espresso Premium Invalid default value for 'FSB_submitted'

Invalid default value for 'FSB_submitted'

Posted: May 11, 2023 at 4:27 am

Viewing 1 reply thread


Jonathan

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


Tony

  • Support Staff

May 11, 2023 at 5:38 am

Hi there,

Event Espresso does not have a table called esp_form_submission, did you previously have some custom work done by a developer?

Viewing 1 reply thread

The support post ‘Invalid default value for 'FSB_submitted'’ 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