Could not execute statement INSERT INTO wcf1_like / wcf1_like_object

less · December 16, 2020 at 11:30 PM

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.

Quote from less

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'

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 den direkten Button.

Womöglich können auch SKrull ZeroGravity TeRRible__KHONS hierzu sagen, ob sie eine ähnliche Konfiguration nutzen. Sie hatten den Fehler in den beiden anderen Threads gemeldet.

ZeroGravity · December 28, 2020 at 5:32 PM

Quote from less

Zur Eingrenzung: Der Fehler tritt nicht ständig auf, sondern anscheinend nur unter bestimmten Vorraussetzungen

So denke ich das auch. Bzw. kann ich es bestätigen das der Fehler nicht ständig auftritt. Wir haben jetzt schon seit einiger Zeit keinen Fehler mehr bekommen. Aber schon gesagt, es kommt immer mal wieder vor.

less · December 28, 2020 at 6:52 PM

Ich kann auch noch einen Punkt für eine Eingrenzung nachreichen: Das Problem tritt erst seit dem neuen Reaktions-System von 5.2 auf. Vorher gab es nie diese Fehlermeldungen.

galmi77 · January 10, 2021 at 6:18 PM

Schließe mich mal an. Bei uns kommt der Fehler auch regelmässig in unregelmässigen Abständen

Ist jetzt nicht weiter wild, aber wäre schon nett zu erfahren woran der liegen könnte und ob man ihn los bekommt.

TeRRible__KHONS · January 10, 2021 at 6:50 PM

Sorry thread übersehen, kommt nach wie vor noch regelmäßig vor 😬

itsmeJAY · March 2, 2021 at 8:06 AM

+1

Geronimo · March 2, 2021 at 9:05 AM

Ja, steht bei uns auch in jeder Benachrichtigung, Version 5.3.

Geronimo · March 3, 2021 at 12:55 PM

Hm, unsere Fehlermeldungen lauten anders...

Quote

Tue, 02 Mar 2021 15:35:42 +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.4

Request URI: POST /forum/index.php?ajax-proxy/&t=a6ea86ecd719d11d879acef09f311ea61cbc3084

Referrer:

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:86.0) Gecko/20100101 Firefox/86.0

Peak Memory Usage: 3364984/1073741824

======

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: /home/www/meisterschuetzen/www/lib/system/database/statement/PreparedStatement.class.php (105)

Extra Information: YTo3OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjU3O31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtpOjEyNjA2Nzt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aTo1ODg7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO2k6MTt9aTo0O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA1IjtpOjE7aTowO31pOjU7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDYiO2k6MTtpOjE7fWk6NjthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNyI7aToxO3M6MTY6IidhOjE6e2k6MTtpOjE7fSciO319

Stack Trace: [{"file":"\/home\/www\/meisterschuetzen\/www\/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":"\/home\/www\/meisterschuetzen\/www\/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":"\/home\/www\/meisterschuetzen\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/reaction\/ReactionHandler.class.php","line":464,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/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":"\/home\/www\/meisterschuetzen\/www\/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":"\/home\/www\/meisterschuetzen\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/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 '57-126067' for key 'objectTypeID'

Error Code: 23000

File: /home/www/meisterschuetzen/www/lib/system/database/statement/PreparedStatement.class.php (93)

Extra Information: -

Stack Trace: [{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/home\/www\/meisterschuetzen\/www\/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":"\/home\/www\/meisterschuetzen\/www\/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":"\/home\/www\/meisterschuetzen\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/reaction\/ReactionHandler.class.php","line":464,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/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":"\/home\/www\/meisterschuetzen\/www\/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":"\/home\/www\/meisterschuetzen\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wbb"]}]

Display More

Quote

Sat, 27 Feb 2021 14:59:50 +0000

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

PHP version: 7.4.13

WoltLab Suite version: 5.3.4

Request URI: POST /forum/index.php?ajax-proxy/&t=5172819bb62b5ca1852be7b9fb6078141a7c688b

Referrer:

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:86.0) Gecko/20100101 Firefox/86.0

Peak Memory Usage: 3476840/1073741824

======

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: /home/www/meisterschuetzen/www/lib/system/database/statement/PreparedStatement.class.php (105)

Extra Information: YTo3OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjEyNjA2MTt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7aTo1Nzt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aTo0ODcxO31pOjM7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDQiO2k6MTtpOjE2ODQ7fWk6NDthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNSI7aToxO2k6MTYxNDQzNzk5MDt9aTo1O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA2IjtpOjE7aToxO31pOjY7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDciO2k6MTtpOjE7fX0=

Stack Trace: [{"file":"\/home\/www\/meisterschuetzen\/www\/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":[{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"class":"","type":""},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/reaction\/ReactionHandler.class.php","line":329,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/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":"\/home\/www\/meisterschuetzen\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/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 '57-126061-1684' for key 'objectTypeID'

Error Code: 23000

File: /home/www/meisterschuetzen/www/lib/system/database/statement/PreparedStatement.class.php (93)

Extra Information: -

Stack Trace: [{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/home\/www\/meisterschuetzen\/www\/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":[{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"class":"","type":""},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/reaction\/ReactionHandler.class.php","line":329,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/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":"\/home\/www\/meisterschuetzen\/www\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/meisterschuetzen\/www\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wbb"]}]

Display More

less · March 3, 2021 at 1:39 PM

Geronimo Es ist die gleiche.

netzhuffle · March 4, 2021 at 10:22 PM

Weiterer Datenpunkt für WoltLab Suite 5.3.4:

Quote

Sat, 27 Feb 2021 23:00:24 +0000

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

PHP version: 7.4.3

WoltLab Suite version: 5.3.4

Request URI: POST /forum/index.php?ajax-proxy/&t=e7d19939addb84d26692d24244aa9732ff5a190f

Referrer: https://www.hp-fc.de/forum/thread/4…rnier/?pageNo=2

User Agent: Mozilla/5.0 (Linux; Android 10; SAMSUNG SM-G960F) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/13.2 Chrome/83.0.4103.106 Mobile Safari/537.36

Peak Memory Usage: 8178664/134217728

======

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: /var/www/html/community/lib/system/database/statement/PreparedStatement.class.php (105)

Extra Information: YTo3OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjI0MDAyODQ7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO2k6MzAyO31pOjI7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDMiO2k6MTtpOjEzMzQ1ODt9aTozO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA0IjtpOjE7aToxNDA4ODI7fWk6NDthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNSI7aToxO2k6MTYxNDQ2NjgyNDt9aTo1O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA2IjtpOjE7aToxO31pOjY7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDciO2k6MTtpOjE7fX0=

Stack Trace: [{"file":"\/var\/www\/html\/community\/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":[{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/html\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"class":"","type":""},{"file":"\/var\/www\/html\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\data\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/system\/reaction\/ReactionHandler.class.php","line":329,"function":"executeAction","class":"wcf\data\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/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":"\/var\/www\/html\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"react","class":"wcf\data\reaction\ReactionAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\data\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\action\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\action\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"run","class":"wcf\action\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/system\/request\/Request.class.php","line":83,"function":"run","class":"wcf\action\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\system\request\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/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 '302-2400284-140882' for key 'objectTypeID'

Error Code: 23000

File: /var/www/html/community/lib/system/database/statement/PreparedStatement.class.php (93)

Extra Information: -

Stack Trace: [{"file":"\/var\/www\/html\/community\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/community\/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":[{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/html\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"objectID":"[redacted]","objectTypeID":"[redacted]","objectUserID":"[redacted]","userID":"[redacted]","time":"[redacted]","likeValue":"[redacted]","reactionTypeID":"[redacted]"}],"class":"","type":""},{"file":"\/var\/www\/html\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"create","class":"wcf\data\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/system\/reaction\/ReactionHandler.class.php","line":329,"function":"executeAction","class":"wcf\data\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/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":"\/var\/www\/html\/community\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"react","class":"wcf\data\reaction\ReactionAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\data\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\action\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\action\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"run","class":"wcf\action\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/system\/request\/Request.class.php","line":83,"function":"run","class":"wcf\action\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/community\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\system\request\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/forum\/index.php","line":9,"function":"handle","class":"wcf\system\request\RequestHandler","type":"->","args":["wbb"]}]

Display More

moere22 · April 27, 2021 at 3:33 PM

Hatte den Fehler gestern auch das erste mal im Logfile.

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

Geronimo · November 16, 2021 at 2:06 PM

Weiß man inzwischen, woher das kommt, und ob man sich Sorgen machen sollte?

Quote

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

moere22 · November 17, 2021 at 8:18 PM

Ist doch als zukünftige Behebung gekennzeichnet. Wäre es Kritisch, wäre es wohl schon als Update ausgerollt worden. hab es aber zum Glück nicht mehr gehabt.

Bimmelbahn-Forum · August 19, 2022 at 9:11 AM

Hallo zusammen, auch unter 5.5. tritt das Problem sporadisch auf, ich hatte es in den letzten Tagen mehrmals.

Shalin · November 4, 2022 at 10:19 PM

Wir hatten es jetzt auch wieder unter 5.5

Susi · November 8, 2022 at 9:27 AM

Ich habe das unter 5.4 auch immer mal.

user1538092 · March 27, 2023 at 7:12 AM

Bei der 5.5.10 kam dieser Fehler bei uns nun erstmals auch

Code

Message: Could not execute statement 'INSERT INTO wcf1_user_collapsible_content                                     (objectTypeID, objectID, userID)                         VALUES      (?, ?, ?)'
PHP version: 8.1.17
WoltLab Suite version: 5.5.10
Request URI: POST /forum/index.php?ajax-proxy/&t=b790637939b24d82d01d125a470bac848f1fc545e8d50cd211a0024692e3d668-7U9gbgDfGgL1DDExTIENMA==
Referrer: https://xxx
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36
Peak Memory Usage: 12906176/134217728
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'INSERT INTO wcf1_user_collapsible_content                                     (objectTypeID, objectID, userID)                         VALUES      (?, ?, ?)'
Error Code: 23000
File: /usr/share/nginx/xxx/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YTozOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjMwOTt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7aToyNzIxO31pOjI7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDMiO2k6MTtpOjUzO319
Stack Trace: [{"file":"\/usr\/share\/nginx\/xxx\/lib\/system\/user\/collapsible\/content\/UserCollapsibleContentHandler.class.php","line":160,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/forum\/lib\/data\/board\/BoardAction.class.php","line":332,"function":"markAsCollapsed","class":"wcf\\system\\user\\collapsible\\content\\UserCollapsibleContentHandler","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"loadContainer","class":"wbb\\data\\board\\BoardAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/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 '309-2721-53' for key 'objectTypeID'
Error Code: 23000
File: /usr/share/nginx/xxx/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/usr\/share\/nginx\/xxx\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/system\/user\/collapsible\/content\/UserCollapsibleContentHandler.class.php","line":160,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/forum\/lib\/data\/board\/BoardAction.class.php","line":332,"function":"markAsCollapsed","class":"wcf\\system\\user\\collapsible\\content\\UserCollapsibleContentHandler","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"loadContainer","class":"wbb\\data\\board\\BoardAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/usr\/share\/nginx\/xxx\/forum\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]

Display More

**Tim Düsterhus** · March 27, 2023 at 9:40 AM Official Post

Hallo,

Quote from user1538092

Message: Could not execute statement 'INSERT INTO wcf1_user_collapsible_content (objectTypeID, objectID, userID) VALUES (?, ?, ?)'

das ist eine andere Fehlermeldung.

Susi · March 27, 2023 at 9:56 AM

Gerade heute Nacht kam sie auch in 5.5 mal wieder.

Could not execute statement INSERT INTO wcf1_like / wcf1_like_object

Alexander Ebert April 12, 2021 at 1:43 PM

Participate now!

Similar Threads