Could not execute statement 'INSERT INTO wcf1_like

ZeroGravity · Nov 8th 2020

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

/customers/annika/home/chaos-linie.de/lib/data/DatabaseObjectEditor.class.php (37): wcf\system\database\statement\PreparedStatement->execute(…)
[internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
/customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (337): call_user_func(…)
/customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\AbstractDatabaseObjectAction->create(…)
/customers/annika/home/chaos-linie.de/lib/system/reaction/ReactionHandler.class.php (329): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/customers/annika/home/chaos-linie.de/lib/data/reaction/ReactionAction.class.php (160): wcf\system\reaction\ReactionHandler->react(…)
/customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\reaction\ReactionAction->react(…)
/customers/annika/home/chaos-linie.de/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/customers/annika/home/chaos-linie.de/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)
/customers/annika/home/chaos-linie.de/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)
/customers/annika/home/chaos-linie.de/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
/customers/annika/home/chaos-linie.de/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
/customers/annika/home/chaos-linie.de/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/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

/customers/annika/home/chaos-linie.de/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
/customers/annika/home/chaos-linie.de/lib/data/DatabaseObjectEditor.class.php (37): wcf\system\database\statement\PreparedStatement->execute(…)
[internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
/customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (337): call_user_func(…)
/customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\AbstractDatabaseObjectAction->create(…)
/customers/annika/home/chaos-linie.de/lib/system/reaction/ReactionHandler.class.php (329): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/customers/annika/home/chaos-linie.de/lib/data/reaction/ReactionAction.class.php (160): wcf\system\reaction\ReactionHandler->react(…)
/customers/annika/home/chaos-linie.de/lib/data/AbstractDatabaseObjectAction.class.php (205): wcf\data\reaction\ReactionAction->react(…)
/customers/annika/home/chaos-linie.de/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/customers/annika/home/chaos-linie.de/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)
/customers/annika/home/chaos-linie.de/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)
/customers/annika/home/chaos-linie.de/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
/customers/annika/home/chaos-linie.de/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
/customers/annika/home/chaos-linie.de/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/customers/annika/home/chaos-linie.de/forum/index.php (9): wcf\system\request\RequestHandler->handle(…)

Sat, 07 Nov 2020 18:26:05 +0000
Message: Could not execute statement 'INSERT INTO    wcf1_like
                     (objectID,objectTypeID,objectUserID,userID,time,likeValue,reactionTypeID)
             VALUES        (?,?,?,?,?,?,?)'
PHP version: 7.3.19-1~deb10u1
WoltLab Suite version: 5.2.9
Request URI: /forum/index.php?ajax-proxy/&t=5322a3b505ef1fd1e03c46a4a0b86c121a805b47
Referrer: https://www.chaos-linie.de/forum/thread/16-was-denkst-du-gerade/?postID=369051
User Agent: Mozilla/5.0 (Linux; Android 10; SM-T510 Build/QP1A.190711.020) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.128 Safari/537.36 (Ecosia android@69.0.3497.128)
Peak Memory Usage: 9875288/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO    wcf1_like
                     (objectID,objectTypeID,objectUserID,userID,time,likeValue,reactionTypeID)
             VALUES        (?,?,?,?,?,?,?)'
Error Code: 23000
File: /customers/annika/home/chaos-linie.de/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTo3OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjM2OTA2Mjt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7aToxODk7fWk6MjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMyI7aToxO2k6MjEyNDt9aTozO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA0IjtpOjE7aToyMDcwO31pOjQ7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDUiO2k6MTtpOjE2MDQ3NzM1NjU7fWk6NTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNiI7aToxO2k6MTt9aTo2O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA3IjtpOjE7aTozO319
Stack Trace: [{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/data\/DatabaseObjectEditor.class.php","line":37,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":337,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"class":"","type":""},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/system\/reaction\/ReactionHandler.class.php","line":329,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/data\/reaction\/ReactionAction.class.php","line":160,"function":"react","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":["wbb\\data\\post\\LikeablePost","wcf\\data\\user\\User",3]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wbb"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '189-369062-2070' for key 'objectTypeID'
Error Code: 23000
File: /customers/annika/home/chaos-linie.de/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/data\/DatabaseObjectEditor.class.php","line":37,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":337,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"class":"","type":""},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/system\/reaction\/ReactionHandler.class.php","line":329,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/data\/reaction\/ReactionAction.class.php","line":160,"function":"react","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":["wbb\\data\\post\\LikeablePost","wcf\\data\\user\\User",3]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/customers\/annika\/home\/chaos-linie.de\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wbb"]}]

SoftCreatR · Nov 9th 2020

Passiert das immer? Falls ja, vielleicht Mal die FKs prüfen, z.B. damit: https://shop.softcreatr.com/product/6-foreign-key-check/

ZeroGravity · Nov 10th 2020

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.

ZeroGravity · Nov 16th 2020

Also heute hat es die Fehlermeldung nur so gehagelt im Forum. Ich glaube 15 Meldungen waren es heute.

TeRRible__KHONS · Dec 8th 2020

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

/var/www/domain.tld/public/cms/lib/data/DatabaseObjectEditor.class.php (38): wcf\system\database\statement\PreparedStatement->execute(…)
[internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (336): call_user_func(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\AbstractDatabaseObjectAction->create(…)
/var/www/domain.tld/public/cms/lib/system/reaction/ReactionHandler.class.php (464): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/domain.tld/public/cms/lib/system/reaction/ReactionHandler.class.php (314): wcf\system\reaction\ReactionHandler->updateLikeObject(…)
/var/www/domain.tld/public/cms/lib/data/reaction/ReactionAction.class.php (160): wcf\system\reaction\ReactionHandler->react(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\reaction\ReactionAction->react(…)
/var/www/domain.tld/public/cms/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/domain.tld/public/cms/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)
/var/www/domain.tld/public/cms/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)
/var/www/domain.tld/public/cms/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
/var/www/domain.tld/public/cms/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
/var/www/domain.tld/public/cms/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/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

/var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
/var/www/domain.tld/public/cms/lib/data/DatabaseObjectEditor.class.php (38): wcf\system\database\statement\PreparedStatement->execute(…)
[internal function] (?): wcf\data\DatabaseObjectEditor::create(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (336): call_user_func(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\AbstractDatabaseObjectAction->create(…)
/var/www/domain.tld/public/cms/lib/system/reaction/ReactionHandler.class.php (464): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/domain.tld/public/cms/lib/system/reaction/ReactionHandler.class.php (314): wcf\system\reaction\ReactionHandler->updateLikeObject(…)
/var/www/domain.tld/public/cms/lib/data/reaction/ReactionAction.class.php (160): wcf\system\reaction\ReactionHandler->react(…)
/var/www/domain.tld/public/cms/lib/data/AbstractDatabaseObjectAction.class.php (204): wcf\data\reaction\ReactionAction->react(…)
/var/www/domain.tld/public/cms/lib/action/AJAXProxyAction.class.php (75): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/var/www/domain.tld/public/cms/lib/action/AJAXInvokeAction.class.php (94): wcf\action\AJAXProxyAction->invoke(…)
/var/www/domain.tld/public/cms/lib/action/AbstractAction.class.php (47): wcf\action\AJAXInvokeAction->execute(…)
/var/www/domain.tld/public/cms/lib/action/AJAXInvokeAction.class.php (61): wcf\action\AbstractAction->__run(…)
/var/www/domain.tld/public/cms/lib/system/request/Request.class.php (83): wcf\action\AJAXInvokeAction->__run(…)
/var/www/domain.tld/public/cms/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/domain.tld/public/index.php (9): wcf\system\request\RequestHandler->handle(…)

Mon, 07 Dec 2020 22:03:23 +0000
Message: Could not execute statement 'INSERT INTO    wcf1_like_object                     (objectTypeID,objectID,objectUserID,likes,dislikes,cumulativeLikes,cachedReactions)             VALUES        (?,?,?,?,?,?,?)'
PHP version: 7.4.13
WoltLab Suite version: 5.3.1
Request URI: POST /index.php?ajax-proxy/&t=a8d1184e0c012d619dca787fbf1b33c409c8cf44
Referrer: https://domain.tld/thread/13906-rso-%C3%B6l-richtig-herstellen/?postID=350801
User Agent: Mozilla/5.0 (Linux; Android 10; SM-G960F) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.127 Mobile Safari/537.36 OPR/60.3.3004.55692
Peak Memory Usage: 3842056/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO    wcf1_like_object                     (objectTypeID,objectID,objectUserID,likes,dislikes,cumulativeLikes,cachedReactions)             VALUES        (?,?,?,?,?,?,?)'
Error Code: 23000
File: /var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTo3OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjMwMjt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7aTozNTA4MDY7fWk6MjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMyI7aToxO2k6NDc3ODt9aTozO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA0IjtpOjE7aToxO31pOjQ7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDUiO2k6MTtpOjA7fWk6NTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNiI7aToxO2k6MTt9aTo2O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA3IjtpOjE7czoxNjoiJ2E6MTp7aToxO2k6MTt9JyI7fX0=
Stack Trace: [{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/DatabaseObjectEditor.class.php","line":38,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","file":"[internal function]","line":"?","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","class":"","type":"","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/reaction\/ReactionHandler.class.php","line":464,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/reaction\/ReactionHandler.class.php","line":314,"function":"updateLikeObject","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/reaction\/ReactionAction.class.php","line":160,"function":"react","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '302-350806' for key 'objectTypeID'
Error Code: 23000
File: /var/www/domain.tld/public/cms/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/DatabaseObjectEditor.class.php","line":38,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","file":"[internal function]","line":"?","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","class":"","type":"","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/reaction\/ReactionHandler.class.php","line":464,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/reaction\/ReactionHandler.class.php","line":314,"function":"updateLikeObject","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/reaction\/ReactionAction.class.php","line":160,"function":"react","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/cms\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/domain.tld\/public\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

less · Dec 16th 2020

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'

Could not execute statement 'INSERT INTO wcf1_like

Participate now!

Share

Similar Threads

Fehlermeldung: Could not execute statement 'INSERT INTO wcf1_like (objectID,objectTypeID,objectUserID,userID,time,likeValue,reactionTypeID) VALUES (?,?,?,?,?,?,?)'

Could not execute statement 'INSERT INTO wcf1_visitor_daily (date, counter, isRegistered) SELECT…

Could not execute statement 'INSERT INTO wcf1_clipboard_item (objectTypeID, userID, objectID) VALUES (?, ?, ?)'

Could not execute statement

Users Viewing This Thread