Describe the issue or problem
I am getting the following error when trying to import publications from XML I generated from the data from our earlier system using native tool:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (ojs2.submission_files, CONSTRAINT submission_files_source_submission_file_id_foreign FOREIGN KEY (source_submission_file_id) REFERENCES submission_files (submission_file_id) ON DEL) (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 (2023-09-19 09:48:13, 4, 2, 1, 1, 4, 2023-09-19 09:48:13, 1, 1))
Steps I took leading up to the issue
importing XML using native XML import tool. The submission file is embedded in XML. I have also set file id advice=“ignore” but I am now unsure how I should handle submission_file_ids in XML. What IDs should I set?
What application are you using?
OJS 3.4.0-3
/petri