We are unable to restore course backups. Backup fails with error_question_answers_missing_in_db or error_question_match_sub_missing_in_db.
We tested restoring course in new installation and it worked but restore fails on production site.
On further investigation it was found that during restore operation db select queries like[1] remove special symbols like '&' from query which results in empty results.
We also checked restored course in new installation. All questions/answers had removed special symbols. For e.g. 'Both A & B' was converted into 'Both A B'.
Another major problem is that restore operation is reconverting html into html. It means that all html code ( for e.g. <P> Tag) is now displayed to user in browser.
[1] SELECT id FROM
{question_answers}WHERE question = ? AND answer = ?
- has been marked as being related by
-
MDL-36683 impossible to duplicate a quiz when Course question bank contains matching questions
-
- Closed
-