You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: