https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31009 Pedro Amorim <pedro.amorim@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |pedro.amorim@ptfs-europe.co | |m Status|Needs Signoff |Failed QA --- Comment #7 from Pedro Amorim <pedro.amorim@ptfs-europe.com> --- Did the following testing: 1) Create a serial attached to a vendor 2) Add late issues to the above serial 3) Ran the following SQL query to add test entries to the serial table INSERT INTO serial (`biblionumber`,`subscriptionid`, `status`) SELECT `biblionumber`, `subscriptionid`, `status` FROM serial; 4) Ended up with 448 serial entries, claims.pl does indeed become very slow. 5) Applied patch 6) Upon visiting /cgi-bin/koha/serials/claims.pl, I get the following error: C4::Serials::GetSuppliersWithLateIssues(): DBI Exception: DBD::mysql::db selectall_arrayref failed: 'koha_kohadev.aqbooksellers.name' isn't in GROUP BY at /kohadevbox/koha/serials/claims.pl line 48 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 My suggestion for this performance issue would be to add pagination to the table. -- You are receiving this mail because: You are watching all bug changes.