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:

    Time
    October 26, 2020 at 7:54 AM
    Requested 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
    User Agent
    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
    Memory
    13.75 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)
    /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(…)
    Error Message
    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '225-1-17276-2273' for key 'objectTypeID'
    Type
    PDOException
    File (Line)
    /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.

    Edited once, last by unknowns.de (October 26, 2020 at 9:07 AM).

  • unknowns.de October 26, 2020 at 9:20 AM

    Changed the title of the thread from “Fehler bei bestimmten Hashtag” to “Fehler bei bestimmtem Hashtag”.
  • Wie hast Du herausgefunden, welcher Hashtag das Problem ist?

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

    Time
    December 28, 2020 at 9:38 PM
    Requested URL
    POST /acp/index.php?worker-proxy/&t=b74a4539e8cb98272c9a071a204ca9f9b81f9cf2
    Referrer
    https://www.spirit.jetzt/acp/index.php?rebuild-data/
    User Agent
    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
    Memory
    7.37 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)
    /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(…)
    Error Message
    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '203-1-71622-6648' for key 'objectTypeID'
    Type
    PDOException
    File (Line)
    /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(…)

    Eisu | Gründer & Entwickler von Spirit.Jetzt
    Meine Mission: Werkzeuge schaffen, die Menschen verbinden.

  • TagID geht bei mir nur bis 7026, dennoch lieferte Dein Hinweis die Lösung:

    Code
    Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '203-1-71622-6648' for key 'objectTypeID'

    6648 war das Problem #FroheWeihnachten :D

    Eisu | Gründer & Entwickler von Spirit.Jetzt
    Meine Mission: Werkzeuge schaffen, die Menschen verbinden.

    Edited once, last by Eisu (December 28, 2020 at 11:41 PM).