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

User bulk selection results in Orable database errors when more than 1000 users are selected

XMLWordPrintable

    • Oracle
    • MOODLE_26_STABLE, MOODLE_27_STABLE, MOODLE_28_STABLE
    • MOODLE_26_STABLE, MOODLE_27_STABLE
    • MDL-47227_master
    • Easy
      1. Create an M course with the generator tool to have MORE than 1000 users in your platform.
      2. Go to User Bulk actions
      3. Select All the users (+1000) and Add as Selected
      4. No error should appear

      In User Bulk actions, when more than 1000 users are marked as selected, a dmlreadexception occurs:

      ORA-01795: maximum number of expressions in a list is 1000
      SELECT id, MOODLELIB.UNDO_MEGA_HACK(MOODLELIB.TRICONCAT(firstname, '*OCISP*', lastname)) AS fullname FROM m2user WHERE id IN (21,.......,1752) ORDER BY fullname
      [array (
      )]
      

      This is caused by the function get_selection_data because it uses directly an IN sentence without using get_in_or_equal function from the DML library.

            pferre22 Pau Ferrer
            pferre22 Pau Ferrer
            Frédéric Massart Frédéric Massart
            Damyon Wiese Damyon Wiese
            Sam Hemelryk Sam Hemelryk
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

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