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

coursesectionspreferences - limited by user preference size

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Minor
    • None
    • 4.1.3
    • Course
    • MOODLE_401_STABLE

    Description

      We've come across the following error "Coding error detected, it must be fixed by a programmer: Invalid value in set_user_preference() call, value is is too long for the value column" that seems to come about because user preference values are limited to 1333 chars. The issue stems from the course format Topics and Flexible Sections tracking the expand/collapse nature of the sections in section preferences. Currently our section ids are 5 digits. In courses with a lot of sections (we have ~118 sections in the course we found the issue in) we get the "codingerror" when attempting to expand or collapse all sections. 

       

      A couple of suggestions from our systems guru:

      • Either the db field needs to allow a much longer value, or
      • Section preferences needs to be reimplemented to use one row per section or per preference (rather than one row per course)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              kimberley.johnston Kimberley Johnston
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Clockify

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