Sign-in-Meldung trotz www.-Domain und korrekten Systemeinstellungen

[alxndr-w]

Was kann ich tun?

[tbaddade]

Was kann ich tun?

Deine Backend Url so wie hier aufrufen /redaxo/index.php?watson_query=%C3%BC

Dann sollte ein Fehler/Whoops erscheinen und den Stacktrace dann hier posten.

[alxndr-w]

rex_sql_exception thrown with message "Error while executing statement "                                SELECT      id, name AS name                                FROM        rex_dance_voucher_order                                WHERE       (to LIKE "%ü%") OR (euro LIKE "%ü%") OR (name LIKE "%ü%") OR (street LIKE "%ü%") OR (zip LIKE "%ü%") OR (city LIKE "%ü%") OR (phone LIKE "%ü%") OR (email LIKE "%ü%") OR (kname LIKE "%ü%") OR (iban LIKE "%ü%") OR (blz LIKE "%ü%") OR (message LIKE "%ü%")                                ORDER BY    id LIMIT 20"! 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 'to LIKE "%ü%") OR (euro LIKE "%ü%") OR (name LIKE "%ü%") OR (street LIKE "%ü' at line 1"

Stacktrace:
#12 rex_sql_exception in /www/htdocs/example.org/www/redaxo/src/core/lib/sql/sql.php:360
#11 PDOException in /www/htdocs/example.org/www/redaxo/src/core/lib/sql/sql.php:355
#10 PDO:query in /www/htdocs/example.org/www/redaxo/src/core/lib/sql/sql.php:355
#9 rex_sql:{closure} in /www/htdocs/example.org/www/redaxo/src/core/lib/util/timer.php:61
#8 rex_timer:measure in /www/htdocs/example.org/www/redaxo/src/core/lib/sql/sql.php:356
#7 rex_sql:setQuery in /www/htdocs/example.org/www/redaxo/src/addons/watson/lib/Watson/Foundation/Workflow.php:58
#6 Watson\Foundation\Workflow:getDatabaseResults in /www/htdocs/example.org/www/redaxo/src/addons/watson/lib/Watson/Workflows/YForm/YFormSearch.php:100
#5 Watson\Workflows\YForm\YFormSearch:fire in /www/htdocs/example.org/www/redaxo/src/addons/watson/lib/Watson/Foundation/Extension.php:112
#4 Watson\Foundation\Extension:run in /www/htdocs/example.org/www/redaxo/src/core/lib/extension.php:45
#3 rex_extension:registerPoint in /www/htdocs/example.org/www/redaxo/src/core/packages.php:31
#2 include_once in /www/htdocs/example.org/www/redaxo/src/core/backend.php:185
#1 require in /www/htdocs/example.org/www/redaxo/src/core/boot.php:135
#0 require in /www/htdocs/example.org/www/redaxo/index.php:11

[tbaddade]

Nimm mal die GH Version, da werden die Felder in Brackets gesetzt.

[alxndr-w]

Danke. Release wäre cool.

[alxndr-w]

Release wäre immer noch cool ;) Bin gerade wieder in einem Projekt darübergestolpert.

Edit: Könnte auch ein neues Problem sein.

[alxndr-w]

rex_sql_exception thrown with message "Error while executing statement "                                SELECT      id                                FROM        `rex_sh_email_template`                                WHERE       (`key` LIKE "%ü%") OR (`subject` LIKE "%ü%") OR (`body` LIKE "%ü%")                                ORDER BY    key LIMIT 20" 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 'key LIMIT 20' at line 1"

Stacktrace:
#13 rex_sql_exception in /var/www/xx/releases/128/src/core/lib/sql/sql.php:418
#12 PDOException in /var/www/xx/releases/128/src/core/lib/sql/sql.php:414
#11 PDOStatement:execute in /var/www/xx/releases/128/src/core/lib/sql/sql.php:414
#10 rex_sql:execute in /var/www/xx/releases/128/src/core/lib/sql/sql.php:461
#9 rex_sql:setQuery in /var/www/xx/releases/128/src/addons/watson/lib/Watson/Foundation/Workflow.php:58
#8 Watson\Foundation\Workflow:getDatabaseResults in /var/www/xx/releases/128/src/addons/watson/lib/Watson/Workflows/YForm/YFormSearch.php:107
#7 Watson\Workflows\YForm\YFormSearch:fire in /var/www/xx/releases/128/src/addons/watson/lib/Watson/Foundation/Extension.php:144
#6 Watson\Foundation\Extension:run in /var/www/xx/releases/128/src/core/lib/extension.php:52
#5 rex_extension:{closure} in /var/www/xx/releases/128/src/core/lib/util/timer.php:57
#4 rex_timer:measure in /var/www/xx/releases/128/src/core/lib/extension.php:63
#3 rex_extension:registerPoint in /var/www/xx/releases/128/src/core/packages.php:33
#2 include_once in /var/www/xx/releases/128/src/core/backend.php:201
#1 require in /var/www/xx/releases/128/src/core/boot.php:143
#0 require in /var/www/xx/releases/128/public/redaxo/index.php:12

ORDER BY key wurde vermutlich nicht escaped