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

Breakage in get_courses_wmanagers()

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a bug
    • Icon: Minor Minor
    • None
    • 1.9
    • Roles / Access
    • None
    • MOODLE_19_STABLE

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,51,151,141,201,171,291,281,271,681,691,581,671,241,231,4481,9431,9491,22921,22' at line 15

      SELECT ctx.path, ctx.instanceid, ctx.contextlevel, ra.hidden, r.id AS roleid, r.name as rolename, u.id AS userid, u.firstname, u.lastname FROM role_assignments ra JOIN context ctx ON ra.contextid = ctx.id JOIN user u ON ra.userid = u.id JOIN role r ON ra.roleid = r.id LEFT OUTER JOIN course c ON (ctx.instanceid=c.id AND ctx.contextlevel=50) WHERE ( c.id IS NOT NULL OR ra.contextid IN (,1,51,151,141,201,171,291,281,271,681,691,581,671,241,231,4481,9431,9491,22921,22991,23001,23011,23021,21541,21,711,9081) ) AND ra.roleid IN (21) ORDER BY r.sortorder ASC, ctx.contextlevel ASC, ra.sortorder ASC

      • line 686 of lib/dmllib.php: call to debugging()
      • line 723 of lib/datalib.php: call to get_recordset_sql()
      • line 1824 of course/lib.php: call to get_courses_wmanagers()
      • line 223 of index.php: call to print_courses()

            martinlanghoff Martín Langhoff (Inactive)
            poltawski Dan Poltawski
            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.