Could not execute statement 'INSERT INTO wcf1_like

  • Affected Version
    WoltLab Suite 5.2

    Hallo,


    Wir bekommen diese Fehlermeldung. Was kann man da tun?


    Requested URL
    /forum/index.php?ajax-proxy/&t=5322a3b505ef1fd1e03c46a4a0b86c121a805b47
    Referrer
    https://www.chaos-linie.de/forum/thread/16-was-denkst-du-gerade/?postID=369051
    Error Message
    Could not execute statement 'INSERT INTO wcf1_like (objectID,objectTypeID,objectUserID,userID,time,likeValue,reactionTypeID) VALUES (?,?,?,?,?,?,?)'
    Type
    wcf\system\database\exception\DatabaseQueryExecutionException
    File (Line)
    /customers/annika/home/chaos-linie.de/lib/system/database/statement/PreparedStatement.class.php (105)
    Query Parameter 1
    369062
    Query Parameter 2
    189
    Query Parameter 3
    2124
    Query Parameter 4
    2070
    Query Parameter 5
    1604773565
    Query Parameter 6
    1
    Query Parameter 7
    3
    Stacktrace
    1. /customers/annika/home/chaos-linie.de/lib/data/DatabaseObjectEditor.class.php (37): wcf\system\database\statement\PreparedStatement->execute(…)
    2. [internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
    3. /customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (337): call_user_func(…)
    4. /customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\AbstractDatabaseObjectAction->create(…)
    5. /customers/annika/home/chaos-linie.de/lib/system/reaction/ReactionHandler.class.php (329): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    6. /customers/annika/home/chaos-linie.de/lib/data/reaction/ReactionAction.class.php (160): wcf\system\reaction\ReactionHandler->react(…)
    7. /customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\reaction\ReactionAction->react(…)
    8. /customers/annika/home/chaos-linie.de/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    9. /customers/annika/home/chaos-linie.de/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)
    10. /customers/annika/home/chaos-linie.de/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)
    11. /customers/annika/home/chaos-linie.de/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
    12. /customers/annika/home/chaos-linie.de/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
    13. /customers/annika/home/chaos-linie.de/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    14. /customers/annika/home/chaos-linie.de/forum/index.php (9): wcf\system\request\RequestHandler->handle(…)
    Error Message
    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '189-369062-2070' for key 'objectTypeID'
    Type
    PDOException
    File (Line)
    /customers/annika/home/chaos-linie.de/lib/system/database/statement/PreparedStatement.class.php (93)
    Stacktrace
    1. /customers/annika/home/chaos-linie.de/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
    2. /customers/annika/home/chaos-linie.de/lib/data/DatabaseObjectEditor.class.php (37): wcf\system\database\statement\PreparedStatement->execute(…)
    3. [internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
    4. /customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (337): call_user_func(…)
    5. /customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\AbstractDatabaseObjectAction->create(…)
    6. /customers/annika/home/chaos-linie.de/lib/system/reaction/ReactionHandler.class.php (329): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    7. /customers/annika/home/chaos-linie.de/lib/data/reaction/ReactionAction.class.php (160): wcf\system\reaction\ReactionHandler->react(…)
    8. /customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\reaction\ReactionAction->react(…)
    9. /customers/annika/home/chaos-linie.de/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    10. /customers/annika/home/chaos-linie.de/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)
    11. /customers/annika/home/chaos-linie.de/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)
    12. /customers/annika/home/chaos-linie.de/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
    13. /customers/annika/home/chaos-linie.de/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
    14. /customers/annika/home/chaos-linie.de/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    15. /customers/annika/home/chaos-linie.de/forum/index.php (9): wcf\system\request\RequestHandler->handle(…)
  • Es kam mal eine ganze Zeit lang diese Fehlermeldung. Zur Zeit nicht mehr. Habe mal die Schlüssel überprüft, es wurden keine Fehler gefunden.


    Danke erstmal für deine Antwort/Hilfe.

  • Hab soeine ähnliche Fehlermeldung auch immer wieder:

    Requested URL
    POST /index.php?ajax-proxy/&t=a8d1184e0c012d619dca787fbf1b33c409c8cf44
    Referrer
    https://domain.tld/thread/13906-rso-%C3%B6l-richtig-herstellen/?postID=350801
    Error Message
    Could not execute statement 'INSERT INTO wcf1_like_object (objectTypeID,objectID,objectUserID,likes,dislikes,cumulativeLikes,cachedReactions) VALUES (?,?,?,?,?,?,?)'
    Type
    wcf\system\database\exception\DatabaseQueryExecutionException
    File (Line)
    /var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (105)
    Query Parameter 1
    302
    Query Parameter 2
    350806
    Query Parameter 3
    4778
    Query Parameter 4
    1
    Query Parameter 5
    0
    Query Parameter 6
    1
    Query Parameter 7
    'a:1:{i:1;i:1;}'
    Stacktrace
    1. /var/www/domain.tld/public/cms/lib/data/DatabaseObjectEditor.class.php (38): wcf\system\database\statement\PreparedStatement->execute(…)
    2. [internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
    3. /var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (336): call_user_func(…)
    4. /var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\AbstractDatabaseObjectAction->create(…)
    5. /var/www/domain.tld/public/cms/lib/system/reaction/ReactionHandler.class.php (464): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    6. /var/www/domain.tld/public/cms/lib/system/reaction/ReactionHandler.class.php (314): wcf\system\reaction\ReactionHandler->updateLikeObject(…)
    7. /var/www/domain.tld/public/cms/lib/data/reaction/ReactionAction.class.php (160): wcf\system\reaction\ReactionHandler->react(…)
    8. /var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\reaction\ReactionAction->react(…)
    9. /var/www/domain.tld/public/cms/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    10. /var/www/domain.tld/public/cms/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)
    11. /var/www/domain.tld/public/cms/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)
    12. /var/www/domain.tld/public/cms/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
    13. /var/www/domain.tld/public/cms/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
    14. /var/www/domain.tld/public/cms/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    15. /var/www/domain.tld/public/index.php (9): wcf\system\request\RequestHandler->handle(…)
    Error Message
    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '302-350806' for key 'objectTypeID'
    Type
    PDOException
    File (Line)
    /var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (93)
    Stacktrace
    1. /var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
    2. /var/www/domain.tld/public/cms/lib/data/DatabaseObjectEditor.class.php (38): wcf\system\database\statement\PreparedStatement->execute(…)
    3. [internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
    4. /var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (336): call_user_func(…)
    5. /var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\AbstractDatabaseObjectAction->create(…)
    6. /var/www/domain.tld/public/cms/lib/system/reaction/ReactionHandler.class.php (464): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    7. /var/www/domain.tld/public/cms/lib/system/reaction/ReactionHandler.class.php (314): wcf\system\reaction\ReactionHandler->updateLikeObject(…)
    8. /var/www/domain.tld/public/cms/lib/data/reaction/ReactionAction.class.php (160): wcf\system\reaction\ReactionHandler->react(…)
    9. /var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\reaction\ReactionAction->react(…)
    10. /var/www/domain.tld/public/cms/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
    11. /var/www/domain.tld/public/cms/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)
    12. /var/www/domain.tld/public/cms/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)
    13. /var/www/domain.tld/public/cms/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
    14. /var/www/domain.tld/public/cms/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
    15. /var/www/domain.tld/public/cms/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    16. /var/www/domain.tld/public/index.php (9): wcf\system\request\RequestHandler->handle(…)

    ┌П┐(◉_◉)┌П┐

  • Ich habe diese Fehlermeldungen auch täglich bei 5.2. Allerdings nicht durchgehend, sondern anscheinend unter speziellen Vorraussetzungen, die ich jedoch nicht eingrenzen kann.


    Mal lautet die Fehlermeldung auf like, mal auf like_object:


    INSERT INTO wcf1_like

    Integrity constraint violation: 1062 Duplicate entry '123-4567890-12345' for key 'objectTypeID'


    INSERT INTO wcf1_like_object

    Integrity constraint violation: 1062 Duplicate entry '123-4567890' for key 'objectTypeID'

    Edited 2 times, last by less ().

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!