https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17526
--- Comment #2 from Blou <philippe.blo...@inlibro.com> --- Created attachment 57010 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=57010&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. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/