OJS 3.3.0.8 XML import error foreign key constraint fails

jhennig · November 19, 2021, 10:42pm

Hi. This problem is related to:

Problem description:
I took the pkp OJS test import file here:

pkp/ojs/blob/3_3_0-8/cypress/fixtures/export-issues.xml

<?xml version="1.0"?>
<issues xmlns="http://pkp.sfu.ca" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://pkp.sfu.ca native.xsd">
  <issue xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" published="0" current="0" access_status="1" url_path="test-issue">
    <id type="internal" advice="ignore">1</id>
    <description locale="en_US">&lt;p&gt;test 1 descr&lt;/p&gt;</description>
    <issue_identification>
      <volume>1</volume>
      <number>1</number>
      <year>2020</year>
      <title locale="en_US">test 1</title>
    </issue_identification>
    <last_modified>2020-03-10</last_modified>
    <sections>
      <section ref="ART" seq="0" editor_restricted="0" meta_indexed="1" meta_reviewed="1" abstracts_not_required="0" hide_title="0" hide_author="0" abstract_word_count="0">
        <id type="internal" advice="ignore">1</id>
        <abbrev locale="en_US">ART</abbrev>
        <title locale="en_US">Articles</title>
      </section>
    </sections>
    <covers>

This file has been truncated. show original

which works just fine on the import.

I replaced the submission_file/file/embed tag with href tag
(example: <href src="https://hcmc.uvic.ca/~mholmes/ojs/christensen_1_15.pdf" mime_type="application/pdf"/>).

In the file tag I removed the filesize attribute and changed the @extension to .pdf

When running an import I get the error below. It seems href file imports do not work.

[19-Nov-2021 15:24:53 America/Edmonton] PHP Notice: Undefined variable: newFileId in /var/www/sites/scancan/lib/pkp/plugins/importexport/native/filter/NativeXmlSubmissionFileFilter.inc.php on line 338
[19-Nov-2021 15:24:53 America/Edmonton] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (jrnl_scancan.submission_files, CONSTRAINT submission_files_file_id_foreign FOREIGN KEY (file_id) REFERENCES files (file_id)) in /var/www/sites/scancan/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:115
Stack trace:
#0 /var/www/sites/scancan/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(115): PDOStatement->execute(NULL)
#1 /var/www/sites/scancan/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/sites/scancan/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(‘insert into `su…’, Array)
#3 /var/www/sites/scancan/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(631): Illuminate\Database\Connection- in /var/www/sites/scancan/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671

jhennig · November 29, 2021, 7:30pm

I believe filesize is the culprit. Is this attribute mandatory?

jhennig · December 3, 2021, 6:21pm

The filesize attribute does look mandatory as the import now seems to work properly although we are running into another problem where pdf’s are not showing up which I am not sure yet if it’s related. One thing I noticed is the physical file names are random alphanumeric names like:
61aa42a9b3370.pdf

and not the typical structure of various ID’s from the database. Is this supposed to happen?

Jeremy