Hi @Adriano_Jose,
This message:
DB Error: ERROR: null value in column "submission_id" violates not-null constraint
…is caused by the ADODB library we rely on for schema management failing to drop a constraint in the database that has been removed from the XML schema descriptors. You should be able to correct it by running:
ALTER TABLE authors ALTER COLUMN submission_id DROP NOT NULL;
That modification should work fine on your current database; this will need to be run after the upgrade is executed, not before, in case you execute the upgrade again from backup for some reason.
There may be other cases like this (see also Error when updating from 3.1.2-4 to 3.2.0-1 with postgres - #5 by Adriano_Jose).
Longer term, we’re planning to stop using the ADODB library for schema management; see https://github.com/pkp/pkp-lib/issues/2493 for details.
Regards,
Alec Smecher
Public Knowledge Project Team