https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17526
Marc Véron <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #57010|0 |1 is obsolete| | --- Comment #3 from Marc Véron <[email protected]> --- Created attachment 57104 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=57104&action=edit Bug 17526 - OPAC lists require a sortfield Using the OPAC, going into the public lists, we click one of them and get DBIx::Class::Storage::DBI::_dbh_execute(): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 10) `me` JOIN `biblio` `biblionumber` ON `biblionumber`.`biblionumber' THis is because the sortfield is empty and creates a SQL like GROUP BY ASC LIMIT 10. Missing the group by <what?>. In the intranet list, there's a default usage of 'title' that makes it all work. TESTING: 1) just create a public list with no sortfield. In the DB: - virtualshelves.category = 2 - virtualshelves.sortfield = '' 2) click on the list in the OPAC's public list. Boom! This simple patch uses 'title' if nothing else is specified. Reproduced. Patch fixes issue as expected. Signed-off-by: Marc Véron <[email protected]> -- 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/
