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

Increase length of custom category/field "name" fields

XMLWordPrintable

    • MOODLE_405_STABLE
    • Hide
      1. Log in as admin
      2. Navigate to Courses > Course custom fields in site administration
      3. Press Add a new category
      4. Press the edit icon next to the new Other fields category
      5. Enter the following text (1350 characters): 

        Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce a sapien nulla. Aliquam sed ante porttitor, tempor felis vel, porta ligula. Cras lobortis turpis quis justo condimentum mattis id ac quam. Vivamus sollicitudin sapien quis eros consectetur cursus. Donec eget tempus orci. Curabitur ultricies, turpis dapibus rhoncus luctus, arcu libero convallis justo, id feugiat eros ex sit amet risus. Nam eu lacinia nisl. Maecenas tortor ligula, tristique at gravida vel, congue et elit. Sed malesuada odio eget efficitur vulputate. Integer aliquet, purus quis consectetur dignissim, mi eros rhoncus massa, nec aliquet quam odio eu metus. Donec semper urna sed erat finibus vehicula. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Praesent facilisis lectus metus, id dignissim ipsum aliquet ut. Curabitur id odio nisi. Ut ac convallis sapien. Aenean ultrices elementum euismod. Aliquam at eros quis sem varius vestibulum. Donec lorem mi, lacinia sed lacus non, finibus tincidunt magna. Maecenas a consequat est. Phasellus in facilisis ex, vel venenatis ex. Cras nec arcu massa. Curabitur tristique justo sed ipsum interdum, eget maximus quam aliquet. Curabitur sed ullamcorper sem. Donec placerat massa eget libero in

      6. Confirm the value was truncated to 1333 characters after saving and no DML exception was thrown: 

        Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce a sapien nulla. Aliquam sed ante porttitor, tempor felis vel, porta ligula. Cras lobortis turpis quis justo condimentum mattis id ac quam. Vivamus sollicitudin sapien quis eros consectetur cursus. Donec eget tempus orci. Curabitur ultricies, turpis dapibus rhoncus luctus, arcu libero convallis justo, id feugiat eros ex sit amet risus. Nam eu lacinia nisl. Maecenas tortor ligula, tristique at gravida vel, congue et elit. Sed malesuada odio eget efficitur vulputate. Integer aliquet, purus quis consectetur dignissim, mi eros rhoncus massa, nec aliquet quam odio eu metus. Donec semper urna sed erat finibus vehicula. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Praesent facilisis lectus metus, id dignissim ipsum aliquet ut. Curabitur id odio nisi. Ut ac convallis sapien. Aenean ultrices elementum euismod. Aliquam at eros quis sem varius vestibulum. Donec lorem mi, lacinia sed lacus non, finibus tincidunt magna. Maecenas a consequat est. Phasellus in facilisis ex, vel venenatis ex. Cras nec arcu massa. Curabitur tristique justo sed ipsum interdum, eget maximus quam aliquet. Curabitur sed ullamcorper sem. Donec placerat mas

      7. Add a new Checkbox custom field to your category
      8. Enter the following in Name (1333 characters): 

        Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce a sapien nulla. Aliquam sed ante porttitor, tempor felis vel, porta ligula. Cras lobortis turpis quis justo condimentum mattis id ac quam. Vivamus sollicitudin sapien quis eros consectetur cursus. Donec eget tempus orci. Curabitur ultricies, turpis dapibus rhoncus luctus, arcu libero convallis justo, id feugiat eros ex sit amet risus. Nam eu lacinia nisl. Maecenas tortor ligula, tristique at gravida vel, congue et elit. Sed malesuada odio eget efficitur vulputate. Integer aliquet, purus quis consectetur dignissim, mi eros rhoncus massa, nec aliquet quam odio eu metus. Donec semper urna sed erat finibus vehicula. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Praesent facilisis lectus metus, id dignissim ipsum aliquet ut. Curabitur id odio nisi. Ut ac convallis sapien. Aenean ultrices elementum euismod. Aliquam at eros quis sem varius vestibulum. Donec lorem mi, lacinia sed lacus non, finibus tincidunt magna. Maecenas a consequat est. Phasellus in facilisis ex, vel venenatis ex. Cras nec arcu massa. Curabitur tristique justo sed ipsum interdum, eget maximus quam aliquet. Curabitur sed ullamcorper sem. Donec placerat mas

      9. Enter the following in Short name (100 characters): 

        loremipsumdolorsitametconsecteturadipiscingelitfusceasapiennullaaliquamsedanteporttitortemporfelisve

      10. Confirm the form prevents you adding any more content to either field
      11. Save changes
      12. Confirm the custom field is created containing exactly the same name/shortname as above
      Show
      Log in as admin Navigate to Courses > Course custom fields in site administration Press Add a new category Press the edit icon next to the new Other fields category Enter the following text (1350 characters): Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce a sapien nulla. Aliquam sed ante porttitor, tempor felis vel, porta ligula. Cras lobortis turpis quis justo condimentum mattis id ac quam. Vivamus sollicitudin sapien quis eros consectetur cursus. Donec eget tempus orci. Curabitur ultricies, turpis dapibus rhoncus luctus, arcu libero convallis justo, id feugiat eros ex sit amet risus. Nam eu lacinia nisl. Maecenas tortor ligula, tristique at gravida vel, congue et elit. Sed malesuada odio eget efficitur vulputate. Integer aliquet, purus quis consectetur dignissim, mi eros rhoncus massa, nec aliquet quam odio eu metus. Donec semper urna sed erat finibus vehicula. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Praesent facilisis lectus metus, id dignissim ipsum aliquet ut. Curabitur id odio nisi. Ut ac convallis sapien. Aenean ultrices elementum euismod. Aliquam at eros quis sem varius vestibulum. Donec lorem mi, lacinia sed lacus non, finibus tincidunt magna. Maecenas a consequat est. Phasellus in facilisis ex, vel venenatis ex. Cras nec arcu massa. Curabitur tristique justo sed ipsum interdum, eget maximus quam aliquet. Curabitur sed ullamcorper sem. Donec placerat massa eget libero in Confirm the value was truncated to 1333 characters after saving and no DML exception was thrown: Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce a sapien nulla. Aliquam sed ante porttitor, tempor felis vel, porta ligula. Cras lobortis turpis quis justo condimentum mattis id ac quam. Vivamus sollicitudin sapien quis eros consectetur cursus. Donec eget tempus orci. Curabitur ultricies, turpis dapibus rhoncus luctus, arcu libero convallis justo, id feugiat eros ex sit amet risus. Nam eu lacinia nisl. Maecenas tortor ligula, tristique at gravida vel, congue et elit. Sed malesuada odio eget efficitur vulputate. Integer aliquet, purus quis consectetur dignissim, mi eros rhoncus massa, nec aliquet quam odio eu metus. Donec semper urna sed erat finibus vehicula. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Praesent facilisis lectus metus, id dignissim ipsum aliquet ut. Curabitur id odio nisi. Ut ac convallis sapien. Aenean ultrices elementum euismod. Aliquam at eros quis sem varius vestibulum. Donec lorem mi, lacinia sed lacus non, finibus tincidunt magna. Maecenas a consequat est. Phasellus in facilisis ex, vel venenatis ex. Cras nec arcu massa. Curabitur tristique justo sed ipsum interdum, eget maximus quam aliquet. Curabitur sed ullamcorper sem. Donec placerat mas Add a new Checkbox custom field to your category Enter the following in Name (1333 characters): Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce a sapien nulla. Aliquam sed ante porttitor, tempor felis vel, porta ligula. Cras lobortis turpis quis justo condimentum mattis id ac quam. Vivamus sollicitudin sapien quis eros consectetur cursus. Donec eget tempus orci. Curabitur ultricies, turpis dapibus rhoncus luctus, arcu libero convallis justo, id feugiat eros ex sit amet risus. Nam eu lacinia nisl. Maecenas tortor ligula, tristique at gravida vel, congue et elit. Sed malesuada odio eget efficitur vulputate. Integer aliquet, purus quis consectetur dignissim, mi eros rhoncus massa, nec aliquet quam odio eu metus. Donec semper urna sed erat finibus vehicula. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Praesent facilisis lectus metus, id dignissim ipsum aliquet ut. Curabitur id odio nisi. Ut ac convallis sapien. Aenean ultrices elementum euismod. Aliquam at eros quis sem varius vestibulum. Donec lorem mi, lacinia sed lacus non, finibus tincidunt magna. Maecenas a consequat est. Phasellus in facilisis ex, vel venenatis ex. Cras nec arcu massa. Curabitur tristique justo sed ipsum interdum, eget maximus quam aliquet. Curabitur sed ullamcorper sem. Donec placerat mas Enter the following in Short name (100 characters): loremipsumdolorsitametconsecteturadipiscingelitfusceasapiennullaaliquamsedanteporttitortemporfelisve Confirm the form prevents you adding any more content to either field Save changes Confirm the custom field is created containing exactly the same name/shortname as above
    • Hide

      Code verified against automated checks.

      Checked MDL-84763 using repository: https://github.com/paulholden/moodle.git

      More information about this report

      Built on: Thu Mar 6 16:00:57 UTC 2025

      Show
      Code verified against automated checks. Checked MDL-84763 using repository: https://github.com/paulholden/moodle.git main (0 errors / 0 warnings) [branch: MDL-84763 | CI Job ] More information about this report Built on: Thu Mar 6 16:00:57 UTC 2025

      In relation to MDL-77180 it turns out the naming field is much too short to facilitate a significant range of multilang tags.

      Although an effort was made to fix the multilang feature (although Paul Holden correctly mentioned whether the classification should be a bug or an improvement in the aforementioned issue), it still is too limited.

      The name field for custom field categories is only 400 characters maximum, which is too short to facilitate both longer names and multilanguage support.

       

      Reproduction steps:

      1. Make sure enough language packs are installed and multilang filtering is enabled
      2. Open Course custom fields page by "Site administration" > "Courses" tab > "Course custom fields".
      3. Click "Add a new category" button.
      4. Click "Other fields" and type "<span class="multilang" lang="en">A somewhat longer category name (EN)</span><span class="multilang" lang="de">A somewhat longer category name (DE)</span><span class="multilang" lang="fr">A somewhat longer category name (FR)</span><span class="multilang" lang="id">A somewhat longer category name (ID)</span><span class="multilang" lang="nl">A somewhat longer category name (NL)</span><span class="multilang" lang="tr">A somewhat longer category name (TR)</span>
        ", then Enter.
      5. Confirm you run into a "dmlwriteexception" which mentions that the data is too long (the actual message may vary depending on the database engine in use)

        1. dmlwriteexception.png
          dmlwriteexception.png
          22 kB

            pholden Paul Holden
            rogiervandongen Rogier van Dongen
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:

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