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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.1.1
    • Fix Version/s: None
    • Component/s: Backup
    • Labels:
      None
    • Database:
      MySQL
    • Workaround:
      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.
    • Affected Branches:
      MOODLE_21_STABLE

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              syxton Matthew Davidson
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: