Importing XML of Issues Using Native Import/Export Plugin

Describe the issue or problem

I’m encountering an error when trying to import an exported XML of an issue into a newly created OJS website using the Native Import/Export XML plugin. The process fails with the following message:

The process failed. Check below for errors/warnings.
Errors occurred:
Generic Items

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ojs`.`submission_files`, CONSTRAINT `submission_files_source_submission_file_id_foreign` FOREIGN KEY (`source_submission_file_id`) REFERENCES `submission_files` (`submission_file_id`) ON DELETE) (SQL: insert into `submission_files` (`created_at`, `file_id`, `file_stage`, `genre_id`, `source_submission_file_id`, `submission_id`, `updated_at`, `uploader_user_id`, `viewable`) values (2024-10-31 14:47:00, 19, 2, 13, 15, 12, 2024-10-31 14:47:00, 1, 1))

I expected the import process to be completed successfully without any errors.

Steps I took leading up to the issue

  • Navigated to the Native Import/Export XML tool in the OJS dashboard.
  • Attempted to import an exported XML to a newly created OJS website.

What application are you using?

I’m using OJS version 3.4.0.7.

Any guidance on how to resolve this issue would be greatly appreciated.