[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