search-term escapen

[alxndr-w]

rex_sql_exception: Error while executing statement "SELECT DISTINCT a.id, a.wildcard AS wildcard, clang1.replace AS id1 FROM rex_sprog_wildcard AS a LEFT JOIN rex_sprog_wildcard AS clang1 ON a.id = clang1.id AND clang1.clang_id = 1 WHERE 1 AND (a.wildcard LIKE "%"%" OR a.replace LIKE "%"%") ORDER BY wildcard" using params []! SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%" OR a.replace LIKE "%"%") ORDER BY wildcard' at line 1
File: src/core/lib/sql/sql.php
Line: 418

Stacktrace

Function	File	Line
rex_sql->execute	src/core/lib/sql/sql.php	461
rex_sql->setQuery	src/addons/sprog/pages/wildcard.clang_all.php	170
require	src/core/lib/packages/package.php	280
rex_package->includeFile	src/core/lib/be/controller.php	489
rex_be_controller::{closure}	src/core/lib/util/timer.php	57
rex_timer::measure	src/core/lib/be/controller.php	490
rex_be_controller::includePath	src/core/lib/be/controller.php	439
rex_be_controller::includeCurrentPageSubPath	src/addons/sprog/pages/index.php	17
require	src/core/lib/packages/package.php	280
rex_package->includeFile	src/core/lib/be/controller.php	489
rex_be_controller::{closure}	src/core/lib/util/timer.php	57
rex_timer::measure	src/core/lib/be/controller.php	490
rex_be_controller::includePath	src/core/lib/be/controller.php	422
rex_be_controller::includeCurrentPage	src/core/backend.php	239
require	src/core/boot.php	143
require	public/redaxo/index.php	12

System report (REDAXO 5.14.1, PHP 8.0.22, MySQL 8.0.30)

REDAXO
Version	5.14.1

PHP
Version	8.0.22
OPcache	yes
Xdebug	no

Database
Version	MySQL 8.0.30
Character set	utf8mb4

Server
OS	Linux
SAPI	fpm-fcgi
Webserver	Apache/2.4.41

Request
Browser	Chrome/106.0.0.0
Protocol	HTTP/1.1
HTTPS	yes

Packages
adminer	1.9.2
auto_delete	1.0-dev
backup	2.8.2
be_style	3.1.0
be_style/customizer	3.1.0
be_style/redaxo	3.1.0
bloecks	3.1.1
bloecks/cutncopy	3.1.1
cke5	5.2.0
cronjob	2.9.0
cronjob/article_status	2.8.1
debug	1.2.2
developer	3.9.1
feeds	3.3.1
focuspoint	4.0.2
install	2.10.0
maintenance	2.8.5
mblock	3.4.7
media_manager	2.13.0
mediapool	2.12.0
metainfo	2.9.0
phpmailer	2.11.2
project	dev
qanda	2.0.11
search_it	6.9.5
search_it/documentation	6.9.5
search_it/stats	6.9.5
sh	dev
sprog	1.4.0
statistics	2.2.0
structure	2.14.1
structure/content	2.14.1
structure/history	2.14.1
uploader	2.3.0
url	2.0.2
users	2.9.0
watson	2.3.0-beta1
ycom	4.0.7
ycom/auth	4.0.7
ycom/group	4.0.7
ydeploy	1.1.1
yform	4.0.2
yform/email	4.0.2
yform/manager	4.0.2
yform/tools	4.0.2
yform_spam_protection	1.2.1
yform_usability	2.0.5
yrewrite	2.9.1
yrewrite_scheme	3.6.2