PKP Bugzilla – Bug 3793
Can't update section info with 2.2.2 and Postgres
Last modified: 2008-09-28 19:43:25 PDT
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.
After updating from 2.1 to 2.2.2, any attempt to edit sections returns:
DB Error: ERROR: invalid input syntax for integer: ""
Turns out, our sections.review_form_id are all NULL and Postgres just won't have any of that do-magick-with-nulls MySQL promotes.
The problem lies with the query in classes/journal/SectionDAO.inc.php:updateSection where $section->getReviewFormId is UPDATEd back to database and becomes an empty string if null.
PostgreSQL 8.1.9, Apache 2.2.6, PHP 5.2.5, Linux
Attaching an extremely crude patch for the benefit of anyone having this problem and needing a quick fix before Alec does it for real.
Created attachment 992 [details]
a caveman's fix
*** This bug has been marked as a duplicate of bug 3790 ***