Hashtag Fehler beim Bearbeiten und Abschicken eines Beitrags

unknowns.de · November 23, 2024 at 5:11 PM

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"]}]

Display More

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 · November 24, 2024 at 8:26 AM Official Post

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

Request for access

To be able to help you with your problem, we need access to your installation. The access data is stored asymmetrically encrypted and can now be viewed by us. The access data will be deleted immediately after processing.

No further credentials is required to solve the problem.

Peter · November 24, 2024 at 3:56 PM Official Post

Das hinterlegte Konto ist gesperrt.

unknowns.de · November 24, 2024 at 4:17 PM

Jetzt nicht mehr. Sorry.

Peter · November 24, 2024 at 5:44 PM Official Post

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 · November 24, 2024 at 6:26 PM

Erst einmal danke.

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

Schangi · November 6, 2025 at 12:10 PM

Hallo zusammen,

ich habe die Hashtag-Erweiterung installiert. (WL 6.1.14) Ein Hashtag wird im Beitrag nicht umgewandelt. Muss ich noch einen Zusatz für das Forum installieren?

Liebe Grüße, Schangi

Peter · November 6, 2025 at 12:16 PM Official Post

Ja, du brauchst auch die Forenerweiterung dafür.

Schangi · November 6, 2025 at 12:25 PM

Ich habe sie bisher leider nicht gefunden. Wo kann ich sie beziehen?

Peter · November 6, 2025 at 1:11 PM Official Post

Ist ein optionales Paket, welches direkt bei der Installation angeboten wird. Ansonsten einfach über Pakete suchen bei der Paketinstallation suchen.

Schangi · November 6, 2025 at 1:28 PM

Es wurde bei der Installation aber nichts abgefragt. Hab hoffentlich nichts falsch gemacht. Muss ich bei der Paketsuche euren Paketserver verbunden haben?

Schangi · November 6, 2025 at 1:30 PM

Die Paketsuche bietet 6.0 an. Geht das auch mit 6.1.14?

Peter · November 6, 2025 at 2:22 PM Official Post

Ja, 6.0 ist die aktuelle Version.

Schangi · November 6, 2025 at 3:40 PM

Ist es möglich, dass die Benachrichtigung in der Box "Letzte Aktivitäten" den Beitrag in "HTML" darstellt?

Peter · November 6, 2025 at 4:33 PM Official Post

Um ehrlich zu sein weiß ich nicht, ob ich hierrauf überhaupt einen Einfluss habe, da ich nur Links erzeuge.

Schangi · November 6, 2025 at 4:56 PM

Eigentlich müsste das ganze so da stehen:

Name hat eine Antwort im ThemaWas machst du gerade? verfasst.

Bei anderen Anwendungen wird in der Regel ja bei Verweisen, die durch eine Anwendung geschrieben wurden, auch das gesamte Ergebnis aufgelöst.

Als Beispiel: Easy Mood

Hier wird ja der Pfad auch "aufgelöst" und nicht als Codezeile dargestellt..

Aber wenn es gar nicht geht, dann ist das so. Ich kann es überhaupt nicht einschätzen.

Es ist nur ein Gedanke alsNutzer und Nichttechniker. 🙈

Hashtag Fehler beim Bearbeiten und Abschicken eines Beitrags

Request for access

Peter November 24, 2024 at 5:48 PM

Peter November 24, 2024 at 5:49 PM

Users Viewing This Thread

Request for access

Peter November 24, 2024 at 5:48 PM

Peter November 24, 2024 at 5:49 PM

Users Viewing This Thread

Peter November 24, 2024 at 5:48 PM

Peter November 24, 2024 at 5:49 PM