When enabling tagging I receive the following error:
Debug info: SQLState: 42000
Error Code: 8120
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Column 'mdl_tag.userid' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT t.*, count(t.id) AS count
FROM mdl_tag t
INNER JOIN mdl_tag_instance ti ON t.id = ti.tagid
INNER JOIN mdl_forumng_discussions fd ON fd.id = ti.itemid
WHERE fd.forumngid = '1' AND ti.component = 'mod_forumng' AND ti.itemtype = 'forumng_discussions' AND ti.contextid = '111815' AND (fd.groupid = '-1' OR fd.groupid IS NULL)
GROUP BY t.name, t.id
ORDER BY t.name
[array (
0 => '1',
1 => 111815,
2 => -1,
)]
Error code: dmlreadexception
When enabling tagging I receive the following error:
Debug info: SQLState: 42000
Error Code: 8120
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Column 'mdl_tag.userid' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT t.*, count(t.id) AS count FROM mdl_tag t INNER JOIN mdl_tag_instance ti ON t.id = ti.tagid INNER JOIN mdl_forumng_discussions fd ON fd.id = ti.itemid
WHERE fd.forumngid = '1' AND ti.component = 'mod_forumng' AND ti.itemtype = 'forumng_discussions' AND ti.contextid = '111815' AND (fd.groupid = '-1' OR fd.groupid IS NULL) GROUP BY t.name, t.id ORDER BY t.name [array ( 0 => '1', 1 => 111815, 2 => -1, )] Error code: dmlreadexception