Could not execute statement 'INSERT INTO wcf1_like_object (objectTypeID,objectID,objectUserID,likes,dislikes,cumulativeLikes,cachedReactions) VALUES (?,?,?,?,?,?,?)'

ACcafe · February 21, 2021 at 3:50 PM

Was kann diesen Fehler verursacht haben?

Requested URL: POST /forum/index.php?ajax-proxy/&t=9c42c4441834b97d854b082f18cdfade511a3d73

Referrer: https://www.ac-cafe.de/forum/thread/990-tauziehen/?pageNo=715

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): /www/htdocs/v089180/ac-cafe.de/lib/system/database/statement/PreparedStatement.class.php (105)

Query Parameter 1: 301

Query Parameter 2: 144943

Query Parameter 3: 599

Query Parameter 4: 1

Query Parameter 5: 0

Query Parameter 6: 1

Query Parameter 7: 'a:1:{i:1;i:1;}'

Stacktrace

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

Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '301-144943' for key 'objectTypeID'

Type: PDOException

File (Line): /www/htdocs/v089180/ac-cafe.de/lib/system/database/statement/PreparedStatement.class.php (93)

Stacktrace

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

Sat, 20 Feb 2021 15:26:52 +0000
Message: Could not execute statement 'INSERT INTO    wcf1_like_object                     (objectTypeID,objectID,objectUserID,likes,dislikes,cumulativeLikes,cachedReactions)             VALUES        (?,?,?,?,?,?,?)'
PHP version: 7.3.26-nmm1
WoltLab Suite version: 5.3.4
Request URI: POST /forum/index.php?ajax-proxy/&t=9c42c4441834b97d854b082f18cdfade511a3d73
Referrer: https://www.ac-cafe.de/forum/thread/990-tauziehen/?pageNo=715
User Agent: Mozilla/5.0 (Linux; Android 9; SM-G955F) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.93 Mobile Safari/537.36
Peak Memory Usage: 7958024/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: /www/htdocs/v089180/ac-cafe.de/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTo3OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjMwMTt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7aToxNDQ5NDM7fWk6MjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMyI7aToxO2k6NTk5O31pOjM7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDQiO2k6MTtpOjE7fWk6NDthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNSI7aToxO2k6MDt9aTo1O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA2IjtpOjE7aToxO31pOjY7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDciO2k6MTtzOjE2OiInYToxOntpOjE7aToxO30nIjt9fQ==
Stack Trace: [{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/data\/DatabaseObjectEditor.class.php","line":38,"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":[{"objectTypeID":"[redacted]","objectID":"[redacted]","objectUserID":"[redacted]","likes":"[redacted]","dislikes":"[redacted]","cumulativeLikes":"[redacted]","cachedReactions":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"objectTypeID":"[redacted]","objectID":"[redacted]","objectUserID":"[redacted]","likes":"[redacted]","dislikes":"[redacted]","cumulativeLikes":"[redacted]","cachedReactions":"[redacted]"}],"class":"","type":""},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/system\/reaction\/ReactionHandler.class.php","line":464,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/system\/reaction\/ReactionHandler.class.php","line":314,"function":"updateLikeObject","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":["wbb\\data\\post\\LikeablePost","wcf\\data\\like\\object\\LikeObject","wcf\\data\\like\\Like","wcf\\data\\reaction\\type\\ReactionType"]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.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",1]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.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 '301-144943' for key 'objectTypeID'
Error Code: 23000
File: /www/htdocs/v089180/ac-cafe.de/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/data\/DatabaseObjectEditor.class.php","line":38,"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":[{"objectTypeID":"[redacted]","objectID":"[redacted]","objectUserID":"[redacted]","likes":"[redacted]","dislikes":"[redacted]","cumulativeLikes":"[redacted]","cachedReactions":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"objectTypeID":"[redacted]","objectID":"[redacted]","objectUserID":"[redacted]","likes":"[redacted]","dislikes":"[redacted]","cumulativeLikes":"[redacted]","cachedReactions":"[redacted]"}],"class":"","type":""},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/system\/reaction\/ReactionHandler.class.php","line":464,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/system\/reaction\/ReactionHandler.class.php","line":314,"function":"updateLikeObject","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":["wbb\\data\\post\\LikeablePost","wcf\\data\\like\\object\\LikeObject","wcf\\data\\like\\Like","wcf\\data\\reaction\\type\\ReactionType"]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.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",1]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/v089180\/ac-cafe.de\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wbb"]}]

norse · February 21, 2021 at 3:57 PM

Der Fehler wurde bereits für die Vorgängerversion gemeldet, allerdings bisher nicht gelabelt:

Could not execute statement INSERT INTO wcf1_like / wcf1_like_object

Gruß norse

ACcafe · February 21, 2021 at 6:04 PM

Dazu muss ich als Zusatzinfo noch sagen, dass wir mehrere Reaktionen haben, insgesamt 8

SoftCreatR · February 21, 2021 at 6:08 PM

Das ist irrelevant. Den Fehler kannst du dir so vorstellen, dass jemand auf etwas reagiert und diese Reaktion 2x gleichzeitig in die Datenbank geschrieben werden soll.

Could not execute statement 'INSERT INTO wcf1_like_object (objectTypeID,objectID,objectUserID,likes,dislikes,cumulativeLikes,cachedReactions) VALUES (?,?,?,?,?,?,?)'

Participate now!

Similar Threads

Could not execute statement 'INSERT INTO wcf1_like

Benötige Hilfe um Fehlermeldungen zu identifizieren

[SEARCH] Could not execute statement