Describe the issue or problem
I am currently running into issues migrating to the latest OJS version. After applying a few recommended fixes (dropping already existing dois and doi_settings tables and removing orphaned entries , the migration is stuck with the following error:
**ERROR: Upgrade failed: DB: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `ojs`.`doi_settings`.`doi_id` at row 1 (SQL: insert into `doi_settings` (`doi_id`, `setting_name`, `setting_value`) values (, registrationAgency, DataciteExportPlugin))**
Steps I took leading up to the issue
- Imported DB Dump in local dev environment
- Ran ./tools/upgrade.php upgrade
What application are you using?
Migration from OJS 3.3.0-14 to OJS 3.4.0-4
Additional information
2024-01-12 13:46:38 [migration: APP\migration\upgrade\v3_4_0\I6093_AddForeignKeys]
2024-01-12 13:47:09 [migration: APP\migration\upgrade\v3_4_0\MergeLocalesMigration]
2024-01-12 13:47:58 [migration: PKP\migration\upgrade\v3_4_0\FailedJobsMigration]
2024-01-12 13:47:58 [migration: PKP\migration\upgrade\v3_4_0\UpgradeMigration]
2024-01-12 13:47:59 [migration: APP\migration\upgrade\v3_4_0\I6807_SetLastModified]
2024-01-12 13:47:59 [migration: APP\migration\upgrade\v3_4_0\I4235_OAISetSpec]
2024-01-12 13:47:59 [migration: APP\migration\upgrade\v3_4_0\I7264_UpdateEmailTemplates]
2024-01-12 13:48:00 [migration: APP\migration\upgrade\v3_4_0\I7596_RemoveNonExpiring]
2024-01-12 13:48:00 [migration: APP\migration\upgrade\v3_4_0\I7014_DoiMigration]
2024-01-12 13:48:08 [revert migration: APP\migration\upgrade\v3_4_0\I7596_RemoveNonExpiring]
2024-01-12 13:48:08 [revert migration: APP\migration\upgrade\v3_4_0\I7264_UpdateEmailTemplates]
2024-01-12 13:48:09 [revert migration: APP\migration\upgrade\v3_4_0\I4235_OAISetSpec]
2024-01-12 13:48:09 [revert migration: APP\migration\upgrade\v3_4_0\I6807_SetLastModified]
2024-01-12 13:48:09 [revert migration: PKP\migration\upgrade\v3_4_0\UpgradeMigration]
2024-01-12 13:48:10 [revert migration: PKP\migration\upgrade\v3_4_0\FailedJobsMigration]
2024-01-12 13:48:10 [revert migration: APP\migration\upgrade\v3_4_0\MergeLocalesMigration]
2024-01-12 13:48:10 [downgrade for "APP\migration\upgrade\v3_4_0\MergeLocalesMigration" unsupported: Downgrade not supported]
**ERROR: Upgrade failed: DB: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `ojs`.`doi_settings`.`doi_id` at row 1 (SQL: insert into `doi_settings` (`doi_id`, `setting_name`, `setting_value`) values (, registrationAgency, DataciteExportPlugin))**