https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17526
Bug ID: 17526
Summary: OPAC lists require a sortfield
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: minor
Priority: P5 - low
Component: Lists
Assignee: gmcha...@gmail.com
Reporter: philippe.blo...@inlibro.com
QA Contact: testo...@bugs.koha-community.org
CC: m.de.r...@rijksmuseum.nl
Using the OPAC, going into the public lists, I 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.
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.
- virtualshelves.category = 2
- virtualshelves.sortfield = ''
2) click on the list in the OPAC's public list. Boom!
--
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/
