Bug 20177: [sql_modes] Fix GROUP BY clause in GetCourses
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 5 Feb 2018 21:13:06 +0000 (18:13 -0300)
committerNick Clemens <nick@bywatersolutions.com>
Tue, 9 Oct 2018 11:05:48 +0000 (11:05 +0000)
commit88c29de46558f974ae10a6d25096cf531f7ee0a0
treefd4093f14f7293e26763294368fb2a0b1a6422a5
parent09a7d37d53a87e35f2151e00200995ab3dfa3896
Bug 20177: [sql_modes] Fix GROUP BY clause in GetCourses

Fix for:
'koha_kohadev.courses.department' isn't in GROUP BY

t/db_dependent/CourseReserves.t

A better fix would be to remove the joins and only return values from
the courses table. But more work is needed to acchieve that goal.

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Test passes and the behavior of Course reserves appears to be unchanged
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
C4/CourseReserves.pm