]> git.koha-community.org Git - koha.git/commit
Bug 26090: Fix "item types" report
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Thu, 30 Jul 2020 12:16:09 +0000 (14:16 +0200)
committerVictor Grousset/tuxayo <victor@tuxayo.net>
Sun, 20 Sep 2020 15:40:43 +0000 (17:40 +0200)
commita7beb7fa54c300dca59789afa1217b67e2792dd8
treee20cd2ded12f76e0bbac44402ea98ef87514c991
parentede65c75449f400af5bff95cb1f86184b5c580b7
Bug 26090: Fix "item types" report

This report was broken with SQL strict mode, but also without.

DBD::mysql::st execute failed: 'koha_kohadev.itemtypes.itemtype' isn't
in GROUP BY [for Statement "

and, if no library was selected:

DBD::mysql::st execute failed: Unknown column 'biblioitems.itemtype' in
'field list' [for Statement "

This patch does the minimum to make it usable, but it would need more
love.

Test plan:
To test you will need to try the 4 combinaisons:
 item-level_itypes = item or biblio
 With or without a library selected in the dropdown list

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit 5bca73080f89bb2f4ca83ce6ceb9fa8e3c4a7d92)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
(cherry picked from commit 69f16f7469c7cbbf571560d6f9389ef2dd170aa7)

Signed-off-by: Aleisha Amohia <aleishaamohia@hotmail.com>
(cherry picked from commit 1e0c18d45eca798ac1578f16d7be1dd5f52875e4)
Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net>
reports/itemtypes.plugin