Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-1187

Updating lesson chokes on single quotes

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 1.5.3
    • Fix Version/s: None
    • Component/s: Lesson
    • Labels:
      None
    • Environment:
      Windows 2000
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_15_STABLE

      Description

      When adding a new lesson to a course, the update aborts if the new or edited page contents, question,or response field has a single quote in it. The mysql error is: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's' )' at line 1

      INSERT INTO mdl_lesson_pages ( lessonid, qtype, qoption, prevpageid, nextpageid, timecreated, contents ) VALUES ( 4, 3, 0, 0, 0, 1080155351, 'her's' ).

      That is why the lesson module will not allow updates sporadically - it isn't just insufficient php memory.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: