http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10636
Bug ID: 10636
Summary: patronimage should have borrowernumber as PK, not
cardnumber
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Database
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
The patronimage table currently has cardnumber as its primary key rather than
borrowernumber. patronimage.cardnumber in turn has a FK constraint referencing
borrowers.cardnumber.
This is less than ideal for a couple reasons:
[1] DBIX::Class (see bug 8798) complains about it. In particular, any code
that loads Koha::Database would litter the Apache logs with the following:
DBIx::Class::Carp::__ANON__(): "might_have/has_one" must not be on columns with
is_nullable set to true (Koha::Schema::Result::Borrower/cardnumber). This might
indicate an incorrect use of those relationship helpers instead of belongs_to.
at /usr/share/perl5/DBIx/Class/Relationship/HasOne.pm line 96
[2] Every other table that has an FK to borrowers uses borrowernumber as the
referent.
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
