Failure to import article through the Native XML plugin

Software Support Open Monograph Press
1

Apparently I’m facing this issue

https://github.com/pkp/pkp-lib/issues/8951

which is surprising to me, since - if I’m getting this right - this issue has been fixed.
I’m getting this error when trying to import via the Native XML-Plugin:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (omp.publications, CONSTRAINT publications_author_id FOREIGN KEY (primary_contact_id) REFERENCES authors (author_id) ON DELETE SET NULL) (SQL: update publications set date_published = ?, last_modified = 2024-11-04 12:54:24, primary_contact_id = 0, seq = 0, series_id = 1, submission_id = 13, status = 0, url_path = ?, version = 0, series_position = , doi_id = ? where publication_id = 13)

OMP version: 3.4.0.6
PHP version 8.2.20
Database driver mysql
Database server version 8.0.36

Has anyone ideas how I might be able to fix this? Thanks in advance.

2

Hi @rthiele,

Have you tried using mysqli as driver?

;;;;;;;;;;;;;;;;;;;;;
; Database Settings ;
;;;;;;;;;;;;;;;;;;;;;

[database]

driver = mysqli

Best regards,
Josh

3

Dear Josh,

very sorry for the late reply. That’s a good idea, I’ll give that a try. Thanks.

Best regards,
Raphael