Using Umlauts in Filter Name leads to Database Error

Created on 25 January 2024, 10 months ago

Problem/Motivation

Using Umlauts in Filter Name leads to Database Error.

Steps to reproduce

Add german umlauts like "äöü" in the title of any filter leads to an error in the AJAX saving call. Here is the complete error log message:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC3\xA4\xC3\xB6\xC3\xBC' for column `c1m`.`views_save_search_filter`.`filter_title` at row 1: INSERT INTO "views_save_search_filter" ("filter_title", "filter_url", "view_id", "user_id", "username", "created") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => äöü

Proposed resolution

Encode umlauts or other special characters correctly.

🐛 Bug report
Status

Active

Version

1.1

Component

Code

Created by

🇦🇹Austria roromedia Linz

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024