We attempt to upgrade OMP from 220.127.116.11 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: 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?