-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
4.1.3
-
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)
- has been marked as being related by
-
MDL-80688 Customising the question bank view can lead to trying to store a user preference value that is too long
- Open
- will be (partly) resolved by
-
MDL-46739 Allow to store long user preferences
- Integration review in progress
- will help resolve
-
MDL-80714 Evaluate the possibility of storing subsection preferences on it's own preference
- Open