- Affected Version
- WoltLab Suite 5.4
Hallo zusammen,
ich habe heute folgende Fehlermeldung bei mir im Board
Could not execute statement 'INSERT INTO wcf1_user_object_watch (userID,objectID,objectTypeID,notification) VALUES (?,?,?,?)'
QuoteDisplay MoreSat, 08 Jan 2022 21:18:16 +0000
Message: Could not execute statement 'INSERT INTO wcf1_user_object_watch (userID,objectID,objectTypeID,notification) VALUES (?,?,?,?)'
PHP version: 7.4.26
WoltLab Suite version: 5.4.10
Request URI: GET /filebase/index.php?download/3667/
Referrer: https://wasserlasser.com/fileb…-in-canada-2011-12-intro/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 OPR/82.0.4227.43
Peak Memory Usage: 18892736/536870912
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO wcf1_user_object_watch (userID,objectID,objectTypeID,notification) VALUES (?,?,?,?)'
Error Code: 23000
File: /www/htdocs/w00e34a8/community/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YTo0OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjIyNTAxO31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjMwNzI7fWk6MjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMyI7aToxO2k6MzYyO31pOjM7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDQiO2k6MTtpOjE7fX0=
Stack Trace: [{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/data\/TFastCreate.class.php","line":44,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/data\/DatabaseObjectEditor.class.php","line":28,"function":"dboEditorCreateBase","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"userID":"[redacted]","objectID":"[redacted]","objectTypeID":"[redacted]","notification":"[redacted]"}]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/data\/user\/object\/watch\/UserObjectWatchAction.class.php","line":150,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"userID":"[redacted]","objectID":"[redacted]","objectTypeID":"[redacted]","notification":"[redacted]"}]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"subscribe","class":"wcf\\data\\user\\object\\watch\\UserObjectWatchAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/filebase\/lib\/system\/event\/listener\/DownloadPageAutoSubscriptionListener.class.php","line":46,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/system\/event\/EventHandler.class.php","line":161,"function":"execute","class":"filebase\\system\\event\\listener\\DownloadPageAutoSubscriptionListener","type":"->","args":["filebase\\page\\DownloadPage","filebase\\page\\DownloadPage","show",[]]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/system\/event\/EventHandler.class.php","line":204,"function":"executeInheritedActions","class":"wcf\\system\\event\\EventHandler","type":"->","args":["filebase\\page\\DownloadPage","show","filebase\\page\\DownloadPage","show@filebase\\page\\DownloadPage",[]]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/page\/AbstractPage.class.php","line":345,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["filebase\\page\\DownloadPage","show"]},{"file":"\/www\/htdocs\/w00e34a8\/community\/filebase\/lib\/page\/DownloadPage.class.php","line":142,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/page\/AbstractPage.class.php","line":122,"function":"show","class":"filebase\\page\\DownloadPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/filebase\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["filebase"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '362-22501-3072' for key 'objectTypeID'
Error Code: 23000
File: /www/htdocs/w00e34a8/community/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/data\/TFastCreate.class.php","line":44,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/data\/DatabaseObjectEditor.class.php","line":28,"function":"dboEditorCreateBase","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"userID":"[redacted]","objectID":"[redacted]","objectTypeID":"[redacted]","notification":"[redacted]"}]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/data\/user\/object\/watch\/UserObjectWatchAction.class.php","line":150,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"userID":"[redacted]","objectID":"[redacted]","objectTypeID":"[redacted]","notification":"[redacted]"}]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"subscribe","class":"wcf\\data\\user\\object\\watch\\UserObjectWatchAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/filebase\/lib\/system\/event\/listener\/DownloadPageAutoSubscriptionListener.class.php","line":46,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/system\/event\/EventHandler.class.php","line":161,"function":"execute","class":"filebase\\system\\event\\listener\\DownloadPageAutoSubscriptionListener","type":"->","args":["filebase\\page\\DownloadPage","filebase\\page\\DownloadPage","show",[]]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/system\/event\/EventHandler.class.php","line":204,"function":"executeInheritedActions","class":"wcf\\system\\event\\EventHandler","type":"->","args":["filebase\\page\\DownloadPage","show","filebase\\page\\DownloadPage","show@filebase\\page\\DownloadPage",[]]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/page\/AbstractPage.class.php","line":345,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["filebase\\page\\DownloadPage","show"]},{"file":"\/www\/htdocs\/w00e34a8\/community\/filebase\/lib\/page\/DownloadPage.class.php","line":142,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/page\/AbstractPage.class.php","line":122,"function":"show","class":"filebase\\page\\DownloadPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w00e34a8\/community\/filebase\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["filebase"]}]
Woran kann ich erkennen was den Fehler auslöst?
Danke
Wasserlasser