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

  • 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
    '<strong><span style="background-image: url(https://galaxygaming.de/images/sparkle_purple.gif);"><span style="color: #ee3a8c; text-shadow: #FFCCCC 3px 3px 12px;">%s</span></span></strong>'
    Query Parameter 11
    1000
    Query Parameter 12
    '<strong><span style="background-image: url( https://galaxygaming.de/images/sparkle_purple.gif );"><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</span></span></strong>'
    Query Parameter 13
    1
    Query Parameter 14
    1
    Query Parameter 15
    10
    Stacktrace
    1. /var/www/html/[...]/NEW/lib/data/DatabaseObjectEditor.class.php (68): wcf\system\database\statement\PreparedStatement->execute(…)
    2. /var/www/html/[...]/NEW/lib/data/user/group/UserGroupAction.class.php (78): wcf\data\DatabaseObjectEditor->update(…)
    3. [internal function] (?): wcf\data\user\group\UserGroupAction->update(…)
    4. /var/www/html/[...]/NEW/lib/data/AbstractDatabaseObjectAction.class.php (205): call_user_func(…)
    5. /var/www/html/[...]/NEW/lib/acp/form/UserGroupEditForm.class.php (186): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    6. /var/www/html/[...]/NEW/lib/form/AbstractForm.class.php (62): wcf\acp\form\UserGroupEditForm->save(…)
    7. /var/www/html/[...]/NEW/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
    8. /var/www/html/[...]/NEW/lib/acp/form/AbstractOptionListForm.class.php (99): wcf\form\AbstractForm->readData(…)
    9. /var/www/html/[...]/NEW/lib/acp/form/UserGroupAddForm.class.php (204): wcf\acp\form\AbstractOptionListForm->readData(…)
    10. /var/www/html/[...]/NEW/lib/acp/form/UserGroupEditForm.class.php (108): wcf\acp\form\UserGroupAddForm->readData(…)
    11. /var/www/html/[...]/NEW/lib/page/AbstractPage.class.php (291): wcf\acp\form\UserGroupEditForm->readData(…)
    12. /var/www/html/[...]/NEW/lib/acp/form/UserGroupAddForm.class.php (242): wcf\page\AbstractPage->show(…)
    13. /var/www/html/[...]/NEW/lib/page/AbstractPage.class.php (114): wcf\acp\form\UserGroupAddForm->show(…)
    14. /var/www/html/[...]/NEW/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
    15. /var/www/html/[...]/NEW/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    16. /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
    1. /var/www/html/[...]/NEW/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
    2. /var/www/html/[...]/NEW/lib/data/DatabaseObjectEditor.class.php (68): wcf\system\database\statement\PreparedStatement->execute(…)
    3. /var/www/html/[...]/NEW/lib/data/user/group/UserGroupAction.class.php (78): wcf\data\DatabaseObjectEditor->update(…)
    4. [internal function] (?): wcf\data\user\group\UserGroupAction->update(…)
    5. /var/www/html/[...]/NEW/lib/data/AbstractDatabaseObjectAction.class.php (205): call_user_func(…)
    6. /var/www/html/[...]/NEW/lib/acp/form/UserGroupEditForm.class.php (186): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    7. /var/www/html/[...]/NEW/lib/form/AbstractForm.class.php (62): wcf\acp\form\UserGroupEditForm->save(…)
    8. /var/www/html/[...]/NEW/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
    9. /var/www/html/[...]/NEW/lib/acp/form/AbstractOptionListForm.class.php (99): wcf\form\AbstractForm->readData(…)
    10. /var/www/html/[...]/NEW/lib/acp/form/UserGroupAddForm.class.php (204): wcf\acp\form\AbstractOptionListForm->readData(…)
    11. /var/www/html/[...]/NEW/lib/acp/form/UserGroupEditForm.class.php (108): wcf\acp\form\UserGroupAddForm->readData(…)
    12. /var/www/html/[...]/NEW/lib/page/AbstractPage.class.php (291): wcf\acp\form\UserGroupEditForm->readData(…)
    13. /var/www/html/[...]/NEW/lib/acp/form/UserGroupAddForm.class.php (242): wcf\page\AbstractPage->show(…)
    14. /var/www/html/[...]/NEW/lib/page/AbstractPage.class.php (114): wcf\acp\form\UserGroupAddForm->show(…)
    15. /var/www/html/[...]/NEW/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
    16. /var/www/html/[...]/NEW/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    17. /var/www/html/[...]/NEW/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!