Describe the issue or problem
Upgrading from ojs 3.3.0-13 script fails on APP\migration\upgrade\v3_4_0\I7014_DoiMigration
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
Launch db check then upgrade
php8.2 tools/upgrade.php check
[Ok, no warn, no err]
php8.2 tools/upgrade.php upgrade
Results below
What application are you using?
ojs 3.3.0-13 attempt to upgrade 3.4.0-3
Additional information
Log info :
2023-10-16 15:37:18 [migration: PKP\migration\upgrade\v3_4_0\I8060_UpdateUserLocalesDefaultToEmptyArrayFromNull]
2023-10-16 15:37:18 [migration: PKP\migration\upgrade\v3_4_0\I7245_UpdateUserLocaleStringToParsableJsonString]
2023-10-16 15:37:20 [migration: APP\migration\upgrade\v3_4_0\I7129_IssueEntityDAORefactor]
2023-10-16 15:37:20 [migration: APP\migration\upgrade\v3_4_0\I6091_AddFilterNamespaces]
2023-10-16 15:37:21 [migration: APP\migration\upgrade\v3_4_0\I3573_AddPrimaryKeys]
2023-10-16 15:37:42 [migration: APP\migration\upgrade\v3_4_0\I6093_AddForeignKeys]
2023-10-16 15:38:10 [migration: APP\migration\upgrade\v3_4_0\MergeLocalesMigration]
2023-10-16 15:38:28 [migration: PKP\migration\upgrade\v3_4_0\FailedJobsMigration]
2023-10-16 15:38:28 [migration: PKP\migration\upgrade\v3_4_0\UpgradeMigration]
2023-10-16 15:38:28 [migration: APP\migration\upgrade\v3_4_0\I6807_SetLastModified]
2023-10-16 15:38:28 [migration: APP\migration\upgrade\v3_4_0\I4235_OAISetSpec]
2023-10-16 15:38:28 [migration: APP\migration\upgrade\v3_4_0\I7264_UpdateEmailTemplates]
2023-10-16 15:38:29 [migration: APP\migration\upgrade\v3_4_0\I7596_RemoveNonExpiring]
2023-10-16 15:38:29 [migration: APP\migration\upgrade\v3_4_0\I7014_DoiMigration]
2023-10-16 15:38:38 [revert migration: APP\migration\upgrade\v3_4_0\I7596_RemoveNonExpiring]
2023-10-16 15:38:38 [revert migration: APP\migration\upgrade\v3_4_0\I7264_UpdateEmailTemplates]
2023-10-16 15:38:39 [revert migration: APP\migration\upgrade\v3_4_0\I4235_OAISetSpec]
2023-10-16 15:38:39 [revert migration: APP\migration\upgrade\v3_4_0\I6807_SetLastModified]
2023-10-16 15:38:39 [revert migration: PKP\migration\upgrade\v3_4_0\UpgradeMigration]
2023-10-16 15:38:39 [revert migration: PKP\migration\upgrade\v3_4_0\FailedJobsMigration]
2023-10-16 15:38:39 [revert migration: APP\migration\upgrade\v3_4_0\MergeLocalesMigration]
2023-10-16 15:38:39 [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 columnojs
.doi_settings
.doi_id
at row 1 (SQL: insert intodoi_settings
(doi_id
,setting_name
,setting_value
) values (, registrationAgency, DataciteExportPlugin))
Could you help?
Thanks