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

Captain Crunch · May 22, 2022 at 1:13 AM

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

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

/mnt/------/a3/39/---------/htdocs/core/lib/data/DatabaseObjectEditor.class.php (38): wcf\system\database\statement\PreparedStatement->execute(…)
[internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
/mnt/------/a3/39/---------/htdocs/core/lib/data/AbstractDatabaseObjectAction.class.php (336): call_user_func(…)
/mnt/------/a3/39/---------/htdocs/core/lib/data/smiley/SmileyAction.class.php (47): wcf\data\AbstractDatabaseObjectAction->create(…)
/mnt/------/a3/39/---------/htdocs/core/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\smiley\SmileyAction->create(…)
/mnt/------/a3/39/---------/htdocs/core/lib/acp/form/SmileyAddForm.class.php (201): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/mnt/------/a3/39/---------/htdocs/core/lib/form/AbstractForm.class.php (62): wcf\acp\form\SmileyAddForm->save(…)
/mnt/------/a3/39/---------/htdocs/core/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
/mnt/------/a3/39/---------/htdocs/core/lib/acp/form/SmileyAddForm.class.php (145): wcf\form\AbstractForm->readData(…)
/mnt/------/a3/39/---------/htdocs/core/lib/page/AbstractPage.class.php (291): wcf\acp\form\SmileyAddForm->readData(…)
/mnt/------/a3/39/---------/htdocs/core/lib/page/AbstractPage.class.php (114): wcf\page\AbstractPage->show(…)
/mnt/------/a3/39/---------/htdocs/core/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/mnt/------/a3/39/---------/htdocs/core/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/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

/mnt/------/a3/39/---------/htdocs/core/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
/mnt/------/a3/39/---------/htdocs/core/lib/data/DatabaseObjectEditor.class.php (38): wcf\system\database\statement\PreparedStatement->execute(…)
[internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
/mnt/------/a3/39/---------/htdocs/core/lib/data/AbstractDatabaseObjectAction.class.php (336): call_user_func(…)
/mnt/------/a3/39/---------/htdocs/core/lib/data/smiley/SmileyAction.class.php (47): wcf\data\AbstractDatabaseObjectAction->create(…)
/mnt/------/a3/39/---------/htdocs/core/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\smiley\SmileyAction->create(…)
/mnt/------/a3/39/---------/htdocs/core/lib/acp/form/SmileyAddForm.class.php (201): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/mnt/------/a3/39/---------/htdocs/core/lib/form/AbstractForm.class.php (62): wcf\acp\form\SmileyAddForm->save(…)
/mnt/------/a3/39/---------/htdocs/core/lib/form/AbstractForm.class.php (123): wcf\form\AbstractForm->submit(…)
/mnt/------/a3/39/---------/htdocs/core/lib/acp/form/SmileyAddForm.class.php (145): wcf\form\AbstractForm->readData(…)
/mnt/------/a3/39/---------/htdocs/core/lib/page/AbstractPage.class.php (291): wcf\acp\form\SmileyAddForm->readData(…)
/mnt/------/a3/39/---------/htdocs/core/lib/page/AbstractPage.class.php (114): wcf\page\AbstractPage->show(…)
/mnt/------/a3/39/---------/htdocs/core/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/mnt/------/a3/39/---------/htdocs/core/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/mnt/------/a3/39/---------/htdocs/core/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

Sat, 21 May 2022 23:05:19 +0000
Message: Could not execute statement 'INSERT INTO    wcf1_smiley                     (smileyTitle,smileyCode,aliases,smileyPath,smileyPath2x,showOrder,categoryID,packageID)             VALUES        (?,?,?,?,?,?,?,?)'
PHP version: 7.4.29
WoltLab Suite version: 5.3.22
Request URI: POST /core/acp/index.php?smiley-add/
Referrer: 
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36
Peak Memory Usage: 11331456/536870912
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO    wcf1_smiley                     (smileyTitle,smileyCode,aliases,smileyPath,smileyPath2x,showOrder,categoryID,packageID)             VALUES        (?,?,?,?,?,?,?,?)'
Error Code: 23000
File: /mnt/------/a3/39/---------/htdocs/core/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTo4OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtzOjY6IidIYWhhJyI7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO3M6NDoiJ1hEJyI7fWk6MjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMyI7aToxO3M6NDoiJ1hEJyI7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO3M6MjoiJyciO31pOjQ7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDUiO2k6MTtzOjI6IicnIjt9aTo1O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA2IjtpOjE7aToxNzt9aTo2O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA3IjtpOjE7aToyO31pOjc7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDgiO2k6MTtpOjE7fX0=
Stack Trace: [{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/data\/DatabaseObjectEditor.class.php","line":38,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","file":"[internal function]","line":"?","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","class":"","type":"","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/data\/smiley\/SmileyAction.class.php","line":47,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\\data\\smiley\\SmileyAction","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/acp\/form\/SmileyAddForm.class.php","line":201,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\acp\\form\\SmileyAddForm","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/form\/AbstractForm.class.php","line":123,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/acp\/form\/SmileyAddForm.class.php","line":145,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\acp\\form\\SmileyAddForm","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'XD' for key 'smileyCode'
Error Code: 23000
File: /mnt/------/a3/39/---------/htdocs/core/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/data\/DatabaseObjectEditor.class.php","line":38,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","file":"[internal function]","line":"?","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","class":"","type":"","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/data\/smiley\/SmileyAction.class.php","line":47,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\\data\\smiley\\SmileyAction","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/acp\/form\/SmileyAddForm.class.php","line":201,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/form\/AbstractForm.class.php","line":62,"function":"save","class":"wcf\\acp\\form\\SmileyAddForm","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/form\/AbstractForm.class.php","line":123,"function":"submit","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/acp\/form\/SmileyAddForm.class.php","line":145,"function":"readData","class":"wcf\\form\\AbstractForm","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\acp\\form\\SmileyAddForm","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/mnt\/------\/a3\/39\/---------\/htdocs\/core\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

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

Alexander Ebert May 23, 2022 at 7:09 PM

Alexander Ebert May 23, 2022 at 7:09 PM

Alexander Ebert May 23, 2022 at 7:09 PM

Marcel Werk May 24, 2022 at 6:29 PM

Participate now!

Alexander Ebert May 23, 2022 at 7:09 PM

Alexander Ebert May 23, 2022 at 7:09 PM

Alexander Ebert May 23, 2022 at 7:09 PM

Marcel Werk May 24, 2022 at 6:29 PM

Participate now!

Alexander Ebert May 23, 2022 at 7:09 PM

Alexander Ebert May 23, 2022 at 7:09 PM

Alexander Ebert May 23, 2022 at 7:09 PM

Marcel Werk May 24, 2022 at 6:29 PM