Beiträge aktualisieren schlägt fehlt

Dragosius · December 16, 2022 at 2:24 PM

Hallo,

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

Time: December 16, 2022 at 2:11 PM

Requested URL: 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

Memory: 6.29 MiB / 256 MiB

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

Type: wcf\system\database\exception\DatabaseQueryExecutionException

File (Line): /.../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":[]}]

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

Type: PDOException

File (Line): /.../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 · December 16, 2022 at 6:47 PM Official Post

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 · December 17, 2022 at 8:42 AM

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 June 9, 2024 at 9:01 PM

Peter June 9, 2024 at 9:01 PM

Users Viewing This Thread

Peter June 9, 2024 at 9:01 PM

Peter June 9, 2024 at 9:01 PM

Users Viewing This Thread

Peter June 9, 2024 at 9:01 PM

Peter June 9, 2024 at 9:01 PM