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

Semicolon in SQL breaks wiki 'Administration' tab on Oracle

XMLWordPrintable

    • Oracle
    • MOODLE_21_STABLE
    • MOODLE_21_STABLE, MOODLE_22_STABLE
    • MDL-31546-master
    • Easy
    • Hide

      1/ Create a wiki activity in a course
      2/ Add a page
      3/ Click the administration tab
      Expected Result:
      Admin page with menu and list of orphaned apge
      Actual Result
      Oracle DB error

      Show
      1/ Create a wiki activity in a course 2/ Add a page 3/ Click the administration tab Expected Result: Admin page with menu and list of orphaned apge Actual Result Oracle DB error

      A semicolon at the end of the SQL query in wiki_get_orphaned_pages() causes an exception on Oracle. Patch attached.

        1. MDL-31546-stray-semicolon.patch
          0.7 kB

            poltawski Dan Poltawski
            jonof Jonathon Fowler
            Dan Poltawski Dan Poltawski
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Aparup Banerjee Aparup Banerjee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.