We are moving to Git Issues for bug tracking in future releases. During transition, content will be in both tools. If you'd like to file a new bug, please create an issue.

Bug 8247 - Upgrade with postgres fails because of not-null constraint on review_round_id
Upgrade with postgres fails because of not-null constraint on review_round_id
Product: OJS
Classification: Unclassified
Component: Installer
All All
: P3 normal
Assigned To: PKP Support
Depends on:
  Show dependency treegraph
Reported: 2013-06-06 02:55 PDT by Tom Christensen
Modified: 2013-06-06 10:07 PDT (History)
1 user (show)

See Also:
Version Reported In:
Also Affects:

Patch against OJS 2.4.2 (967 bytes, application/octet-stream)
2013-06-06 02:55 PDT, Tom Christensen

Note You need to log in before you can comment on or make changes to this bug.
Description Tom Christensen 2013-06-06 02:55:14 PDT
Created attachment 3933 [details]
Patch against OJS 2.4.2

When upgrading from OJS 2.3.7 to 2.4.2 using a PostgreSQL database I ran into this error:
"ERROR: null value in column" review_round_id "violates not null constraint"

This error has been discussed several times on the forum:

I could not find a patch or a bugzilla entry for this issue.

I've attached the patch I'm using based on Alecs reply in this thread: http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=9049
Comment 1 Alec Smecher 2013-06-06 10:05:58 PDT
Thanks, Tom -- it's been on my list but I didn't get to it. I've committed the change (to the master and ojs-stable-2_4 branches).
Comment 2 Alec Smecher 2013-06-06 10:06:01 PDT
Relax not null constraint
Comment 3 Alec Smecher 2013-06-06 10:07:01 PDT
Relax not null constraint