Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
2.6.1
-
Microsoft SQL, Oracle
-
MOODLE_26_STABLE
-
MOODLE_26_STABLE
-
wip-
MDL-43719-master -
Description
When clicking the Manage Tags link under Appearance in the Site Administration Menu.
Error reading from database
|
Debug: Column 'mdl_user.firstnamephonetic' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
|
SELECT TOP 30 tg.id, tg.name, tg.rawname, tg.tagtype, tg.flag, tg.timemodified,
|
u.id AS owner, u.firstnamephonetic,u.lastnamephonetic,u.middlename,u.alternatename,u.firstname,u.lastname,
|
COUNT(ti.id) AS count
|
FROM mdl_tag tg
|
LEFT JOIN mdl_tag_instance ti ON ti.tagid = tg.id
|
LEFT JOIN mdl_user u ON u.id = tg.userid
|
|
GROUP BY tg.id, tg.name, tg.rawname, tg.tagtype, tg.flag, tg.timemodified,
|
u.id, u.firstname, u.lastname
|
ORDER BY flag DESC
|
[array (
|
)]
|
Error code: dmlreadexception
|
* line 441 of \lib\dml\moodle_database.php: dml_read_exception thrown
|
* line 242 of \lib\dml\mssql_native_moodle_database.php: call to moodle_database->query_end()
|
* line 716 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->query_end()
|
* line 750 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->get_recordset_sql()
|
* line 250 of \tag\manage.php: call to mssql_native_moodle_database->get_records_sql()
|
Referring to MDL-43283 and wondering if fix would be adding $allusernames to the end of the Group By clause in moodle\tag\manage.php:
Line 234 u.id, u.firstname, u.lastname, $allusernames
Line 235 $sort;