Problem upgrading to OJS 3.4.0-4 from 3.3.0-14 during I7014_DoiMigration

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

  1. Imported DB Dump in local dev environment
  2. 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))**

Hey @mlfct, thanks for sharing all those details. You should be able to address this issue by viewing the response in this post: Another upgrade from 3.3 to 3.4 issue - fails with error about dois table. How to continue? - #8 by ewhanson

Feel free to let me know if you run into any trouble.

Regards,

Erik
PKP Team

Hi @ewhanson ,
thanks for getting back!

Unfortunately i already tried to run the query

select submission_id from submission_settings
where setting_name = 'datacite::registeredDoi'
and setting_value not in (
    select setting_value from publication_settings
    where setting_name = 'pub-id::doi'
);

and cleanup the results afterwards. Still get the same error as in the opening post, when the migration reaches the DoiMigration module though.

I guess the previous admin (on my side) already ran a migration, that failed.

Do you have another idea?

Hi @mlfct,

Sorry to hear that didn’t work. I’m trying to think through some other possibilities. From your original post, I’m guessing you register your DOIs with Datacite. At any point, did your journal register DOIs with another registration agency like Crossref?

Regards,

Erik
PKP Team

Hi @ewhanson,

At any point, did your journal register DOIs with another registration agency like Crossref?

No, we always used DataCite.

Is there maybe an option to get a more verbose debug output from the migration script?