Database Error Upgrading from OMP 3.1.1-4 to 3.2.1-2

Software Support Open Monograph Press
, , ,
1

Hello, I’m trying to update the OMP from version 3.1.1-4 to 3.2.1-2, but when I run the update script it sends the error below. I ask for help if anyone knows what the solution is. I’m using the postgresql database.

ADOConnection._Execute(ALTER TABLE publication_formats ALTER COLUMN publication_id SET NOT NULL, false) % line 1241, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE publication_formats ALTER COLUMN publication_id SET NOT NULL) % line 528, file: Installer.inc.php
Installer.executeSQL(ALTER TABLE publication_formats ALTER COLUMN publication_id SET NOT NULL) % line 498, file: Installer.inc.php
Installer.executeSQL(Array[303]) % line 371, file: Installer.inc.php
Installer.executeAction(Array[3]) % line 263, file: Installer.inc.php

Errors occurred during installation:

  • A database error has occurred: ERROR: column “publication_id” contains null values
2

Hi @asmecher, i still don’t know why this error is happening, maybe my database is inconsistent and i don’t know how to fix it safely. where can I start to correct?

Thanks.
Regards.