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 TABLE authors ALTER publication_id SET NOT NULL)
For testing purposes, I deleted all records that were in these cases, using the command:
delete from email_log where assoc_id is null;
delete from authors where publication_id is null;
But now I have the following error:
ERROR: Upgrade failed: DB: SQLSTATE[HY000]: General error: 7 number of parameters must be between 0 and 65535 (SQL: select “locale”, “submission_id” from “publications” where “publication_id” in ([…]))
Here we use postgresql, I believe it is one of the biggest installations that use postgresql as a database.
Could anyone help me with this error?
Regards,
Tarcisio Pereira.