OJS 3.1.1 to 3.2.1-4 ERROR: Upgrade failed: DB: Column 'publication_id' cannot be null

[israel.cefrin]

Hi @knjigor

I am aware you are attempting to upgrade OJS, however this solution for OMP might work, because it is a similar issue:

OMP Upgrade from 3.1.2-4 to 3.2.0, fatal error on getSupportedFormLocales()

Looking at the error, I tryed to extract from publication_formats values with submission_id = NULL Then I deleted the result records: SELECT pf.publication_format_id FROM publication_formats pf LEFT JOIN submissions s ON (pf.submissioion_id = s.submission_id) WHERE s.submission_id IS NULL; DELETE FROM publication_formats pf WHERE pf.publication_format_id = (int); So it worked!!! I sucessfully upgraded to 3.2.0. Now starts the climb to the 3.3

Best,
Israel