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
Status: RESOLVED FIXED
Product: OJS
Classification: Unclassified
Component: Installer
2.4.3
All All
: P3 normal
Assigned To: PKP Support
Depends on:
Blocks:
  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:


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

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:
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