Fatal SQL error in MySQL 8 in view projects_by_website

Created on 25 March 2025, 7 months ago

We’ve also identified that using the “matches regular expression” filter in Views causes a fatal SQL error in MySQL 8 when the filter value is empty. This results in the error (WSOD).

To resolve this, we changed the filter operator to “contains” in the view projects_by_website , which works with empty values in MySQL 8.

🐛 Bug report

Status

Active

Version

1.0

Component

Code

Created by

🇧🇪Belgium yazzbe

Live updates comments and jobs are added and updated live.

Comments & Activities

Issue created by @yazzbe
Comment 2 months ago →
🇧🇪Belgium tijsdeboeck Antwerp 🇧🇪 🇪🇺 🌎
I ran into the same issue, but in the Projects by name view display. The Website Projects view display Projects by website doesn't have a filter with regular expression.

Updating the Enabled project: Title filter in display Projects by name to use Contains instead of Regular expression fixed the problem for me.

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024