https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31009
Pedro Amorim <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |m Status|Needs Signoff |Failed QA --- Comment #7 from Pedro Amorim <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] https://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/
