]> git.mjollnir.org Git - moodle.git/commit
projects / moodle.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e88370a) | patch
datalib: get_logs_user*() - fix invalid SQL - MDL-12426
authormartinlanghoff <martinlanghoff>
Tue, 4 Dec 2007 06:26:10 +0000 (06:26 +0000)
committermartinlanghoff <martinlanghoff>
Tue, 4 Dec 2007 06:26:10 +0000 (06:26 +0000)
commit1d854cec5a5f9e95d44cee746216ef00ff4a3cfc
tree171137b5ee7bf1260b98934c1ce83214b0548428tree | snapshot
parente88370a6a3774150a682fa66316aef8140d2cd2dcommit | diff
datalib: get_logs_user*() - fix invalid SQL - MDL-12426

Oracle does not accept column labels in the GROUP BY section -
get_logs_usercourse() and get_logs_userday() were computing the
day/hours column and using it in the GROUP BY. The compatible fix
is to reproduce the same computation in the GROUP BY section.

Credit for the fix goes to Dennis Rochford <Dennis.Rochford@usq.edu.au>.
lib/datalib.php diff | blob | history
Unnamed repository; edit this file to name it for gitweb.