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

Shalin · Jul 26th 2022

Hallo,

ich habe eine Fehlermeldung, was bedeutet sie, hat irgendwas mit dem Like System zu tun?

Requested URL: POST /forum/index.php?ajax-proxy/&t=c0f2fe9b6875351e68bb7b7531a33c52c28cd3bcea2c873d3bddef5292762909-qreWo5qW7349kT2Qp+fsCQ==

Referrer: https://borderline-forum.eu/forum/thread/1532-crazygirl2022/

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

Query Parameter 1: 30869

Query Parameter 2: 330

Query Parameter 3: 23

Query Parameter 4: 27

Query Parameter 5: 1658785843

Query Parameter 6: 1

Query Parameter 7: 2

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 (348): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/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-30869-27' 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 (348): wcf\data\AbstractDatabaseObjectAction->executeAction(…)
/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, 25 Jul 2022 21:50:43 +0000
Message: Could not execute statement 'INSERT INTO wcf1_like                             (objectID,objectTypeID,objectUserID,userID,time,likeValue,reactionTypeID)                 VALUES      (?,?,?,?,?,?,?)'
PHP version: 7.4.28
WoltLab Suite version: 5.5.3
Request URI: POST /forum/index.php?ajax-proxy/&t=c0f2fe9b6875351e68bb7b7531a33c52c28cd3bcea2c873d3bddef5292762909-qreWo5qW7349kT2Qp+fsCQ==
Referrer: https://borderline-forum.eu/forum/thread/1532-crazygirl2022/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36
Peak Memory Usage: 10323072/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/shalin/home/borderline-forum.eu/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YTo3OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjMwODY5O31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjMzMDt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aToyMzt9aTozO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA0IjtpOjE7aToyNzt9aTo0O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA1IjtpOjE7aToxNjU4Nzg1ODQzO31pOjU7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDYiO2k6MTtpOjE7fWk6NjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNyI7aToxO2k6Mjt9fQ==
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":348,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","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-30869-27' 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":348,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","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":[]}]

**Tim Düsterhus** · Jul 28th 2022

Hallo,

Duplikat: Could not execute statement INSERT INTO wcf1_like / wcf1_like_object

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

Tim Düsterhus Jul 28th 2022

Tim Düsterhus Jul 29th 2022

Participate now!

Share

Similar Threads

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

Fehler beim Update von 5.4 auf 5.5

Fehler beim Upgrade

Fehlermeldung - Could not execute

Smilies per FTP hochladen