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

Software Support
22

Hi @fsf,

It appears as though your OJS 3.0.2 database has entries in the submissions table with a null locale. That’s a data error – there should always be a locale set. I’d suggest reviewing your database and fixing it before running the upgrade.

Regards,
Alec Smecher
Public Knowledge Project Team

23

Hi @asmecher

Thank you for your reply.
Now I have this error:
"
[note: docs/release-notes/README-3.1.2]
[data: dbscripts/xml/upgrade/event_log_oneclickuserid.xml]
[data: dbscripts/xml/upgrade/3.2.0_stylesheet.xml]
[data: dbscripts/xml/upgrade/3.2.0_archiving_settings.xml]
[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 (47, , enableOai, 1, null).
"

I’m investigating. If you have any tips I will really be grateful :slight_smile:

24

Hi @fsf,

That’s the same issue as the top of this 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

25

Hi @asmecher

Thanks a lot for you help.

I could succesful migration from base version 3.0.2.0 to version 3.2.1.1

Now I am facing a new problem
Seem that OJS search tools it is not work at all, even after tools/rebuildSearchIndex.php
I do not know if I can talk about this issue here or open a new topic

Thanks for help again.
Kind regards,
@fsf

26

Hi @fsf,

Great, that’s progress! Please do post your other question as a new topic; that’ll help keep the forum organized.

Regards,
Alec Smecher
Public Knowledge Project Team