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

mdl_course shortname has incorrect length

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.6.5, 1.7.2, 1.8
    • Fix Version/s: 1.9
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Any
    • Database:
      Any
    • Affected Branches:
      MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      Both the old mysql.sql files (for 1.7.x and below) and the new install.xml (for 1.7.x and above) file specify an incorrect lenght for the 'shortname' field. The current lenght is 100 characteres (as has always been for MySQL) but Postgres has always had 15 characters, and this is the limit imposed by the code in several places, and is also the value for the 'shortname' field in prefix_course_request.

      I know this is not a severe bug, but making the whole thing homogen would certainly help when dealing with the code There is no way this could break existing installations, except for those creating course by directly inserting valures in prefix_course, as Moodle doesn't allow you to use more than 15 characters for the shortname if using the web interface.

      Saludos. Iñaki.

        Attachments

          Activity

            People

            Assignee:
            stronk7 Eloy Lafuente (stronk7)
            Reporter:
            iarenaza Iñaki Arenaza
            Tester:
            Nicolas Martignoni
            Participants:
            Component watchers:
            Andrew Nicols, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              3/Mar/08