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)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Mon, 15 Oct 2018 11:31:14 +0000 (12:31 +0100)
commitf15cff7d8815b40c6cdeff8def58799b0a497490
treed74eeba90deffe259ab998846d4faad553fc81bc
parentd341326362656853d0f8d371bd7d685b9c4266d7
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>
(cherry picked from commit 88c29de46558f974ae10a6d25096cf531f7ee0a0)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
C4/CourseReserves.pm