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

Insufficient text field size for intro in resource tables

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.3
    • 2.0
    • Resource
    • None
    • MySQL
    • MOODLE_20_STABLE
    • MOODLE_23_STABLE

      During the upgrade, the summary field in resource table is migrated into intro + introformat pair and the format of the field may be changed. because the field is defined as SMALLTEXT on MySQL servers, this field size may not be enough to accept the migrated value in the new format (it really happened to me).

      I suggest to increase the type of the field to "big" which will create LONGTEXT in MySQL. We should not use smaller sizes anyway IMHO and XMLDB should be fixed so that it always creates big text fields only. Otherwise, conversion from one DB engine to another would be problematic, too, as PostgreSQL for example has single TEXT type.

      If I read the upgrade code correctly, the patch is not that hard and the conversion of the field is pretty quick according to my experience.

            moodle.com Moodle HQ
            mudrd8mz David Mudrák (@mudrd8mz)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

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