OMP upgrade with PostgreSQL

[josekarvalho]

Hi,

We attempt to upgrade OMP from 3.1.1.3 to 3.3.0-10 and we found several issues regarding the SQL queries that are not compatible with PostgreSQL, only to Mysql.

There are other issues we found and we are not sure if some of the changes we made on the queries may have impact on the new instance or future upgrades.

This is an example: ERROR: Upgrade failed: DB: 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 had also this issue before with OJS, but now it seems to be corrected.

My question is if there are any plans to review these queries in OMP code?

Regards,

José Carvalho

[Vitaliy]

@josekarvalho

This is an example: ERROR: Upgrade failed: DB: 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)

Hi @josekarvalho,

This looks like the issue with data. The message says that the migration script failed to alter the column because it contains null values, publication_id shouldn’t be null in the publication_formats table. Do you have many such entries?