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

Import course list is not formed correctly: Incorrect results and Performance issues

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 2.1.1
    • Backup
    • None
    • MySQL
    • MOODLE_21_STABLE
    • Hide

      If I change the limit from 250 to 2000 (we have about 1500 courses), then the courses show up as expected, but the server had to check each course out individually so this is only a hack.

      Show
      If I change the limit from 250 to 2000 (we have about 1500 courses), then the courses show up as expected, but the server had to check each course out individually so this is only a hack.

      It seems that in restore_ui_components.php in the function search(), the process by which the backup/restore/import area creates the list of available courses is to grab 250 courses from the database and test them 1 by 1 to see if the user has the correct capabilities to proceed. Unfortunately, if their courses don't get grabbed in that 250, it still returns "No courses available". The SQL that gets the list of courses does not pair down the list, so the SQL is incorrect and the process is poorly designed.

            stronk7 Eloy Lafuente (stronk7)
            syxton Matthew Davidson
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

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