Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
3.6.4, 3.7.1, 3.8, 3.9
-
MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE, MOODLE_39_STABLE
-
MOODLE_37_STABLE, MOODLE_38_STABLE
-
NOTE to tester: It's enough to test this in just one branch, as far as this is also covered via unit tests and the patches are 100% the same.
- Log in as admin
- Navigate to Courses > Upload courses in site administration
- Upload MDL-66024-fullname.csv
to the File file manager - Press Preview
- Confirm the Upload courses preview result column contains a cross and the Status is "The fullname field is limited to 254 characters"
- Press Upload courses
- Confirm you see the following in the summary:
- Courses total: 1
- Courses errors: 1
- Press Continue
- Upload MDL-66024-shortname.csv to the File file manager
- Press Preview
- Confirm the Upload courses preview result column contains a cross and the Status is "The shortname field is limited to 255 characters"
- Press Upload courses
- Confirm you see the following in the summary:
- Courses total: 1
- Courses errors: 1
P.S. No, I don't know why the shortname field is longer than the fullname field
NOTE to tester: It's enough to test this in just one branch, as far as this is also covered via unit tests and the patches are 100% the same. Log in as admin Navigate to Courses > Upload courses in site administration Upload MDL-66024-fullname.csv to the File file manager Press Preview Confirm the Upload courses preview result column contains a cross and the Status is "The fullname field is limited to 254 characters" Press Upload courses Confirm you see the following in the summary: Courses total: 1 Courses errors: 1 Press Continue Upload MDL-66024-shortname.csv to the File file manager Press Preview Confirm the Upload courses preview result column contains a cross and the Status is "The shortname field is limited to 255 characters" Press Upload courses Confirm you see the following in the summary: Courses total: 1 Courses errors: 1 P.S. No, I don't know why the shortname field is longer than the fullname field
Description
1) use this .csv with delimeter ";":
shortname;fullname;category_path;startdate;enddate
test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading;test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading test with long enough field value that will not be checked while uploading;1;09.09.2019;18.07.2020
2) Preview shows everything is fine
3) Uploading and getting SQL error:
