Here you will find a small fix for the attendance module for moodle 2.0. Some queries have problems if the are executed on our PostgreSQL database. So if you get some “group by” errors you could use the following fix. For the module see here
Change query @row 826
1 | SELECT ue.userid, ue.status, ue.timestart, ue.timeend |
2 | FROM {user_enrolments} ue |
3 | JOIN {enrol} e ON e.id = ue.enrolid |
5 | AND e.status = :estatus |
6 | AND e.courseid = :courseid |
7 | GROUP BY ue.userid, ue.status, ue.timestart,ue.timeend |
and @row 851
1 | SELECT ue.userid, ue.status, ue.timestart, ue.timeend |
2 | FROM {user_enrolments} ue |
3 | JOIN {enrol} e ON e.id = ue.enrolid |
5 | AND e.status = :estatus |
6 | AND e.courseid = :courseid |
7 | GROUP BY ue.userid,ue.status, ue.timestart, ue.timeend |
have fun
About cool/interesting Projects and Technologies