projects / koha-equinox.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 8a0e21f) | patch
Bug 20144: [sql_modes] Remove ORDER BY clause for COUNT(*) in GetItemsForInventory
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 6 Feb 2018 16:39:51 +0000 (13:39 -0300)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 13 Feb 2018 16:59:00 +0000 (13:59 -0300)
commita93e49131d4d22c5bc2123f9a3626c36845d9e07
tree16e73ad28363c0dc2ab215ca1d6a1098466872ectree | snapshot
parent8a0e21f0ecfd7e5bd135ad30e8955960b5d3549dcommit | diff
Bug 20144: [sql_modes] Remove ORDER BY clause for COUNT(*) in GetItemsForInventory

Fix for:
DBD::mysql::st execute failed: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause [for Statement 'SELECT COUNT(*)

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
C4/Items.pm diff | blob | history
t/db_dependent/Items/GetItemsForInventory.t diff | blob | history
Koha with Equinox developments in process and local tweaks