- Affected App
- WoltLab Suite Core
Ein User meines Forums wollte das Zeichen http://www.fileformat.info/info/unicode/char/1f4bb/index.htm in seinen Benutzertitel einfügen und löste damit folgende Fehlermeldung aus:
Code
Fri, 12 Feb 2016 12:07:28 +0000
Message: Could not execute prepared statement: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x92\xBB' for column 'userTitle' at row 1
File: /var/www/vhosts/example.com/httpdocs/wcf/lib/system/database/statement/PreparedStatement.class.php (100)
PHP version: 5.4.45-0+deb7u2
WCF version: 2.0.13 (Maelstrom)
Request URI: /index.php/AJAXProxy/?
Referrer: http://www.example.com/index.php/User/12345-User/?editOnInit=true
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0
Information: ""
Stacktrace:
#0 /var/www/vhosts/example.com/httpdocs/wcf/lib/data/DatabaseObjectEditor.class.php(69): wcf\system\database\statement\PreparedStatement->execute(Array)
#1 /var/www/vhosts/example.com/httpdocs/wcf/lib/data/user/UserEditor.class.php(84): wcf\data\DatabaseObjectEditor->update(Array)
#2 /var/www/vhosts/example.com/httpdocs/wcf/lib/data/AbstractDatabaseObjectAction.class.php(339): wcf\data\user\UserEditor->update(Array)
#3 /var/www/vhosts/example.com/httpdocs/wcf/lib/data/user/UserAction.class.php(284): wcf\data\AbstractDatabaseObjectAction->update()
#4 [internal function]: wcf\data\user\UserAction->update()
#5 /var/www/vhosts/example.com/httpdocs/wcf/lib/data/AbstractDatabaseObjectAction.class.php(182): call_user_func(Array)
#6 /var/www/vhosts/example.com/httpdocs/wcf/lib/data/user/UserProfileAction.class.php(273): wcf\data\AbstractDatabaseObjectAction->executeAction()
#7 [internal function]: wcf\data\user\UserProfileAction->save()
#8 /var/www/vhosts/example.com/httpdocs/wcf/lib/data/AbstractDatabaseObjectAction.class.php(182): call_user_func(Array)
#9 /var/www/vhosts/example.com/httpdocs/wcf/lib/action/AJAXProxyAction.class.php(76): wcf\data\AbstractDatabaseObjectAction->executeAction()
#10 /var/www/vhosts/example.com/httpdocs/wcf/lib/action/AJAXInvokeAction.class.php(96): wcf\action\AJAXProxyAction->invoke()
#11 /var/www/vhosts/example.com/httpdocs/wcf/lib/action/AbstractAction.class.php(49): wcf\action\AJAXInvokeAction->execute()
#12 /var/www/vhosts/example.com/httpdocs/wcf/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()
#13 /var/www/vhosts/example.com/httpdocs/wcf/lib/system/request/Request.class.php(58): wcf\action\AJAXInvokeAction->__run()
#14 /var/www/vhosts/example.com/httpdocs/wcf/lib/system/request/RequestHandler.class.php(108): wcf\system\request\Request->execute()
#15 /var/www/vhosts/example.com/httpdocs/index.php(10): wcf\system\request\RequestHandler->handle('wbb')
#16 {main}