[Koha-bugs] [Bug 17526] OPAC lists require a sortfield
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Nov 2 15:25:19 CET 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17526
Marc Véron <veron at veron.ch> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #57010|0 |1
is obsolete| |
--- Comment #3 from Marc Véron <veron at veron.ch> ---
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 <veron at veron.ch>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list