Integrity constraint violation: 1062 Duplicate entry '330-58824' for key 'objectTypeID'

Shalin · Feb 6th 2023

Hallo, wir haben heute eine Fehlermeldung bekommen

Requested URL: POST /forum/index.php?ajax-proxy/&t=e3cc38436f19524ff6fa05c1ad5f728b9199d7a2029b7819a0f5e5dc076fcceb-4N7Va4F/BXcnF7C5fmVosQ==

Referrer: https://borderline-forum.eu/forum/thread/1167-burnish-life/?postID=58824

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): /customers/shalin/home/borderline-forum.eu/lib/system/database/statement/PreparedStatement.class.php (144)

Query Parameter 1: 330

Query Parameter 2: 58824

Query Parameter 3: 178

Query Parameter 4: 1

Query Parameter 5: 0

Query Parameter 6: 1

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

Stacktrace

/customers/shalin/home/borderline-forum.eu/lib/data/TFastCreate.class.php (44): wcf\system\database\statement\PreparedStatement->execute(…)
/customers/shalin/home/borderline-forum.eu/lib/data/DatabaseObjectEditor.class.php (28): wcf\data\DatabaseObjectEditor::dboEditorCreateBase(…)
/customers/shalin/home/borderline-forum.eu/lib/data/AbstractDatabaseObjectAction.class.php (355): wcf\data\DatabaseObjectEditor::create(…)
/customers/shalin/home/borderline-forum.eu/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\AbstractDatabaseObjectAction->create(…)
/customers/shalin/home/borderline-forum.eu/lib/system/reaction/ReactionHandler.class.php (510): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/customers/shalin/home/borderline-forum.eu/lib/system/reaction/ReactionHandler.class.php (331): wcf\system\reaction\ReactionHandler->updateLikeObject(…)
/customers/shalin/home/borderline-forum.eu/lib/data/reaction/ReactionAction.class.php (168): wcf\system\reaction\ReactionHandler->react(…)
/customers/shalin/home/borderline-forum.eu/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\reaction\ReactionAction->react(…)
/customers/shalin/home/borderline-forum.eu/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/customers/shalin/home/borderline-forum.eu/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/customers/shalin/home/borderline-forum.eu/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
/customers/shalin/home/borderline-forum.eu/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/customers/shalin/home/borderline-forum.eu/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
/customers/shalin/home/borderline-forum.eu/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/customers/shalin/home/borderline-forum.eu/forum/index.php (11): wcf\system\request\RequestHandler->handle(…)

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

Type: PDOException

File (Line): /customers/shalin/home/borderline-forum.eu/lib/system/database/statement/PreparedStatement.class.php (126)

Stacktrace

/customers/shalin/home/borderline-forum.eu/lib/system/database/statement/PreparedStatement.class.php (126): PDOStatement->execute(…)
/customers/shalin/home/borderline-forum.eu/lib/data/TFastCreate.class.php (44): wcf\system\database\statement\PreparedStatement->execute(…)
/customers/shalin/home/borderline-forum.eu/lib/data/DatabaseObjectEditor.class.php (28): wcf\data\DatabaseObjectEditor::dboEditorCreateBase(…)
/customers/shalin/home/borderline-forum.eu/lib/data/AbstractDatabaseObjectAction.class.php (355): wcf\data\DatabaseObjectEditor::create(…)
/customers/shalin/home/borderline-forum.eu/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\AbstractDatabaseObjectAction->create(…)
/customers/shalin/home/borderline-forum.eu/lib/system/reaction/ReactionHandler.class.php (510): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/customers/shalin/home/borderline-forum.eu/lib/system/reaction/ReactionHandler.class.php (331): wcf\system\reaction\ReactionHandler->updateLikeObject(…)
/customers/shalin/home/borderline-forum.eu/lib/data/reaction/ReactionAction.class.php (168): wcf\system\reaction\ReactionHandler->react(…)
/customers/shalin/home/borderline-forum.eu/lib/data/AbstractDatabaseObjectAction.class.php (216): wcf\data\reaction\ReactionAction->react(…)
/customers/shalin/home/borderline-forum.eu/lib/action/AJAXProxyAction.class.php (92): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/customers/shalin/home/borderline-forum.eu/lib/action/AJAXInvokeAction.class.php (111): wcf\action\AJAXProxyAction->invoke(…)
/customers/shalin/home/borderline-forum.eu/lib/action/AbstractAction.class.php (57): wcf\action\AJAXInvokeAction->execute(…)
/customers/shalin/home/borderline-forum.eu/lib/action/AJAXInvokeAction.class.php (65): wcf\action\AbstractAction->__run(…)
/customers/shalin/home/borderline-forum.eu/lib/system/request/Request.class.php (90): wcf\action\AJAXInvokeAction->__run(…)
/customers/shalin/home/borderline-forum.eu/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/customers/shalin/home/borderline-forum.eu/forum/index.php (11): wcf\system\request\RequestHandler->handle(…)

Mon, 06 Feb 2023 20:37:32 +0000
Message: Could not execute statement 'INSERT INTO wcf1_like_object                             (objectTypeID,objectID,objectUserID,likes,dislikes,cumulativeLikes,cachedReactions)                 VALUES      (?,?,?,?,?,?,?)'
PHP version: 8.0.21
WoltLab Suite version: 5.5.8
Request URI: POST /forum/index.php?ajax-proxy/&t=e3cc38436f19524ff6fa05c1ad5f728b9199d7a2029b7819a0f5e5dc076fcceb-4N7Va4F/BXcnF7C5fmVosQ==
Referrer: https://borderline-forum.eu/forum/thread/1167-burnish-life/?postID=58824
User Agent: Mozilla/5.0 (Linux; Android 13; SM-A528B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Mobile Safari/537.36
Peak Memory Usage: 10867320/536870912
======
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: /customers/shalin/home/borderline-forum.eu/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YTo3OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjMzMDt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7aTo1ODgyNDt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aToxNzg7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO2k6MTt9aTo0O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA1IjtpOjE7aTowO31pOjU7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDYiO2k6MTtpOjE7fWk6NjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNyI7aToxO3M6MTY6IidhOjE6e2k6OTtpOjE7fSciO319
Stack Trace: [{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/TFastCreate.class.php","line":44,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/DatabaseObjectEditor.class.php","line":28,"function":"dboEditorCreateBase","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":355,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/reaction\/ReactionHandler.class.php","line":510,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/reaction\/ReactionHandler.class.php","line":331,"function":"updateLikeObject","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/reaction\/ReactionAction.class.php","line":168,"function":"react","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/forum\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '330-58824' for key 'objectTypeID'
Error Code: 23000
File: /customers/shalin/home/borderline-forum.eu/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/TFastCreate.class.php","line":44,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/DatabaseObjectEditor.class.php","line":28,"function":"dboEditorCreateBase","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":355,"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/reaction\/ReactionHandler.class.php","line":510,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/reaction\/ReactionHandler.class.php","line":331,"function":"updateLikeObject","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/reaction\/ReactionAction.class.php","line":168,"function":"react","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/forum\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

norse · Feb 6th 2023

Thread

Could not execute statement INSERT INTO wcf1_like / wcf1_like_object

Hallo,

der Fehler wurde leider mehrmals an den falschen Stellen eingestellt, nämlich hier und hier. Daher will ich ihn an der richtigen Stelle offiziell machen.

Die Fehlermeldungen finden sich in den verlinkten Threads. Betroffen ist jeweils die Version 5.2.
[…]

Zur Eingrenzung: Der Fehler tritt nicht ständig auf, sondern anscheinend nur unter bestimmten Vorraussetzungen, die ich jedoch nicht eingrenzen kann. Die Reaktions-Typen sind auf einen allein begrenzt. Es gibt also keine Auswahl, sondern…

less

Dec 16th 2020

Gruß norse

Shalin · Feb 7th 2023

Hallo norse,

danke, oh da sehe ich, ich hatte den Fehler schon mal.

Blöd, dass er nicht schon mal behoben wurde.

Liebe Grüße,

Shalin

Integrity constraint violation: 1062 Duplicate entry '330-58824' for key 'objectTypeID'

Tim Düsterhus Feb 7th 2023

Tim Düsterhus Mar 1st 2023

Participate now!

Share

Similar Threads

Fehlermeldung - ersuche um Hilfe

Beiträge aktualisieren schlägt fehlt

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '330-30869-27' for key 'objectTypeID'

Integrity constraint violation: 1062 Duplicate entry '[…]' for key 'username'

Fehler beim Update von 5.4 auf 5.5