Affects Version/s: 1.6.5, 1.7.2, 1.8
Fix Version/s: 1.9
Component/s: Database SQL/XMLDB
Affected Branches:MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_18_STABLE
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.
|Field||Original Value||New Value|
|Fix Version/s||1.9 [ 10190 ]|
|Status||Open [ 1 ]||In Progress [ 3 ]|
|Status||In Progress [ 3 ]||Resolved [ 5 ]|
|Resolution||Fixed [ 1 ]|
|Status||Resolved [ 5 ]||Closed [ 6 ]|
|Workflow||jira [ 21073 ]||MDL Workflow [ 56222 ]|
|Workflow||MDL Workflow [ 56222 ]||MDL Full Workflow [ 85336 ]|