Error in DoiMigration from 3.3.0-13 to 3.4.0-3

Software Support
,
1

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 column ojs.doi_settings.doi_id at row 1 (SQL: insert into doi_settings (doi_id, setting_name, setting_value) values (, registrationAgency, DataciteExportPlugin))

Could you help?

Thanks

2

Hi @parallel
I think upgrade failed in the first try then you tried to do the upgrade again so you got that error. this error occurred due to past failure upgrade. Try to restore your fresh back up ( files and database ) then repeat the upgrade process again. Hopefully you will success.

Regards,
-SALAM

3

Hi,

I tried to repeat the upgrade (i use VM snapshot due to files and db are in the same machine).
No way, same error.

4

Hey @parallel,

Thanks for sharing all the details. Happy to try and help.

Could you try running the upgrade with PHP 8.1?

Could you also share which database/database version you are using?

After the upgrade failure, are there any entries in the dois table that do not have a sequential int in the doi_id column, e.g. an empty string or null?

Regards,

Erik
PKP Team

6

Hey @parallel,

I came across a similar issue and the responses there might be helpful: Another upgrade from 3.3 to 3.4 issue - fails with error about dois table. How to continue? - #8 by ewhanson

Regards,

Erik
PKP Team

7

Hi @ewhanson,

I’ll try to upgrade again with this tip. I’ll let you know.

Thanks