Beiträge aktualisieren schlägt fehlt

Dragosius

Hallo,

wenn ich die Beiträge aktualisieren möchte, schlägt das an einer bestimmten Stelle aus folgendem Grund fehl:

Datum: 16. Dezember 2022 um 14:11

Aufgerufene URL: POST /acp/index.php?worker-proxy/&t=aab6c07a8963ff7c053c69e5f8cdc8776b6068d4b772b38497e9869230d92d6a-jLX9Wjme3aFlEixzBipaGw==

Referrer: https://www.anime-community.de/acp/index.php?rebuild-data/

Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:108.0) Gecko/20100101 Firefox/108.0

Arbeitsspeicher: 6,29 MiB / 256 MiB

Fehlermeldung: Could not execute statement 'INSERT INTO wcf1_tag_to_object (objectID, tagID, objectTypeID, languageID) VALUES (?, ?, ?, ?)'

Art: wcf\system\database\exception\DatabaseQueryExecutionException

Datei (Zeile): /.../lib/system/database/statement/PreparedStatement.class.php (144)

Query Parameter 1: 12129

Query Parameter 2: 43

Query Parameter 3: 202

Query Parameter 4: 1

Stacktrace

/.../lib/system/tagging/TagEngine.class.php (101): wcf\system\database\statement\PreparedStatement->execute(…)
/.../lib/util/HashtagsUtil.class.php (228): wcf\system\tagging\TagEngine->addObjectTags(…)
/.../forum/lib/system/event/listener/HashtagsPostActionListener.class.php (35): wcf\util\HashtagsUtil::addFromText(…)
/.../lib/system/event/EventHandler.class.php (172): wbb\system\event\listener\HashtagsPostActionListener->execute(…)
/.../lib/system/event/EventHandler.class.php (240): wcf\system\event\EventHandler->executeListeners(…)
/.../lib/system/worker/AbstractRebuildDataWorker.class.php (88): wcf\system\event\EventHandler->fireAction(…)
/.../forum/lib/system/worker/PostRebuildDataWorker.class.php (79): wcf\system\worker\AbstractRebuildDataWorker->execute(…)
/.../lib/acp/action/WorkerProxyAction.class.php (104): wbb\system\worker\PostRebuildDataWorker->execute(…)
/.../lib/action/AbstractAction.class.php (57): wcf\acp\action\WorkerProxyAction->execute(…)
/.../lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/.../lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
/.../lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/.../acp/index.php (11): wcf\system\request\RequestHandler->handle(…)

Fri, 16 Dec 2022 13:11:01 +0000
Message: Could not execute statement 'INSERT INTO wcf1_tag_to_object                             (objectID, tagID, objectTypeID, languageID)                 VALUES      (?, ?, ?, ?)'
PHP version: 8.0.26
WoltLab Suite version: 5.5.7
Request URI: POST /acp/index.php?worker-proxy/&t=aab6c07a8963ff7c053c69e5f8cdc8776b6068d4b772b38497e9869230d92d6a-jLX9Wjme3aFlEixzBipaGw==
Referrer: https://www.anime-community.de/acp/index.php?rebuild-data/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:108.0) Gecko/20100101 Firefox/108.0
Peak Memory Usage: 6592720/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO wcf1_tag_to_object                             (objectID, tagID, objectTypeID, languageID)                 VALUES      (?, ?, ?, ?)'
Error Code: 23000
File: /.../lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YTo0OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjEyMTI5O31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjQzO31pOjI7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDMiO2k6MTtpOjIwMjt9aTozO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA0IjtpOjE7aToxO319
Stack Trace: [{"file":"\/...\/lib\/system\/tagging\/TagEngine.class.php","line":101,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/...\/lib\/util\/HashtagsUtil.class.php","line":228,"function":"addObjectTags","class":"wcf\\system\\tagging\\TagEngine","type":"->","args":[]},{"file":"\/...\/forum\/lib\/system\/event\/listener\/HashtagsPostActionListener.class.php","line":35,"function":"addFromText","class":"wcf\\util\\HashtagsUtil","type":"::","args":[]},{"file":"\/...\/lib\/system\/event\/EventHandler.class.php","line":172,"function":"execute","class":"wbb\\system\\event\\listener\\HashtagsPostActionListener","type":"->","args":[]},{"file":"\/...\/lib\/system\/event\/EventHandler.class.php","line":240,"function":"executeListeners","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/...\/lib\/system\/worker\/AbstractRebuildDataWorker.class.php","line":88,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/...\/forum\/lib\/system\/worker\/PostRebuildDataWorker.class.php","line":79,"function":"execute","class":"wcf\\system\\worker\\AbstractRebuildDataWorker","type":"->","args":[]},{"file":"\/...\/lib\/acp\/action\/WorkerProxyAction.class.php","line":104,"function":"execute","class":"wbb\\system\\worker\\PostRebuildDataWorker","type":"->","args":[]},{"file":"\/...\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\acp\\action\\WorkerProxyAction","type":"->","args":[]},{"file":"\/...\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/...\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/...\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/...\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '202-12129-43' for key 'PRIMARY'
Error Code: 23000
File: /.../lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/...\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/...\/lib\/system\/tagging\/TagEngine.class.php","line":101,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/...\/lib\/util\/HashtagsUtil.class.php","line":228,"function":"addObjectTags","class":"wcf\\system\\tagging\\TagEngine","type":"->","args":[]},{"file":"\/...\/forum\/lib\/system\/event\/listener\/HashtagsPostActionListener.class.php","line":35,"function":"addFromText","class":"wcf\\util\\HashtagsUtil","type":"::","args":[]},{"file":"\/...\/lib\/system\/event\/EventHandler.class.php","line":172,"function":"execute","class":"wbb\\system\\event\\listener\\HashtagsPostActionListener","type":"->","args":[]},{"file":"\/...\/lib\/system\/event\/EventHandler.class.php","line":240,"function":"executeListeners","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/...\/lib\/system\/worker\/AbstractRebuildDataWorker.class.php","line":88,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/...\/forum\/lib\/system\/worker\/PostRebuildDataWorker.class.php","line":79,"function":"execute","class":"wcf\\system\\worker\\AbstractRebuildDataWorker","type":"->","args":[]},{"file":"\/...\/lib\/acp\/action\/WorkerProxyAction.class.php","line":104,"function":"execute","class":"wbb\\system\\worker\\PostRebuildDataWorker","type":"->","args":[]},{"file":"\/...\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\acp\\action\\WorkerProxyAction","type":"->","args":[]},{"file":"\/...\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/...\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/...\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/...\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

Fehlermeldung: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '202-12129-43' for key 'PRIMARY'

Art: PDOException

Datei (Zeile): /.../lib/system/database/statement/PreparedStatement.class.php (126)

Stacktrace

/.../lib/system/database/statement/PreparedStatement.class.php (126): PDOStatement->execute(…)
/.../lib/system/tagging/TagEngine.class.php (101): wcf\system\database\statement\PreparedStatement->execute(…)
/.../lib/util/HashtagsUtil.class.php (228): wcf\system\tagging\TagEngine->addObjectTags(…)
/.../forum/lib/system/event/listener/HashtagsPostActionListener.class.php (35): wcf\util\HashtagsUtil::addFromText(…)
/.../lib/system/event/EventHandler.class.php (172): wbb\system\event\listener\HashtagsPostActionListener->execute(…)
/.../lib/system/event/EventHandler.class.php (240): wcf\system\event\EventHandler->executeListeners(…)
/.../lib/system/worker/AbstractRebuildDataWorker.class.php (88): wcf\system\event\EventHandler->fireAction(…)
/.../forum/lib/system/worker/PostRebuildDataWorker.class.php (79): wcf\system\worker\AbstractRebuildDataWorker->execute(…)
/.../lib/acp/action/WorkerProxyAction.class.php (104): wbb\system\worker\PostRebuildDataWorker->execute(…)
/.../lib/action/AbstractAction.class.php (57): wcf\acp\action\WorkerProxyAction->execute(…)
/.../lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/.../lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
/.../lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/.../acp/index.php (11): wcf\system\request\RequestHandler->handle(…)

Fri, 16 Dec 2022 13:11:01 +0000
Message: Could not execute statement 'INSERT INTO wcf1_tag_to_object                             (objectID, tagID, objectTypeID, languageID)                 VALUES      (?, ?, ?, ?)'
PHP version: 8.0.26
WoltLab Suite version: 5.5.7
Request URI: POST /acp/index.php?worker-proxy/&t=aab6c07a8963ff7c053c69e5f8cdc8776b6068d4b772b38497e9869230d92d6a-jLX9Wjme3aFlEixzBipaGw==
Referrer: https://www.anime-community.de/acp/index.php?rebuild-data/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:108.0) Gecko/20100101 Firefox/108.0
Peak Memory Usage: 6592720/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO wcf1_tag_to_object                             (objectID, tagID, objectTypeID, languageID)                 VALUES      (?, ?, ?, ?)'
Error Code: 23000
File: /.../lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YTo0OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjEyMTI5O31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjQzO31pOjI7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDMiO2k6MTtpOjIwMjt9aTozO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA0IjtpOjE7aToxO319
Stack Trace: [{"file":"\/...\/lib\/system\/tagging\/TagEngine.class.php","line":101,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/...\/lib\/util\/HashtagsUtil.class.php","line":228,"function":"addObjectTags","class":"wcf\\system\\tagging\\TagEngine","type":"->","args":[]},{"file":"\/...\/forum\/lib\/system\/event\/listener\/HashtagsPostActionListener.class.php","line":35,"function":"addFromText","class":"wcf\\util\\HashtagsUtil","type":"::","args":[]},{"file":"\/...\/lib\/system\/event\/EventHandler.class.php","line":172,"function":"execute","class":"wbb\\system\\event\\listener\\HashtagsPostActionListener","type":"->","args":[]},{"file":"\/...\/lib\/system\/event\/EventHandler.class.php","line":240,"function":"executeListeners","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/...\/lib\/system\/worker\/AbstractRebuildDataWorker.class.php","line":88,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/...\/forum\/lib\/system\/worker\/PostRebuildDataWorker.class.php","line":79,"function":"execute","class":"wcf\\system\\worker\\AbstractRebuildDataWorker","type":"->","args":[]},{"file":"\/...\/lib\/acp\/action\/WorkerProxyAction.class.php","line":104,"function":"execute","class":"wbb\\system\\worker\\PostRebuildDataWorker","type":"->","args":[]},{"file":"\/...\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\acp\\action\\WorkerProxyAction","type":"->","args":[]},{"file":"\/...\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/...\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/...\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/...\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '202-12129-43' for key 'PRIMARY'
Error Code: 23000
File: /.../lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/...\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/...\/lib\/system\/tagging\/TagEngine.class.php","line":101,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/...\/lib\/util\/HashtagsUtil.class.php","line":228,"function":"addObjectTags","class":"wcf\\system\\tagging\\TagEngine","type":"->","args":[]},{"file":"\/...\/forum\/lib\/system\/event\/listener\/HashtagsPostActionListener.class.php","line":35,"function":"addFromText","class":"wcf\\util\\HashtagsUtil","type":"::","args":[]},{"file":"\/...\/lib\/system\/event\/EventHandler.class.php","line":172,"function":"execute","class":"wbb\\system\\event\\listener\\HashtagsPostActionListener","type":"->","args":[]},{"file":"\/...\/lib\/system\/event\/EventHandler.class.php","line":240,"function":"executeListeners","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/...\/lib\/system\/worker\/AbstractRebuildDataWorker.class.php","line":88,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/...\/forum\/lib\/system\/worker\/PostRebuildDataWorker.class.php","line":79,"function":"execute","class":"wcf\\system\\worker\\AbstractRebuildDataWorker","type":"->","args":[]},{"file":"\/...\/lib\/acp\/action\/WorkerProxyAction.class.php","line":104,"function":"execute","class":"wbb\\system\\worker\\PostRebuildDataWorker","type":"->","args":[]},{"file":"\/...\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\acp\\action\\WorkerProxyAction","type":"->","args":[]},{"file":"\/...\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/...\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/...\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/...\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

Wie kann ich das mit dem doppelten Eintrag denn beheben?

Danke

Peter

Der Fehler ist zwar schon mehrfach gemeldet worden, aber ich kann ihn selbst nicht reproduzieren bzw. ist bei solchen Fehlersituationen nur mit sehr viel Aufwand zu testen oder beheben. Da es sich hierbei um ein kostenloses Produkt handelt, sind solche sehr zeitintensiven Untersuchungen leider nicht möglich. Es gibt für dieses Problem leider keine Lösung.

Dragosius

Danke für die Rückmeldung.

Somit werde ich zumindest bei mir das Plugin wieder deinstallieren, da es für mich nicht hinnehmbar ist, wenn ich dauerhaft die Beiträge nicht aktualisieren kann. Es tritt dort nämlich jedes Mal auf.

Beiträge aktualisieren schlägt fehlt

Peter 9. Juni 2024 um 21:01

Peter 9. Juni 2024 um 21:01