OMP Updating from 3.1.2-4 to 3.2.1-4 [PostgresSQL]

Software Support
1

Hello,

I 'm upgrading OMP from version 3.1.2.4 to version 3.2.1.4 and got the following Error:

 PHP Warning:  pg_query(): Query failed: ERROR:  column "publication_id" contains null values in /var/www/html/omp-3.2.1-4/lib/pkp/lib/vendor/adodb/adodb-php/drivers/adodb-postgres7.inc.php on line 259

PKP-Database-Logger 1690238521,6617: -1: ERROR:  column "publication_id" contains null values

ERROR:  column "publication_id" contains null values

PostgreSQL version 9.6.22

This solution didn’t work for me:
https://forum.pkp.sfu.ca/t/ojs-problems-updating-from-3-2-1-1-to-3-3-0-10-lts-postgresql/73018

Do you have any idea?

2

Now aggregate part of the log:

........
[26-Jul-2023 22:37:07 UTC] Database query
CREATE TABLE publications (
publication_id           SERIAL,
date_published           DATE,
last_modified            TIMESTAMP,
locale                   VARCHAR(14),
primary_contact_id       INT8,
publication_date_type    VARCHAR(32) DEFAULT 'pub',
publication_type         VARCHAR(32) DEFAULT 'publication',
seq                      FLOAT8 DEFAULT 0 NOT NULL,
series_id                INT8,
series_position          VARCHAR(255),
submission_id            INT8 NOT NULL,
status                   SMALLINT DEFAULT 1 NOT NULL,
url_path                 VARCHAR(64),
version                  INT8,
                 PRIMARY KEY (publication_id)
)
[]
[26-Jul-2023 22:37:07 UTC] Database query
CREATE INDEX publications_submission_id ON publications (submission_id)
[]
[26-Jul-2023 22:37:07 UTC] Database query
CREATE INDEX publications_section_id ON publications (series_id)
[]
[26-Jul-2023 22:37:07 UTC] Database query
DROP INDEX publication_format_submission_id
[]
[26-Jul-2023 22:37:07 UTC] Database query
ALTER TABLE publication_formats ALTER COLUMN publication_format_id TYPE INT8
[]
[26-Jul-2023 22:37:07 UTC] Database query
ALTER TABLE publication_formats ALTER COLUMN publication_format_id SET NOT NULL
[]
[26-Jul-2023 22:37:07 UTC] Database query
ALTER TABLE publication_formats ADD COLUMN publication_id INT8
[]
[26-Jul-2023 22:37:07 UTC] SQLSTATE[23502]: Not null violation: 7 ERROR:  column "publication_id" contains null values (SQL: ALTER TABLE publication_formats ALTER COLUMN publication_id SET NOT NULL
........

We would welcome any idea that we wish to be able to advance.

Regards.