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

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 2.0.2
    • Tags
    • 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()
        !!

            moodle.com Moodle HQ
            nebgor Aparup Banerjee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.