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

SQL dmlreadexception

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.5.6
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Affected Branches:
      MOODLE_35_STABLE

      Description

      When attempting to convert my site to HTTPS, I receive the error listed below.

       

      Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} WHERE summary REGEXP '(src|data)
      *=
      *\\\"\\\'http://'' at line 1

      SELECT summary FROM {Courses} WHERE summary REGEXP ?
      [array (
      {{ 0 => '(src|data)
      *=
      *\\"\\\'http://',}}
      )]
      Error code: dmlreadexception}}{{Stack trace:

      • line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
      • line 1184 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1294 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_recordset_sql()
      • line 170 of /admin/tool/httpsreplace/classes/url_finder.php: call to moodle_database->get_recordset_select()
      • line 48 of /admin/tool/httpsreplace/classes/url_finder.php: call to tool_httpsreplace\url_finder->process()
      • line 68 of /admin/tool/httpsreplace/tool.php: call to tool_httpsreplace\url_finder->http_link_stats()

      I'm unable to find the SQL syntax error as I am unable to find the SQL query that's generating the error.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            awallace Andrew Wallace
            Participants:
            Component watchers:
            Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: