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

get_role_users generating "ORDER BY items must appear in the select list if SELECT DISTINCT is specified" errors

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a bug
    • Icon: Minor Minor
    • None
    • 2.0.3
    • Database SQL/XMLDB
    • None
    • Microsoft SQL
    • MOODLE_20_STABLE
    • Hide

      I've attached a .pdf to CONTRIB-3204 with screenshots of the steps that I followed when I created the "Users Report" and got this error. Basically, install the Configurable Report block and then create a "Users Report". The error is displayed when you click on the View Report tab. Apparently the problem is in the get_role_users function, which is a Moodle core function.

      Show
      I've attached a .pdf to CONTRIB-3204 with screenshots of the steps that I followed when I created the "Users Report" and got this error. Basically, install the Configurable Report block and then create a "Users Report". The error is displayed when you click on the View Report tab. Apparently the problem is in the get_role_users function, which is a Moodle core function.

      I installed the Configurable Report block (CONTRIB-10753) on my Moodle 2.0.3+ (Build: 20110609) test machine. When I create a "Users Report" in that block I get a "ORDER BY items must appear in the select list if SELECT DISTINCT is specified" error. I reported this error in CONTRIB-3204. Juan Leyva, the CONTRIB-10753 maintainer, looked at the report and concluded that "the bug is located in the function get_role_users that is a core function of Moodle", so I'm reporting it here again - I'm not sure what the actual problem in get_role_users is though...

            poltawski Dan Poltawski
            libertymoodle Luis de Vasconcelos
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

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