[Koha-bugs] [Bug 17526] OPAC lists require a sortfield
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Oct 31 20:44:36 CET 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17526
--- Comment #2 from Blou <philippe.blouin at 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.
More information about the Koha-bugs
mailing list