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