PKP PN behaves strange in version 3.1.2.4

Software Support
24

I see your database is missing a field, which is bad and might be the source of the problem.

Your database should have these two tables (they are created by the plugin):

  • pln_deposit_objects with these fields:
    deposit_object_id
journal_id
object_id
object_type
deposit_id
date_created
date_modified

And

  • pln_deposits with these fields:
    deposit_id
journal_id
uuid
status
date_status
date_created
date_modified
export_deposit_error <<< This field is missing

This SQL statement should be enough to fix this issue:
ALTER TABLE pln_deposits ADD COLUMN export_deposit_error VARCHAR(1000) NULL

Once you apply it, you can wait 1-2 days to recheck (the time for the task to run again).

I’ve created an issue to fix it here: Database is missing a field · Issue #35 · pkp/pln · GitHub

Best,
Jonas