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.