Fehler bei bestimmtem Hashtag

  • Folgender Hashtag verursacht bei uns einen Fehler: #KrazyWordz

    Beim Erstellen des Beitrags und absenden gibt es keine Probleme. Allerdings wird der Hashtag nicht umgewandelt. Beim Zitieren oder Editieren des Beitrags wird dann aber beim Absenden folgender Fehler geworfen:

    Datum
    26. Oktober 2020 um 07:54
    Aufgerufene URL
    /wbb4/forum/index.php?ajax-proxy/&t=75ae8633d06fbbdd2e028041e894c8ec0b292fc4
    Referrer
    https://www.unknowns.de/wbb4/forum/index.php?thread/17276-forum-wirft-exceptions-beim-senden-und-l%C3%B6schen-von-beitr%C3%A4gen/&postID=476830
    Browser
    Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0 Safari/605.1.15
    Arbeitsspeicher
    13,75 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)
    /homepages/37/d247992905/htdocs/wbb4/lib/system/database/statement/PreparedStatement.class.php (105)
    Query Parameter 1
    17276
    Query Parameter 2
    2273
    Query Parameter 3
    225
    Query Parameter 4
    1
    Stacktrace
    1. /homepages/37/d247992905/htdocs/wbb4/lib/system/tagging/TagEngine.class.php (86): wcf\system\database\statement\PreparedStatement->execute(…)
    2. /homepages/37/d247992905/htdocs/wbb4/lib/util/HashtagsUtil.class.php (228): wcf\system\tagging\TagEngine->addObjectTags(…)
    3. /homepages/37/d247992905/htdocs/wbb4/forum/lib/system/event/listener/HashtagsPostActionListener.class.php (28): wcf\util\HashtagsUtil::addFromText(…)
    4. /homepages/37/d247992905/htdocs/wbb4/lib/system/event/EventHandler.class.php (221): wbb\system\event\listener\HashtagsPostActionListener->execute(…)
    5. /homepages/37/d247992905/htdocs/wbb4/lib/data/AbstractDatabaseObjectAction.class.php (213): wcf\system\event\EventHandler->fireAction(…)
    6. /homepages/37/d247992905/htdocs/wbb4/forum/lib/data/post/PostAction.class.php (2592): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    7. /homepages/37/d247992905/htdocs/wbb4/lib/data/AbstractDatabaseObjectAction.class.php (205): wbb\data\post\PostAction->save(…)
    8. /homepages/37/d247992905/htdocs/wbb4/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    9. /homepages/37/d247992905/htdocs/wbb4/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)
    10. /homepages/37/d247992905/htdocs/wbb4/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)
    11. /homepages/37/d247992905/htdocs/wbb4/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
    12. /homepages/37/d247992905/htdocs/wbb4/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
    13. /homepages/37/d247992905/htdocs/wbb4/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    14. /homepages/37/d247992905/htdocs/wbb4/forum/index.php (9): wcf\system\request\RequestHandler->handle(…)
    Fehlermeldung
    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '225-1-17276-2273' for key 'objectTypeID'
    Art
    PDOException
    Datei (Zeile)
    /homepages/37/d247992905/htdocs/wbb4/lib/system/database/statement/PreparedStatement.class.php (93)
    Stacktrace
    1. /homepages/37/d247992905/htdocs/wbb4/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
    2. /homepages/37/d247992905/htdocs/wbb4/lib/system/tagging/TagEngine.class.php (86): wcf\system\database\statement\PreparedStatement->execute(…)
    3. /homepages/37/d247992905/htdocs/wbb4/lib/util/HashtagsUtil.class.php (228): wcf\system\tagging\TagEngine->addObjectTags(…)
    4. /homepages/37/d247992905/htdocs/wbb4/forum/lib/system/event/listener/HashtagsPostActionListener.class.php (28): wcf\util\HashtagsUtil::addFromText(…)
    5. /homepages/37/d247992905/htdocs/wbb4/lib/system/event/EventHandler.class.php (221): wbb\system\event\listener\HashtagsPostActionListener->execute(…)
    6. /homepages/37/d247992905/htdocs/wbb4/lib/data/AbstractDatabaseObjectAction.class.php (213): wcf\system\event\EventHandler->fireAction(…)
    7. /homepages/37/d247992905/htdocs/wbb4/forum/lib/data/post/PostAction.class.php (2592): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    8. /homepages/37/d247992905/htdocs/wbb4/lib/data/AbstractDatabaseObjectAction.class.php (205): wbb\data\post\PostAction->save(…)
    9. /homepages/37/d247992905/htdocs/wbb4/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    10. /homepages/37/d247992905/htdocs/wbb4/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)
    11. /homepages/37/d247992905/htdocs/wbb4/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)
    12. /homepages/37/d247992905/htdocs/wbb4/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
    13. /homepages/37/d247992905/htdocs/wbb4/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
    14. /homepages/37/d247992905/htdocs/wbb4/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    15. /homepages/37/d247992905/htdocs/wbb4/forum/index.php (9): wcf\system\request\RequestHandler->handle(…)

    Woran kann das liegen?

    Sonst funktionieren alle anderen Hashtags bisher problemlos.

  • unknowns.de 26. Oktober 2020 um 09:20

    Hat den Titel des Themas von „Fehler bei bestimmten Hashtag“ zu „Fehler bei bestimmtem Hashtag“ geändert.
  • Wie hast Du herausgefunden, welcher Hashtag das Problem ist?

    Ich habe denselben Fehler, weiss aber nicht welcher Hashtag dies verursacht:

    Datum
    28. Dezember 2020 um 21:38
    Aufgerufene URL
    POST /acp/index.php?worker-proxy/&t=b74a4539e8cb98272c9a071a204ca9f9b81f9cf2
    Referrer
    https://www.spirit.jetzt/acp/index.php?rebuild-data/
    Browser
    Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 OPR/73.0.3856.284
    Arbeitsspeicher
    7,37 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)
    /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/database/statement/PreparedStatement.class.php (105)
    Query Parameter 1
    71622
    Query Parameter 2
    6648
    Query Parameter 3
    203
    Query Parameter 4
    1
    Stacktrace
    1. /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/tagging/TagEngine.class.php (87): wcf\system\database\statement\PreparedStatement->execute(…)
    2. /var/www/vhosts/spirit.jetzt/httpdocs/lib/util/HashtagsUtil.class.php (228): wcf\system\tagging\TagEngine->addObjectTags(…)
    3. /var/www/vhosts/spirit.jetzt/httpdocs/forum/lib/system/event/listener/HashtagsPostActionListener.class.php (35): wcf\util\HashtagsUtil::addFromText(…)
    4. /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/event/EventHandler.class.php (221): wbb\system\event\listener\HashtagsPostActionListener->execute(…)
    5. /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/worker/AbstractRebuildDataWorker.class.php (80): wcf\system\event\EventHandler->fireAction(…)
    6. /var/www/vhosts/spirit.jetzt/httpdocs/forum/lib/system/worker/PostRebuildDataWorker.class.php (70): wcf\system\worker\AbstractRebuildDataWorker->execute(…)
    7. /var/www/vhosts/spirit.jetzt/httpdocs/lib/acp/action/WorkerProxyAction.class.php (92): wbb\system\worker\PostRebuildDataWorker->execute(…)
    8. /var/www/vhosts/spirit.jetzt/httpdocs/lib/action/AbstractAction.class.php (47): wcf\acp\action\WorkerProxyAction->execute(…)
    9. /var/www/vhosts/spirit.jetzt/httpdocs/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
    10. /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
    11. /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    12. /var/www/vhosts/spirit.jetzt/httpdocs/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)
    Fehlermeldung
    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '203-1-71622-6648' for key 'objectTypeID'
    Art
    PDOException
    Datei (Zeile)
    /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/database/statement/PreparedStatement.class.php (93)
    Stacktrace
    1. /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
    2. /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/tagging/TagEngine.class.php (87): wcf\system\database\statement\PreparedStatement->execute(…)
    3. /var/www/vhosts/spirit.jetzt/httpdocs/lib/util/HashtagsUtil.class.php (228): wcf\system\tagging\TagEngine->addObjectTags(…)
    4. /var/www/vhosts/spirit.jetzt/httpdocs/forum/lib/system/event/listener/HashtagsPostActionListener.class.php (35): wcf\util\HashtagsUtil::addFromText(…)
    5. /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/event/EventHandler.class.php (221): wbb\system\event\listener\HashtagsPostActionListener->execute(…)
    6. /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/worker/AbstractRebuildDataWorker.class.php (80): wcf\system\event\EventHandler->fireAction(…)
    7. /var/www/vhosts/spirit.jetzt/httpdocs/forum/lib/system/worker/PostRebuildDataWorker.class.php (70): wcf\system\worker\AbstractRebuildDataWorker->execute(…)
    8. /var/www/vhosts/spirit.jetzt/httpdocs/lib/acp/action/WorkerProxyAction.class.php (92): wbb\system\worker\PostRebuildDataWorker->execute(…)
    9. /var/www/vhosts/spirit.jetzt/httpdocs/lib/action/AbstractAction.class.php (47): wcf\acp\action\WorkerProxyAction->execute(…)
    10. /var/www/vhosts/spirit.jetzt/httpdocs/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
    11. /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
    12. /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    13. /var/www/vhosts/spirit.jetzt/httpdocs/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)