Maximale Länge von userOnlineMarking wird in UserGroupAddForm/UserGroupEditForm nicht überprüft

VieCode · Mar 28th 2020

Wenn man im Feld userOnlineMarking einen zu langen Text eingibt, wird ein Fehler geworfen. Die Limitierung von der Datenbank sollte auch entsprechend im Code überprüft werden. Fehler tritt im WSC 5.2 auf.

Requested URL: /acp/index.php?user-group-edit/10/

Referrer: https://[...]/acp/index.php?user-group-edit/10/

Error Message: Could not execute statement 'UPDATE wcf1_user_group SET leaderGroupID = ?, teamSpeakServerGroupIDs = ?, teamSpeakChannelIDs = ?, teamSpeakChannelGroupID = ?, teamSpeakGuestChannelGroupID = ?, teamSpeakSyncDirection = ?, canBeAddedAsConversationParticipant = ?, groupType = ?, groupName = ?, groupDescription = ?, priority = ?, userOnlineMarking = ?, showOnTeamPage = ?, allowMention = ? WHERE groupID = ?'

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /var/www/html/[...]/NEW/lib/system/database/statement/PreparedStatement.class.php (105)

Query Parameter 1: null

Query Parameter 2: null

Query Parameter 3: null

Query Parameter 4: null

Query Parameter 5: null

Query Parameter 6: '0'

Query Parameter 7: 0

Query Parameter 8: 4

Query Parameter 9: 'Owner'

Query Parameter 10: '%s'

Query Parameter 11: 1000

Query Parameter 12: '<span style=" background: linear-gradient(120deg, #090, #249dd4, #f00);background-repeat: no-repeat;background-size: 2000px;animation: gradient-animation 4s ease-in-out infinite;-webkit-background-clip: text;-webkit-text-fill-color: rgba(255, 255, 255, 0.1);font-weight: bold;">%s'

Query Parameter 13: 1

Query Parameter 14: 1

Query Parameter 15: 10

Stacktrace

/var/www/html/[...]/NEW/lib/data/DatabaseObjectEditor.class.php (68): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/html/[...]/NEW/lib/data/user/group/UserGroupAction.class.php (78): wcf\data\DatabaseObjectEditor->update(…)
[internal function] (?): wcf\data\user\group\UserGroupAction->update(…)
/var/www/html/[...]/NEW/lib/data/AbstractDatabaseObjectAction.class.php (205): call_user_func(…)
/var/www/html/[...]/NEW/lib/acp/form/UserGroupEditForm.class.php (186): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/html/[...]/NEW/lib/form/AbstractForm.class.php (62): wcf\acp\form\UserGroupEditForm->save(…)
/var/www/html/[...]/NEW/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
/var/www/html/[...]/NEW/lib/acp/form/AbstractOptionListForm.class.php (99): wcf\form\AbstractForm->readData(…)
/var/www/html/[...]/NEW/lib/acp/form/UserGroupAddForm.class.php (204): wcf\acp\form\AbstractOptionListForm->readData(…)
/var/www/html/[...]/NEW/lib/acp/form/UserGroupEditForm.class.php (108): wcf\acp\form\UserGroupAddForm->readData(…)
/var/www/html/[...]/NEW/lib/page/AbstractPage.class.php (291): wcf\acp\form\UserGroupEditForm->readData(…)
/var/www/html/[...]/NEW/lib/acp/form/UserGroupAddForm.class.php (242): wcf\page\AbstractPage->show(…)
/var/www/html/[...]/NEW/lib/page/AbstractPage.class.php (114): wcf\acp\form\UserGroupAddForm->show(…)
/var/www/html/[...]/NEW/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/html/[...]/NEW/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/html/[...]/NEW/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

Error Message: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'userOnlineMarking' at row 1

Type: PDOException

File (Line): /var/www/html/[...]/NEW/lib/system/database/statement/PreparedStatement.class.php (93)

Stacktrace

/var/www/html/[...]/NEW/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
/var/www/html/[...]/NEW/lib/data/DatabaseObjectEditor.class.php (68): wcf\system\database\statement\PreparedStatement->execute(…)
/var/www/html/[...]/NEW/lib/data/user/group/UserGroupAction.class.php (78): wcf\data\DatabaseObjectEditor->update(…)
[internal function] (?): wcf\data\user\group\UserGroupAction->update(…)
/var/www/html/[...]/NEW/lib/data/AbstractDatabaseObjectAction.class.php (205): call_user_func(…)
/var/www/html/[...]/NEW/lib/acp/form/UserGroupEditForm.class.php (186): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/html/[...]/NEW/lib/form/AbstractForm.class.php (62): wcf\acp\form\UserGroupEditForm->save(…)
/var/www/html/[...]/NEW/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
/var/www/html/[...]/NEW/lib/acp/form/AbstractOptionListForm.class.php (99): wcf\form\AbstractForm->readData(…)
/var/www/html/[...]/NEW/lib/acp/form/UserGroupAddForm.class.php (204): wcf\acp\form\AbstractOptionListForm->readData(…)
/var/www/html/[...]/NEW/lib/acp/form/UserGroupEditForm.class.php (108): wcf\acp\form\UserGroupAddForm->readData(…)
/var/www/html/[...]/NEW/lib/page/AbstractPage.class.php (291): wcf\acp\form\UserGroupEditForm->readData(…)
/var/www/html/[...]/NEW/lib/acp/form/UserGroupAddForm.class.php (242): wcf\page\AbstractPage->show(…)
/var/www/html/[...]/NEW/lib/page/AbstractPage.class.php (114): wcf\acp\form\UserGroupAddForm->show(…)
/var/www/html/[...]/NEW/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/html/[...]/NEW/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/html/[...]/NEW/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

Mon, 23 Mar 2020 20:13:38 +0000
Message: Could not execute statement 'UPDATE    wcf1_user_group
             SET    leaderGroupID = ?, teamSpeakServerGroupIDs = ?, teamSpeakChannelIDs = ?, teamSpeakChannelGroupID = ?, teamSpeakGuestChannelGroupID = ?, teamSpeakSyncDirection = ?, canBeAddedAsConversationParticipant = ?, groupType = ?, groupName = ?, groupDescription = ?, priority = ?, userOnlineMarking = ?, showOnTeamPage = ?, allowMention = ?
             WHERE    groupID = ?'
PHP version: 7.3.16-1+ubuntu18.04.1+deb.sury.org+1
WoltLab Suite version: 5.2.3
Request URI: /acp/index.php?user-group-edit/10/
Referrer: https://[...]/acp/index.php?user-group-edit/10/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0
Peak Memory Usage: 11567920/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'UPDATE    wcf1_user_group
             SET    leaderGroupID = ?, teamSpeakServerGroupIDs = ?, teamSpeakChannelIDs = ?, teamSpeakChannelGroupID = ?, teamSpeakGuestChannelGroupID = ?, teamSpeakSyncDirection = ?, canBeAddedAsConversationParticipant = ?, groupType = ?, groupName = ?, groupDescription = ?, priority = ?, userOnlineMarking = ?, showOnTeamPage = ?, allowMention = ?
             WHERE    groupID = ?'
Error Code: 22001
File: /var/www/html/[...]/NEW/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YToxNTp7aTowO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAxIjtpOjE7czo0OiJudWxsIjt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7czo0OiJudWxsIjt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7czo0OiJudWxsIjt9aTozO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA0IjtpOjE7czo0OiJudWxsIjt9aTo0O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA1IjtpOjE7czo0OiJudWxsIjt9aTo1O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA2IjtpOjE7czozOiInMCciO31pOjY7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDciO2k6MTtpOjA7fWk6NzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgOCI7aToxO2k6NDt9aTo4O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA5IjtpOjE7czo3OiInT3duZXInIjt9aTo5O2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxMCI7aToxO3M6MjQ0OiInJmx0O3N0cm9uZyZndDsmbHQ7c3BhbiBzdHlsZT0mcXVvdDtiYWNrZ3JvdW5kLWltYWdlOiB1cmwoaHR0cHM6Ly9nYWxheHlnYW1pbmcuZGUvaW1hZ2VzL3NwYXJrbGVfcHVycGxlLmdpZik7JnF1b3Q7Jmd0OyZsdDtzcGFuIHN0eWxlPSZxdW90O2NvbG9yOiAjZWUzYThjOyB0ZXh0LXNoYWRvdzogI0ZGQ0NDQyAzcHggM3B4IDEycHg7JnF1b3Q7Jmd0OyVzJmx0Oy9zcGFuJmd0OyZsdDsvc3BhbiZndDsmbHQ7L3N0cm9uZyZndDsnIjt9aToxMDthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTEiO2k6MTtpOjEwMDA7fWk6MTE7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDEyIjtpOjE7czo0NjI6IicmbHQ7c3Ryb25nJmd0OyZsdDtzcGFuIHN0eWxlPSZxdW90O2JhY2tncm91bmQtaW1hZ2U6IHVybCggaHR0cHM6Ly9nYWxheHlnYW1pbmcuZGUvaW1hZ2VzL3NwYXJrbGVfcHVycGxlLmdpZiApOyZxdW90OyZndDsmbHQ7c3BhbiBzdHlsZT0mcXVvdDsgICAgYmFja2dyb3VuZDogbGluZWFyLWdyYWRpZW50KDEyMGRlZywgIzA5MCwgIzI0OWRkNCwgI2YwMCk7YmFja2dyb3VuZC1yZXBlYXQ6IG5vLXJlcGVhdDtiYWNrZ3JvdW5kLXNpemU6IDIwMDBweDthbmltYXRpb246IGdyYWRpZW50LWFuaW1hdGlvbiA0cyBlYXNlLWluLW91dCBpbmZpbml0ZTstd2Via2l0LWJhY2tncm91bmQtY2xpcDogdGV4dDstd2Via2l0LXRleHQtZmlsbC1jb2xvcjogcmdiYSgyNTUsIDI1NSwgMjU1LCAwLjEpO2ZvbnQtd2VpZ2h0OiBib2xkOyZxdW90OyZndDslcyZsdDsvc3BhbiZndDsmbHQ7L3NwYW4mZ3Q7Jmx0Oy9zdHJvbmcmZ3Q7JyI7fWk6MTI7YToyOntpOjA7czoxODoiUXVlcnkgUGFyYW1ldGVyIDEzIjtpOjE7aToxO31pOjEzO2E6Mjp7aTowO3M6MTg6IlF1ZXJ5IFBhcmFtZXRlciAxNCI7aToxO2k6MTt9aToxNDthOjI6e2k6MDtzOjE4OiJRdWVyeSBQYXJhbWV0ZXIgMTUiO2k6MTtpOjEwO319
Stack Trace: [{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/data\/DatabaseObjectEditor.class.php","line":68,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/data\/user\/group\/UserGroupAction.class.php","line":78,"function":"update","class":"wcf\\data\\DatabaseObjectEditor","type":"->","args":[{"leaderGroupID":"[redacted]","teamSpeakServerGroupIDs":"[redacted]","teamSpeakChannelIDs":"[redacted]","teamSpeakChannelGroupID":"[redacted]","teamSpeakGuestChannelGroupID":"[redacted]","teamSpeakSyncDirection":"[redacted]","canBeAddedAsConversationParticipant":"[redacted]","groupType":"[redacted]","groupName":"[redacted]","groupDescription":"[redacted]","priority":"[redacted]","userOnlineMarking":"[redacted]","showOnTeamPage":"[redacted]","allowMention":"[redacted]"}]},{"function":"update","class":"wcf\\data\\user\\group\\UserGroupAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/acp\/form\/UserGroupEditForm.class.php","line":186,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\acp\\form\\UserGroupEditForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/form\/AbstractForm.class.php","line":123,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/acp\/form\/AbstractOptionListForm.class.php","line":99,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/acp\/form\/UserGroupAddForm.class.php","line":204,"function":"readData","class":"wcf\\acp\\form\\AbstractOptionListForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/acp\/form\/UserGroupEditForm.class.php","line":108,"function":"readData","class":"wcf\\acp\\form\\UserGroupAddForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\acp\\form\\UserGroupEditForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/acp\/form\/UserGroupAddForm.class.php","line":242,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\acp\\form\\UserGroupAddForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
======
Error Class: PDOException
Error Message: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'userOnlineMarking' at row 1
Error Code: 22001
File: /var/www/html/[...]/NEW/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/data\/DatabaseObjectEditor.class.php","line":68,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/data\/user\/group\/UserGroupAction.class.php","line":78,"function":"update","class":"wcf\\data\\DatabaseObjectEditor","type":"->","args":[{"leaderGroupID":"[redacted]","teamSpeakServerGroupIDs":"[redacted]","teamSpeakChannelIDs":"[redacted]","teamSpeakChannelGroupID":"[redacted]","teamSpeakGuestChannelGroupID":"[redacted]","teamSpeakSyncDirection":"[redacted]","canBeAddedAsConversationParticipant":"[redacted]","groupType":"[redacted]","groupName":"[redacted]","groupDescription":"[redacted]","priority":"[redacted]","userOnlineMarking":"[redacted]","showOnTeamPage":"[redacted]","allowMention":"[redacted]"}]},{"function":"update","class":"wcf\\data\\user\\group\\UserGroupAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/acp\/form\/UserGroupEditForm.class.php","line":186,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\acp\\form\\UserGroupEditForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/form\/AbstractForm.class.php","line":123,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/acp\/form\/AbstractOptionListForm.class.php","line":99,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/acp\/form\/UserGroupAddForm.class.php","line":204,"function":"readData","class":"wcf\\acp\\form\\AbstractOptionListForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/acp\/form\/UserGroupEditForm.class.php","line":108,"function":"readData","class":"wcf\\acp\\form\\UserGroupAddForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\acp\\form\\UserGroupEditForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/acp\/form\/UserGroupAddForm.class.php","line":242,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\acp\\form\\UserGroupAddForm","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/[...]\/NEW\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

Maximale Länge von userOnlineMarking wird in UserGroupAddForm/UserGroupEditForm nicht überprüft

Marcel Werk Apr 13th 2020

Marcel Werk Apr 13th 2020

Marcel Werk Apr 13th 2020

Participate now!

Share

Similar Threads

Neuerungen und Verbesserungen in WoltLab Suite 5.2

Verbesserungen zu Einladungen, Automatischer Import externer Kalender und Terminkonflikt-Erkennung