Moodle

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.9
• Fix Version/s: 1.9.1
• Component/s: Tags
• Labels:

  None

ERROR: column "tg.tagtype" must appear in the GROUP BY clause or be used in an aggregate function

SELECT tg.rawname, tg.id, tg.name, tg.tagtype, COUNT(ti.id) AS count, tg.flag FROM core19_tag_instance ti INNER JOIN core19_tag tg ON tg.id = ti.tagid GROUP BY tg.id, tg.rawname, tg.name, tg.flag ORDER BY count DESC, tg.name ASC

• line 686 of lib/dmllib.php: call to debugging()
• line 944 of lib/dmllib.php: call to get_recordset_sql()
• line 27 of tag/locallib.php: call to get_records_sql()
• line 64 of blocks/tags/block_tags.php: call to tag_print_cloud()
• line 240 of blocks/moodleblock.class.php: call to block_tags->get_content()
• line 264 of blocks/moodleblock.class.php: call to block_base->is_empty()
• line 338 of lib/blocklib.php: call to block_base->_print_block()
• line 83 of admin/stickyblocks.php: call to blocks_print_group()

Warning: Invalid argument supplied for foreach() in /var/www/html/jb23347/core19-moodle/tag/locallib.php on line 35

• Assignee:

  Mathieu Petit-Clair

  Reporter:

  John Beedell

  Tester:

  Eloy Lafuente (stronk7)

  Participants:

  Eloy Lafuente (stronk7), John Beedell, Mathieu Petit-Clair

• Created:

  04/Mar/08 5:43 PM

  Updated:

  08/Apr/08 8:39 PM

  Resolved:

  05/Mar/08 10:45 AM