OJS Export / Import

[daanlessing]

Good day,

I upgraded an instance of OJS from 3.1.2-4 to 3.4.0-5 to export the data and import it into our Multi Journal site.

First I exported the users and imported them to our multi-journal site by changing the context_id to match our journal site.

I then export an issue and when importing it to our OJS 3.4.0-5 site I get the following error:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (upojs.publications, CONSTRAINT publications_primary_contact_id FOREIGN KEY (primary_contact_id) REFERENCES authors (author_id) ON DELETE SET NULL) (SQL: update publications set access_status = 0, date_published = 2019-12-06, last_modified = 2025-02-03 11:09:50, primary_contact_id = 0, section_id = 14, seq = 11, submission_id = 5384, status = 3, url_path = ?, version = 1, doi_id = ? where publication_id = 5386)

Could someone please advise on what I should do, the best practice to move a journal, and import it into our multi-journal site?

Thank you in advance.

Regards,
Daan

[Dimitris_Efstathiou]

Hi @daanlessing, thanks for reporting that.

Can you check whether in your source installation, namely the 3.1.2-4 one, the specific publication_id has a primary_contact_id that can be found in the authors table?

Your case could be a data-integrity related issue in the source installation.