Bug beim erstellen eines Smileys mit bereits vorhandenem Smileycode (Duplikat)

  • Affected Version
    WoltLab Suite 5.3
    Affected App
    WoltLab Suite Core

    Nabend,

    es gibt einen Bug in der Suite Version 5.3.22.

    Wenn man einen Smiley erstellt und der Smiley-Code bereits in der Datenbank vorhanden ist, kommt ein SQL Fehler anstelle einer normalen Fehlermeldung.


    Requested URL
    POST /core/acp/index.php?smiley-add/
    Referrer
    WoltLab Suite
    5.3.22
    PHP
    7.4.29
    Error Message
    Could not execute statement 'INSERT INTO wcf1_smiley (smileyTitle,smileyCode,aliases,smileyPath,smileyPath2x,showOrder,categoryID,packageID) VALUES (?,?,?,?,?,?,?,?)'
    Type
    wcf\system\database\exception\DatabaseQueryExecutionException
    File (Line)
    /mnt/------/a3/39/---------/htdocs/core/lib/system/database/statement/PreparedStatement.class.php (105)
    Query Parameter 1
    'Haha'
    Query Parameter 2
    'XD'
    Query Parameter 3
    'XD'
    Query Parameter 4
    ''
    Query Parameter 5
    ''
    Query Parameter 6
    17
    Query Parameter 7
    2
    Query Parameter 8
    1
    Stacktrace
    1. /mnt/------/a3/39/---------/htdocs/core/lib/data/DatabaseObjectEditor.class.php (38): wcf\system\database\statement\PreparedStatement->execute(…)
    2. [internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
    3. /mnt/------/a3/39/---------/htdocs/core/lib/data/AbstractDatabaseObjectAction.class.php (336): call_user_func(…)
    4. /mnt/------/a3/39/---------/htdocs/core/lib/data/smiley/SmileyAction.class.php (47): wcf\data\AbstractDatabaseObjectAction->create(…)
    5. /mnt/------/a3/39/---------/htdocs/core/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\smiley\SmileyAction->create(…)
    6. /mnt/------/a3/39/---------/htdocs/core/lib/acp/form/SmileyAddForm.class.php (201): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    7. /mnt/------/a3/39/---------/htdocs/core/lib/form/AbstractForm.class.php (62): wcf\acp\form\SmileyAddForm->save(…)
    8. /mnt/------/a3/39/---------/htdocs/core/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
    9. /mnt/------/a3/39/---------/htdocs/core/lib/acp/form/SmileyAddForm.class.php (145): wcf\form\AbstractForm->readData(…)
    10. /mnt/------/a3/39/---------/htdocs/core/lib/page/AbstractPage.class.php (291): wcf\acp\form\SmileyAddForm->readData(…)
    11. /mnt/------/a3/39/---------/htdocs/core/lib/page/AbstractPage.class.php (114): wcf\page\AbstractPage->show(…)
    12. /mnt/------/a3/39/---------/htdocs/core/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
    13. /mnt/------/a3/39/---------/htdocs/core/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    14. /mnt/------/a3/39/---------/htdocs/core/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)
    Error Message
    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'XD' for key 'smileyCode'
    Type
    PDOException
    File (Line)
    /mnt/------/a3/39/---------/htdocs/core/lib/system/database/statement/PreparedStatement.class.php (93)
    Stacktrace
    1. /mnt/------/a3/39/---------/htdocs/core/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
    2. /mnt/------/a3/39/---------/htdocs/core/lib/data/DatabaseObjectEditor.class.php (38): wcf\system\database\statement\PreparedStatement->execute(…)
    3. [internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
    4. /mnt/------/a3/39/---------/htdocs/core/lib/data/AbstractDatabaseObjectAction.class.php (336): call_user_func(…)
    5. /mnt/------/a3/39/---------/htdocs/core/lib/data/smiley/SmileyAction.class.php (47): wcf\data\AbstractDatabaseObjectAction->create(…)
    6. /mnt/------/a3/39/---------/htdocs/core/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\smiley\SmileyAction->create(…)
    7. /mnt/------/a3/39/---------/htdocs/core/lib/acp/form/SmileyAddForm.class.php (201): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    8. /mnt/------/a3/39/---------/htdocs/core/lib/form/AbstractForm.class.php (62): wcf\acp\form\SmileyAddForm->save(…)
    9. /mnt/------/a3/39/---------/htdocs/core/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
    10. /mnt/------/a3/39/---------/htdocs/core/lib/acp/form/SmileyAddForm.class.php (145): wcf\form\AbstractForm->readData(…)
    11. /mnt/------/a3/39/---------/htdocs/core/lib/page/AbstractPage.class.php (291): wcf\acp\form\SmileyAddForm->readData(…)
    12. /mnt/------/a3/39/---------/htdocs/core/lib/page/AbstractPage.class.php (114): wcf\page\AbstractPage->show(…)
    13. /mnt/------/a3/39/---------/htdocs/core/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
    14. /mnt/------/a3/39/---------/htdocs/core/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    15. /mnt/------/a3/39/---------/htdocs/core/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!