Upgrading from 3.1.1.2 to 3.2.0.3 - ERROR

Hello there.

I’m upgrading from ojs 3.1.1.2 to 3.2.0.3, postgresql database.
And I got this error message:
[data: dbscripts/xml/upgrade/3.2.0_update.xml]
ERROR: Upgrade failed: DB: ERROR: null value in column “setting_type” violates not-null constraint
DETAIL: Failing row contains (238, , enableOai, 1, null).
It’s sound weird to me, like some data consistency problem.
Can someone please help me?

Regards,
Tarcisio Pereira

Hi @Tarcisio_Pereira,

See this post (and there may be more useful information elsewhere on the same thread): Error when updating from 3.1.2-4 to 3.2.0-1 with postgres - #2 by asmecher

Regards,
Alec Smecher
Public Knowledge Project Team

1 Like

Hi @asmecher

I hope this message finds you well.
I’m testing and I will let you know when I succeed.

Regards,
Tarcisio Pereira

Hi @asmecher

I’m still getting error.

[data: dbscripts/xml/upgrade/3.2.0_url_path.xml]
ERROR: Upgrade failed: DB: ERROR: value too long for type character varying(64)

I have already checked the pub-id::publisher-id:

SELECT * FROM issue_settings WHERE setting_name=‘pub-id::publisher-id’ AND LENGTH(setting_value) >= 64;
issue_id | locale | setting_name | setting_value | setting_type
----------±-------±-------------±--------------±-------------
(0 rows)

and

SELECT * FROM submission_galley_settings WHERE setting_name=‘pub-id::publisher-id’ AND LENGTH(setting_value) >= 64;
galley_id | locale | setting_name | setting_value | setting_type
----------±-------±-------------±--------------±-------------
(0 rows)

Regards,
Tarcisio Pereira.

Hi @asmecher

I forgot the issue_galleys_settings.
After that successfully upgraded.

Regards,
Tarcisio Pereira

1 Like