Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.6.3
-
Component/s: Quiz
-
Labels:None
-
Environment:Suse Linux, PHP 5, MySQL
-
Database:MySQL
-
Affected Branches:MOODLE_16_STABLE
-
Fixed Branches:MOODLE_16_STABLE, MOODLE_17_STABLE, MOODLE_18_STABLE
-
Rank:27951
Description
In Examview, I have attached an export file (Examview XML) that fails to import into Moodle when apostrophe's exist in the answer sets. You may use this file for testing.
Activity
The Examview XML file is different to others I have seen. The text seems to be enclosed in <font> tags that I have not seen in other Examview formats. To illustrate, other examview formats have
<text>Your answer here</text>
but the test file has
<text><font number="2"><font size="10">Your answer here</font></font></text>
...which is what seems to be breaking this import. I'm no expert on Examview, so I;m unsure why you are seeing this.
Show
Howard Miller
added a comment - The Examview XML file is different to others I have seen. The text seems to be enclosed in <font> tags that I have not seen in other Examview formats. To illustrate, other examview formats have
<text>Your answer here</text>
but the test file has
<text><font number="2"><font size="10">Your answer here</font></font></text>
...which is what seems to be breaking this import. I'm no expert on Examview, so I;m unsure why you are seeing this.
Attached file now imports correctly.
Show
Howard Miller
added a comment - Attached file now imports correctly.
Confirmed.... SQL errors are caused as the question text is not properly escaped. This shows up several other notices as well. I will clean it all up asap.