Bug 17034 - Creating a new patron fails due to DB error
Summary: Creating a new patron fails due to DB error
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: 16.05
Hardware: All Linux
: P5 - low major (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on: 16917
Blocks:
  Show dependency treegraph
 
Reported: 2016-08-02 21:42 UTC by Adam Goforth
Modified: 2019-06-27 09:24 UTC (History)
6 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Adam Goforth 2016-08-02 21:42:50 UTC
After upgrading from Koha 16.05.01 to 16.05.02 with the Debian package, creating a new patron via the web interface fails. After filling out and submitting the form at /cgi-bin/koha/members/memberentry.pl?op=add&categorycode=OP this error is displayed:

DBIx::Class::Row::store_column(): No such column 'checkprevcheckout' on Koha::Schema::Result::Borrower at /usr/share/koha/lib/C4/Members.pm line 731

It seems that the problem is in line 727 of Members.pm:

$new_member->{checkprevcheckout} ||= 'inherit';

Commenting out this line allows the patron creation to finish normally.

The issue seems to be that the column "checkprevcheckout" does not exist in the borrowers table and should not exist in this version of Koha. Apparently it was added to master in bug 6906, and it shouldn't be in a public release until Koha 16.11.

Koha version: 16.05.02.000
OS: Debian 8.5
Comment 1 Katrin Fischer 2016-08-02 21:54:31 UTC
It seems the column was introduced to the categories table by bug 6906 and should not appear in 16.05 - maybe it slipped in somehow with another patch/rebase?
Comment 2 Chris Cormack 2016-08-02 21:56:03 UTC
This bug was caused by commit 878402689eb652b09bed0d4f2c7e458d5c5493f4

I think we need to revert this out on 16.05.x
Comment 3 Frédéric Demians 2016-08-03 06:26:33 UTC
Bug 16917 reverted on 16.05 branch.
Comment 4 Mirko Tietgen 2016-08-03 08:17:12 UTC
I already uploaded a new Debian package last night without the patch.