Resolution: Not a bug
Affects Version/s: 1.7.1
Component/s: Database SQL/XMLDB
Environment:Moodle 1.7+ running on Ubuntu Dapper Drake/PHP5/Apache2
First note: I initially thought this was a problem only with the WYSIWYG HTML editor (and raised an issue
MDL-8468 regarding this). Since then I have found that it affects any string I have entered into the Moodle site.
We are using an Oracle database as our main back-end (new OCI8PO functionality in Oracle 7). It has worked OK, except that any double-quote characters are not being escaped correctly, and are being left with a leading backslash after being saved to the database. This was first spotted in HTML tag attributes:
Additionally, any time that we edit this again, another two backslashes are added. So (unless we modify the above), on the next edit it would become:
This has also affected other things, for example we have a sandbox course available named "doodle" (where our lecturers can play about) - the course name itself has exhibited this incorrect escaping (and is displaying as \\\"doodle\\\").
I've looked into the raw database and seen that the strings are being saved in this incorrect escaped form.
If anybody would like to investigate our site as part of the support process, I have set the Qube "Doodle" course on our Moodle installation http://qube.harlow-college.ac.uk to allow guest access. The course exists within the category "Qube for Staff".