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

Your changes in MDL-15070 broke the participants list in Postres

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 2.0
    • 2.0
    • Database SQL/XMLDB
    • None
    • MOODLE_20_STABLE
    • MOODLE_20_STABLE

    Description

      I am getting:

      ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
      SELECT DISTINCT u.id FROM m_user u
      LEFT OUTER JOIN m_context ctx
      ON (u.id=ctx.instanceid AND ctx.contextlevel = 30)
      JOIN m_role_assignments r
      ON u.id=r.userid
      LEFT OUTER JOIN m_user_lastaccess ul
      ON (r.userid=ul.userid and ul.courseid = ?) WHERE (r.contextid = 49 OR r.contextid in (3,1))
      AND u.deleted = 0
      AND (ul.courseid = 5 OR ul.courseid IS NULL)
      AND u.username != 'guest'
      AND r.roleid NOT IN (1)
      ORDER BY lastaccess DESC, r.hidden DESC<br />[array (
      0 => 5,
      )]

      • line 286 of lib/dml/moodle_database.php: call to debugging()
      • line 439 of lib/dml/adodb_moodle_database.php: call to moodle_database->report_error()
      • line 536 of user/index.php: call to adodb_moodle_database->get_fieldset_sql()

      When I switch to 'Enrolment details' mode on the participants list for a course on my Postgres install.

      That query is one you added last night while removing the ability to rewind record-sets.

      Attachments

        Activity

          People

            skodak Petr Skoda
            timhunt Tim Hunt
            Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              24/Nov/10