-
Bug
-
Resolution: Fixed
-
Minor
-
3.1, 3.4.5, 3.5.2, 3.6, 3.7.4, 3.11.5
-
MOODLE_311_STABLE, MOODLE_31_STABLE, MOODLE_34_STABLE, MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE
-
MOODLE_311_STABLE
-
MDL-54724-master -
There has been situations where restore or upgrade were compromised because of invalid values in the sequence column of multianswer (Cloze) questions. In this issue we should investigate and fix the root cause. It appears that sequences could contain empty values, e.g: ,,.
One of the causes could be that mappings to new question IDs were not found during restore, thus creating $sequence = implode(',', array(1, false, 3, ...)). That is based on my observations from MDL-35987.
The following SQL statement may help identify invalid sequences:
SELECT * |
FROM mdl_question_multianswer |
WHERE sequence IS NULL |
OR sequence LIKE '' |
OR sequence LIKE '%,,%'; |
- caused a regression
-
MDL-74299 Can't delete Questions from Question bank
- Closed
- has been marked as being related by
-
MDL-75079 Investigate duplicate sequences in question_multianswer
- Open
-
MDL-35987 Backup error: invalid input syntax for integer: "" during restore of multianswer question
- Closed
-
MDL-52203 Error upgrading multianswer question to 3.0
- Closed
-
MDL-78008 Missing sub-questions of multianswer questions cause exceptions in the recalculate question statistics task
- Closed
- is duplicated by
-
MDL-66355 Course backup not restored due to Quiz Multianswer not mapping correctly (Postgres)
- Closed
- will be (partly) resolved by
-
MDL-14802 It is possible to move shared questions in the question bank to a place where they are no longer properly shared
- Reopened