Hashtag Fehler beim Bearbeiten und Abschicken eines Beitrags

unknowns.de

Code

Sat, 23 Nov 2024 16:05:08 +0000
Message: Could not execute statement 'INSERT INTO wcf1_tag_to_object                             (objectID, tagID, objectTypeID, languageID)                 VALUES      (?, ?, ?, ?)'
PHP version: 8.2.25
WoltLab Suite version: 6.0.18
Request URI: POST /index.php?ajax-proxy/&t=6a268b191af801a1d69471f16e04f163da9257250654ca28091d3afdbc1d88ad-HM+wPYyxRuVuIPkHsl29Kg==
Referrer: https://unknowns.de/forum/thread/9689-solo-alleinespielen-die-ca-zehnte/?postID=tel:1235572
User Agent: Mozilla/5.0 (iPhone; CPU iPhone OS 17_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.6 Mobile/15E148 Safari/604.1
Peak Memory Usage: tel:6412568134217728
======
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: /usr/www/users/speter/lib/system/database/statement/PreparedStatement.class.php (143)
Extra Information: YTo0OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjk2ODk7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO2k6NTE3O31pOjI7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDMiO2k6MTtpOjIyNTt9aTozO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA0IjtpOjE7aToxO319
Stack Trace: [{"file":"\/usr\/www\/users\/speter\/lib\/system\/tagging\/TagEngine.class.php","line":100,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/usr\/www\/users\/speter\/lib\/util\/HashtagsUtil.class.php","line":228,"function":"addObjectTags","class":"wcf\\system\\tagging\\TagEngine","type":"->","args":["com.woltlab.wbb.thread",9689,["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],1,false]},{"file":"\/usr\/www\/users\/speter\/forum\/lib\/system\/event\/listener\/HashtagsPostActionListener.class.php","line":33,"function":"addFromText","class":"wcf\\util\\HashtagsUtil","type":"::","args":["wcf\\system\\html\\input\\HtmlInputProcessor","com.woltlab.wbb.thread",9689,1]},{"file":"\/usr\/www\/users\/speter\/lib\/system\/event\/listener\/AbstractEventListener.class.php","line":58,"function":"onFinalizeAction","class":"wbb\\system\\event\\listener\\HashtagsPostActionListener","type":"->","args":["wbb\\data\\post\\PostAction",[]]},{"file":"\/usr\/www\/users\/speter\/lib\/system\/event\/EventHandler.class.php","line":162,"function":"execute","class":"wcf\\system\\event\\listener\\AbstractEventListener","type":"->","args":["wbb\\data\\post\\PostAction","wbb\\data\\post\\PostAction","finalizeAction",[]]},{"file":"\/usr\/www\/users\/speter\/lib\/system\/event\/EventHandler.class.php","line":226,"function":"executeListeners","class":"wcf\\system\\event\\EventHandler","type":"->","args":[{"wbb\\system\\event\\listener\\HashtagsPostActionListener":"[redacted]","wbb\\system\\event\\listener\\UzbotPostActionListener":"[redacted]","wbb\\system\\event\\listener\\WbbPostAivorEventListener":"[redacted]"},"wbb\\data\\post\\PostAction","wbb\\data\\post\\PostAction","finalizeAction",[]]},{"file":"\/usr\/www\/users\/speter\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":223,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wbb\\data\\post\\PostAction","finalizeAction"]},{"file":"\/usr\/www\/users\/speter\/forum\/lib\/data\/post\/PostAction.class.php","line":2895,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":215,"function":"save","class":"wbb\\data\\post\\PostAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/action\/AJAXInvokeAction.class.php","line":110,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/action\/AbstractAction.class.php","line":56,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/action\/AJAXInvokeAction.class.php","line":64,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/system\/request\/Request.class.php","line":57,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/usr\/www\/users\/speter\/lib\/system\/request\/RequestHandler.class.php","line":147,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/usr\/www\/users\/speter\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'tel:2259689517' for key 'PRIMARY'
Error Code: 23000
File: /usr/www/users/speter/lib/system/database/statement/PreparedStatement.class.php (125)
Extra Information: -
Stack Trace: [{"file":"\/usr\/www\/users\/speter\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":125,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/usr\/www\/users\/speter\/lib\/system\/tagging\/TagEngine.class.php","line":100,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/usr\/www\/users\/speter\/lib\/util\/HashtagsUtil.class.php","line":228,"function":"addObjectTags","class":"wcf\\system\\tagging\\TagEngine","type":"->","args":["com.woltlab.wbb.thread",9689,["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],1,false]},{"file":"\/usr\/www\/users\/speter\/forum\/lib\/system\/event\/listener\/HashtagsPostActionListener.class.php","line":33,"function":"addFromText","class":"wcf\\util\\HashtagsUtil","type":"::","args":["wcf\\system\\html\\input\\HtmlInputProcessor","com.woltlab.wbb.thread",9689,1]},{"file":"\/usr\/www\/users\/speter\/lib\/system\/event\/listener\/AbstractEventListener.class.php","line":58,"function":"onFinalizeAction","class":"wbb\\system\\event\\listener\\HashtagsPostActionListener","type":"->","args":["wbb\\data\\post\\PostAction",[]]},{"file":"\/usr\/www\/users\/speter\/lib\/system\/event\/EventHandler.class.php","line":162,"function":"execute","class":"wcf\\system\\event\\listener\\AbstractEventListener","type":"->","args":["wbb\\data\\post\\PostAction","wbb\\data\\post\\PostAction","finalizeAction",[]]},{"file":"\/usr\/www\/users\/speter\/lib\/system\/event\/EventHandler.class.php","line":226,"function":"executeListeners","class":"wcf\\system\\event\\EventHandler","type":"->","args":[{"wbb\\system\\event\\listener\\HashtagsPostActionListener":"[redacted]","wbb\\system\\event\\listener\\UzbotPostActionListener":"[redacted]","wbb\\system\\event\\listener\\WbbPostAivorEventListener":"[redacted]"},"wbb\\data\\post\\PostAction","wbb\\data\\post\\PostAction","finalizeAction",[]]},{"file":"\/usr\/www\/users\/speter\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":223,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":["wbb\\data\\post\\PostAction","finalizeAction"]},{"file":"\/usr\/www\/users\/speter\/forum\/lib\/data\/post\/PostAction.class.php","line":2895,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":215,"function":"save","class":"wbb\\data\\post\\PostAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/action\/AJAXInvokeAction.class.php","line":110,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/action\/AbstractAction.class.php","line":56,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/action\/AJAXInvokeAction.class.php","line":64,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/system\/request\/Request.class.php","line":57,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/usr\/www\/users\/speter\/lib\/http\/middleware\/HandleValinorMappingErrors.class.php","line":35,"function":"handle","class":"wcf\\system\\request\\Request","type":"->","args":["Laminas\\Diactoros\\ServerRequest"]},{"file":"\/usr\/www\/users\/speter\/lib\/system\/request\/RequestHandler.class.php","line":147,"function":"process","class":"wcf\\http\\Pipeline","type":"->","args":["Laminas\\Diactoros\\ServerRequest","wcf\\http\\RequestHandlerMiddleware"]},{"file":"\/usr\/www\/users\/speter\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

Alles anzeigen

Was könnte das sein und wie kann man es beheben?

Hier noch der Link zum Beitrag:

https://unknowns.de/forum/thread/9…572#post1235572

Peter

Kann ich mir das Debuggen? Es gab den Fehler schon öfters, war aber nie reproduzierbar.

Anfrage für Zugangsdaten

Um Ihnen bei Ihrem Problem weiterhelfen zu können, benötigen wir Zugriff auf Ihre Installation. Die Zugangsdaten werden asymmetrisch verschlüsselt gespeichert und können nun von uns eingesehen werden. Die Zugangsdaten werden nach der Bearbeitung unverzüglich gelöscht.

Es werden für die Behebung des Problems keine weiteren Zugangsdaten benötigt.

Peter

Das hinterlegte Konto ist gesperrt.

unknowns.de

Jetzt nicht mehr. Sorry.

Peter

Ich habe den Fehler gefunden. Für den Hashtag DieGlasstraße gibt es das Synonym Glasstraße. Das hat das Problem verursacht. Gleichzeitig gab es einen weiteren Fehler in Verbindung mit dem Umlaut. Beide Probleme konnte ich beheben.

P.S: Übrigens ist es super nervig, wenn du mir die Rechte im ACP unnötig beschneidest. Es hat einen Grund, warum ich Zugang zum ACP gefordert habe. Die Verwaltung der Tags hätte mir hier z.B. stark geholfen und ich müsste es nicht direkt über die Datenbank machen. Diese Analysen sind mit unter sehr zeitintensiv und da wäre es angenehm, wenn man nicht extra noch mehr Zeit versenken müsste. Es wäre in Zukunft besser, wenn du den Zugang nicht künstlich limitierst.

unknowns.de

Erst einmal danke.

Ich habe den Admin vor Jahren angelegt und nichts bewusst extra eingeschränkt. Sorry. Bitte einfach Bescheid geben, wenn Rechte fehlen.

Hashtag Fehler beim Bearbeiten und Abschicken eines Beitrags

Anfrage für Zugangsdaten

Peter 24. November 2024 um 17:48

Peter 24. November 2024 um 17:49