The staffrolename field in the scheduler table is too short. According to Moodle's role_names table, a role name field should be defined as VARCHAR(255).
The reason this is an issue for me is because I need to be able to specify the role name in multiple languages in this field and the 40 characters defined in the scheduler table schema for this purpose doesn't allow me to do that.
For example, I use the Moodle multi-lingual content filter. In the "Role name of the teacher" field, I would enter the following string:
This example requires 52 characters. When I enter this string and click either of the Save buttons, I get the following error message:
"Data too long for column "staffrolename" at row 1"
Fixing the issue will require the following 2 changes:
CHANGE #1 - Please expand the size of the staffrolename field in the scheduler database table to 255 characters.
CHANGE #2 - To enable multilingual filtering of text entered in the field, please modify the function scheduler_get_teacher_name() in /mod/scheduler/locallib.php:
Please let me know if you have any questions or concerns regarding these changes.
Please expand the size of this field.