Could not execute statement INSERT INTO wcf1_like / wcf1_like_object

less · Dec 16th 2020

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'

Display More

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 · Dec 28th 2020

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 · Dec 28th 2020

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 · Jan 10th 2021

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 · Jan 10th 2021

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

itsmeJAY · Mar 2nd 2021

+1

Geronimo · Mar 2nd 2021

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

Geronimo · Mar 3rd 2021

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 · Mar 3rd 2021

Geronimo Es ist die gleiche.

netzhuffle · Mar 4th 2021

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/thr…gisches-turnier/?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 · Apr 27th 2021

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 · Nov 16th 2021

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 · Nov 17th 2021

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 · Aug 19th 2022

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

Shalin · Nov 4th 2022

Wir hatten es jetzt auch wieder unter 5.5

Susi · Nov 8th 2022

Ich habe das unter 5.4 auch immer mal.

user1538092 · Monday, 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** · Monday, 9:40 am

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 · Monday, 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 Apr 12th 2021

Participate now!

Share

Similar Threads

Could not execute statement 'INSERT INTO wcf1_like

Could not execute statement 'INSERT INTO wcf1_user_storage

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 (?, ?, ?)'