[Bug 29125] New: Use Koha::Patron object in C4:Utils::DataTables::Members.pm
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 Bug ID: 29125 Summary: Use Koha::Patron object in C4:Utils::DataTables::Members.pm Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Currently we do a SQL search for patrons, then fetch the patron object for each borrowernumber individually, then fetch related objects If we use Koha::Patrons directly we can prefetch related object and reduce the number of calls to the DB -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 --- Comment #1 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 125374 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=125374&action=edit Bug 29125: Add primary key to user_permissions table -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 --- Comment #2 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 125375 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=125375&action=edit Bug 29125: DBIC updates -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 --- Comment #3 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 125376 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=125376&action=edit Bug 29125: Use patron objects in C4::Utils::DataTables::Members.pm -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |nick@bywatersolutions.com |ity.org | -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart+koha@gmail. | |com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 --- Comment #4 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.`surname`' in 'where clause' at /kohadevbox/koha/Koha/Objects.pm line 335 To recreate /cgi-bin/koha/members/members-home.pl Search for: "koh" Search field: "surname" Click "Search" -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 --- Comment #5 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- Created attachment 125979 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=125979&action=edit Bug 29125: Fix 'Unknown column' -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=30055 --- Comment #6 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- Bug 30055 will make this bug obsolete. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 --- Comment #7 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- I am going to move the following patch to bug 30060: Bug 29125: Add primary key to user_permissions table -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |30060 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30060 [Bug 30060] Missing primary key on user_permissions -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 Bug 29125 depends on bug 30060, which changed state. Bug 30060 Summary: Missing primary key on user_permissions https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30060 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to master |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29125 Jonathan Druart <jonathan.druart+koha@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #8 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- *** This bug has been marked as a duplicate of bug 30063 *** -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org