]> git.koha-community.org Git - koha.git/commit
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
tree16e73ad28363c0dc2ab215ca1d6a1098466872ec
parent8a0e21f0ecfd7e5bd135ad30e8955960b5d3549d
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
t/db_dependent/Items/GetItemsForInventory.t