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

coursesectionspreferences - limited by user preference size

XMLWordPrintable

    • MOODLE_401_STABLE

      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 user 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)

            Votes:
            25 Vote for this issue
            Watchers:
            29 Start watching this issue

              Created:
              Updated:

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