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

      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.

        Gliffy Diagrams

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: