Invalid column reference: 7 ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

Dear all,
Sorry I didn’t reply previously, I’m on vacation and I’m restricting access to computers.

Details about the reported bug are described at the beginning of this track (first post), similar to the one reported by Dennis @drboone

I applied the fix (only this one of the issue to PostgreSQL, as suggested Resolve custom issue ordering error with PostgreSQL on publish · Issue #7590 · pkp/pkp-lib · GitHub
of [‘issue_id’, ‘journal_id’]
to [‘issue_id’]
on line 699 of the classes / issue / IssueDAO.inc.php file

I did a test run, creating a new edit and inserting an article using Quick Submit and no failures were found. I’m asking the editor to run the tests using the full submission process if this error persists and will post it here shortly.

Sincerely,
Augusto Torres

1 Like