ERROR: column "publication_id" contains null values

[israel.cefrin]

Hi @miguelazzurri

Checking your SQL query:

@miguelazzurri

SELECT c.citation_id FROM citations c LEFT JOIN submissions s ON (c.submission_id = s.submission_id) WHERE s.submission_id IS NULL;

Why are you checking citations table and the submissions_id from it? Maybe you could check the
publications table and the publication_id column.

Also, there is a thread where other individuals are discussing OJS upgrade using PGSQL as database. It might give a few more hints about your own issue here:

OJS problems updating from 3.2.1.1 to 3.3.0-10 LTS [POSTGRESQL]

Hi, I am testing updating my OJS version to the latest available today. From 3.2.1.1 to 3.3.0-10 I encountered some data consistency issues: ERROR: Upgrade failed: DB: SQLSTATE[23502]: Not null violation: 7 ERROR: column “assoc_id” of relation “email_log” contains null values (SQL: ALTER TABLE email_log ALTER assoc_id SET NOT NULL) and ERROR: Upgrade failed: DB: SQLSTATE[23502]: Not null violation: 7 ERROR: column “publication_id” of relation “authors” contains null values (SQL: ALTER…

Best,
Israel