[Koha-bugs] [Bug 34360] [WARN] DBIx::Class::ResultSetColumn::new(): Attempting to retrieve non-unique column 'biblionumber' on a resultset containing one-to-many joins will return duplicate results

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34360

Jonathan Druart <jonathan.druart+koha at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jonathan.druart+koha at gmail.
                   |                            |com
         Depends on|                            |33497

--- Comment #3 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
This is coming from
  commit 2cf00f1a49a7b9f8d5ca105e2dd1add5d5d95198
  Bug 33497: Use 'host_items' param to fetch all items at once

-my @items = $biblio->items->search_ordered( $params )->as_list;
+my $items = $biblio->items({ host_items => 1 })->search_ordered( $params, {
prefetch => ['issue','branchtransfers'] } );

And the get_column call from Koha::Items->search_ordered

453     my @biblionumbers = uniq $self->get_column('biblionumber');


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33497
[Bug 33497] Reduce DB calls on staff detail page
-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.