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

Ambiguous reference to sortorder in the Flat file enrolment plug-in

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 1.9
    • None
    • Enrolments
    • None
    • PostgreSQL
    • MOODLE_19_STABLE

    Description

      The Flat file enrolment plug-in generates an SQL error when calling the get_users_by_capability function. The php warning reads:

      Warning - in /home/davidvm/public_html/pilot/lib/adodb/drivers/adodb-postgres7.inc.php(115): pg_query() [function.pg-query]: Query failed: ERROR: column reference "sortorder" is ambiguous

      The issue seems to be that the sort parameter pass in get_users_by_capability requires an "r." prefix.

      While looking for the cause of this issue I notice that get_assignable_roles function in accesslib.ph could potentially have the same problem.

      I include a diff of the propose changes, I hope that helped.

      Regards,

      GV

      Attachments

        Issue Links

          Activity

            People

              poltawski Dan Poltawski
              guidovega Guido Vega
              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: