-
Bug
-
Resolution: Fixed
-
Major
-
4.1
-
MOODLE_401_STABLE
-
MOODLE_311_STABLE, MOODLE_400_STABLE
-
m41_
MDL-74912_Fix_RegExp_Word_Boundaries_On_MySQL8 -
While working on MDLSITE-6376, some behat tests were launched (@mod_forum) with MySQL 8. And it failed.
This is the job: https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/24381/
And this is the error (from the logs):
001 Scenario: Perform an advanced search using whole words # /var/www/html/mod/forum/tests/behat/advanced_search.feature:59
|
When I press "Search" # /var/www/html/mod/forum/tests/behat/advanced_search.feature:67
|
Moodle exception: Exception - Warning: mysqli::query(): (HY000/3685): Illegal argument to a regular expression. in [dirroot]/lib/dml/mysqli_native_moodle_database.php on line 1272More information about this error
|
|
Exception - Warning: mysqli::query(): (HY000/3685): Illegal argument to a regular expression. in [dirroot]/lib/dml/mysqli_native_moodle_database.php on line 1272
|
|
Debug:
|
|
Error code: generalexceptionmessage
|
* line 157 of /lib/behat/lib.php: Exception thrown
|
* line ? of unknownfile: call to behat_error_handler()
|
* line 1272 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli->query()
|
* line 1671 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
|
* line 1744 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
|
* line 1954 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
|
* line 1256 of /mod/forum/lib.php: call to moodle_database->count_records_sql()
|
* line 166 of /mod/forum/search.php: call to forum_search_posts()
|
, referer: http://webserverca0499b3df001f39/behatrun3/mod/forum/search.php?id=102000&search=
|
Only tested with master (4.1dev) but surely affects older versions too.
- Discovered while testing
-
MDLSITE-6376 Set up Mysql8 jobs for workplace on ci.moodle.org
-
- Closed
-