Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 1.9
-
Fix Version/s: None
-
Component/s: Tags
-
Labels:None
-
Database:PostgreSQL
-
Affected Branches:MOODLE_19_STABLE
Description
This is a very minor bug that might well have already been fixed by now - I am using Moodle 1.9 Beta + (2007092001).
ERROR: syntax error at or near "AS" at character 351
SELECT tg.id, tg.name, tg.rawname, tg.tagtype, COUNT(ti.id) AS count, u.id AS owner, tg.flag, tg.timemodified, u.firstname, u.lastname FROM hlearn_tag_instance ti RIGHT JOIN hlearn_tag tg ON tg.id = ti.tagid LEFT JOIN hlearn_user u ON tg.userid = u.id GROUP BY tg.id, tg.name, tg.rawname, tg.tagtype, u.id AS owner, tg.flag, tg.timemodified, u.firstname, u.lastname ORDER BY flag DESC
- line 779 of lib/dmllib.php: call to debugging()
- line 1020 of lib/dmllib.php: call to get_recordset_sql()
- line 208 of tag/manage.php: call to get_records_sql()
Issue Links
| This issue duplicates: | ||||
| MDL-11535 | Blog block sql error |
|
|
|
A suggested fix is to line 193 of tag/manage.php (probably already done in later code editions)
GROUP BY tg.id, tg.name, tg.rawname, tg.tagtype, u.id AS owner, tg.flag, tg.timemodified, u.firstname, u.lastname //moodle 1.8 code
GROUP BY tg.id, tg.name, tg.rawname, tg.tagtype, u.id, tg.flag, tg.timemodified, u.firstname, u.lastname //fixed