OJS update (from 3.3.0 to 3.4.0) fails: `a foreign key constraint fails: doi_settings_doi_id_foreign`

[ewhanson]

Hi @Commifreak, I’ve seen a few cases with similar errors. Let me know if any of the info in this thread is helpful:

Another upgrade from 3.3 to 3.4 issue - fails with error about dois table. How to continue?

Hi @cager, Thanks for sharing those details. It looks like there are entries in your database for Datacite when the DOIs don’t exist on the OJS side of things. When an article DOI is created in OJS, it’s stored in the publication_settings table with a setting_name of pub-id::doi. When the DOIs are registered with Datacite, they will have two rows added to the submission_settings table—one with a setting name of datacite::registeredDoi and another with a setting name of datacite::status. If you…