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

Summary: Upgrade with postgres fails because of not-null constraint on review_round_id
Product: OJS Reporter: Tom Christensen <tgc>
Component: InstallerAssignee: PKP Support <pkp-support>
Status: RESOLVED FIXED    
Severity: normal CC: alec
Priority: P3    
Version: 2.4.3   
Hardware: All   
OS: All   
Version Reported In: Also Affects:
Attachments: Patch against OJS 2.4.2

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:
http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=9358
http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=9009&hilit=review_round_id&start=45#p35567
http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=9049

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
https://github.com/pkp/pkp-lib/commit/97fea2a5a2322088137c8bf89261ade62f783c4f
Comment 3 Alec Smecher 2013-06-06 10:07:01 PDT
Relax not null constraint
https://github.com/pkp/pkp-lib/commit/f0f0f835b0f3cb1e821f8f31759467f55d4ab458