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

Storing sortorder of courses on my_home page fails if user is enrolled in a lot (100+) of courses

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide
      1. Create over 140 courses and enrol one user in them (better to use some course upload or behat)
      2. As this user go to "My home" page, click to customise the page, try to resort courses
      3. Refresh the page and make sure that custom order is preserved
      4. Click to view all your courses
      5. try to resort courses
      6. Refresh the page and make sure that custom order is preserved
      Show
      Create over 140 courses and enrol one user in them (better to use some course upload or behat) As this user go to "My home" page, click to customise the page, try to resort courses Refresh the page and make sure that custom order is preserved Click to view all your courses try to resort courses Refresh the page and make sure that custom order is preserved
    • Affected Branches:
      MOODLE_24_STABLE, MOODLE_25_STABLE, MOODLE_26_STABLE, MOODLE_27_STABLE
    • Fixed Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE
    • Pull Master Branch:
      wip-MDL-43739-master

      Description

      user_preferences value field has max limit of 1333. While storing sortorder of my_home course with large number of courses it fails with error.

      Either increase limit of user_preferences or add them to new table storing sortorder.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marina Marina Glancy
              Reporter:
              rajeshtaneja Rajesh Taneja
              Integrator:
              Dan Poltawski
              Tester:
              Ankit Agarwal
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)
              Votes:
              3 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                10/Nov/14