Moodle
  1. Moodle
  2. MDL-10026

mdl_course shortname has incorrect length

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor 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
    • Rank:
      29435

      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.

        Activity

          People

          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: