-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
2.0.2
-
None
-
Microsoft SQL
-
MOODLE_20_STABLE
checking for create_password
creating passwords for new users
!!! Error reading from database !!!
!! Column 'mdl_tag_correlation.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
SELECT ta.tagid, tb.tagid AS correlation, co.id AS correlationid, co.correlatedtags
FROM mdl_tag_instance ta
LEFT JOIN mdl_tag_instance tb
ON (ta.itemtype = tb.itemtype AND ta.itemid = tb.itemid AND ta.tagid <> tb.tagid)
LEFT JOIN mdl_tag_correlation co
ON co.tagid = ta.tagid
WHERE tb.tagid IS NOT NULL
GROUP BY ta.tagid, tb.tagid
HAVING COUNT > ?
ORDER BY ta.tagid ASC, COUNT DESC, tb.tagid ASC
[array (
0 => 2,
)] !!
!! Stack trace: * line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 255 of /lib/dml/mssql_native_moodle_database.php: call to moodle_database->query_end()
- line 710 of /lib/dml/mssql_native_moodle_database.php: call to mssql_native_moodle_database->query_end()
- line 844 of /tag/lib.php: call to mssql_native_moodle_database->get_recordset_sql()
- line 910 of /tag/lib.php: call to tag_compute_correlations()
- line 311 of /lib/cronlib.php: call to tag_cron()
- line 79 of /admin/cron.php: call to cron_run()
!!
- duplicates
-
MDL-26884 Buggy SELECT statement in function tag_compute_correlations()
- Closed