Error when updating from 3.1.2-4 to 3.2.0-1 with postgres

Software Support
2

Hi @Adriano_Jose,

It looks like the ADODB library (which OJS relies on for schema management) is failing to drop the NOT NULL constraint on the journal_settings table. You can work around this by running the following query before the upgrade script:

ALTER TABLE journal_settings ALTER COLUMN setting_type DROP NOT NULL;

Regrads,
Alec Smecher
Public Knowledge Project Team

1 Like