Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enable Tagging causes database error #74

Open
aearleycaw opened this issue Feb 4, 2020 · 0 comments
Open

Enable Tagging causes database error #74

aearleycaw opened this issue Feb 4, 2020 · 0 comments

Comments

@aearleycaw
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant