Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-26930

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.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 2.0.2
    • None
    • Tags
    • None
    • Microsoft SQL
    • MOODLE_20_STABLE

    Description

      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()
        !!

      Attachments

        Issue Links

          Activity

            People

              moodle.com Moodle HQ
              nebgor Aparup Banerjee
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: