[Koha-bugs] [Bug 17526] New: OPAC lists require a sortfield

[bugzilla-daemon at bugs.koha-community.org]

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: gmcharlt at gmail.com
          Reporter: philippe.blouin at inlibro.com
        QA Contact: testopia at bugs.koha-community.org
                CC: m.de.rooy at 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.