Compatibility with MySQL v8

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 3685 Illegal argument to a regular expression.: SELECT base_table.vid AS vid, base_table.nid AS nid Dec 29 17:20:16 drupal: FROM Dec 29 17:20:16 drupal: {node} base_table Dec 29 17:20:16 drupal: INNER JOIN {node_field_data} node_field_data ON node_field_data.nid = base_table.nid Dec 29 17:20:16 drupal: INNER JOIN {node__body} node__body ON node__body.entity_id = base_table.nid Dec 29 17:20:16 drupal: WHERE (node_field_data.type = :db_condition_placeholder_0) AND (node__body.body_value REGEXP BINARY :db_condition_placeholder_1); Array Dec 29 17:20:16 rupal: ( Dec 29 17:20:16 drupal: [:db_condition_placeholder_0] => blog_post Dec 29 17:20:16 drupal: [:db_condition_placeholder_1] => [[::]] Dec 29 17:20:16 drupal: )

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment over 1 year ago →
codebymikey
Was doing some code review in preparation for a Drupal 10 release and noticed that the tests were failing.

I'm currently running MySQL 5.7.29, and the new boundary regex notation introduced here isn't supported on it.
See http://sqlfiddle.com/#!9/ce3f8f/3

It appears we'd need some kind of MySQL version check to determine which type of regex should be used: https://dev.mysql.com/doc/refman/8.0/en/regexp.html#regexp-compatibility
Open on Drupal.org →
Core: 9.5.x + Environment: PHP 7.3 & MySQL 5.7
last update over 1 year ago
Waiting for branch to pass
@codebymikey opened merge request.
Open in Jenkins → Open on Drupal.org →
Core: 10.1.x + Environment: PHP 8.1 & MySQL 8
last update over 1 year ago
2 pass, 2 fail
Status changed to Fixed over 1 year ago3:29pm 12 May 2023
Comment over 1 year ago →
🇺🇸United States DamienMcKenna NH, USA
This is being handled in 📌 Fix MySQL 7.4 vs 8 compatibility bugs Fixed .
Open on Drupal.org →
Core: 9.5.x + Environment: PHP 7.3 & MySQL 5.7
last update over 1 year ago
Waiting for branch to pass
Comment over 1 year ago →
codebymikey
Oh okay, thanks for that!
Comment over 1 year ago →
codebymikey
Comment over 1 year ago →
System Message
Automatically closed - issue fixed for 2 weeks with no activity.

Compatibility with MySQL v8

Problem/Motivation

Steps to reproduce

Comments & Activities