Super, vielen Dank!
Jetzt funktioniert bei mir auch alles
Beiträge von Tim im Thema „Fehlermeldung beim Ändern eines Autor“
-
-
Could not execute statement 'UPDATE wcf1_user_activity_point SET activityPoints = activityPoints - ?, items = items - ? WHERE objectTypeID = ? AND userID = ?'
Code
Alles anzeigenMon, 01 Mar 2021 02:35:12 +0000 Message: Could not execute statement 'UPDATE wcf1_user_activity_point SET activityPoints = activityPoints - ?, items = items - ? WHERE objectTypeID = ? AND userID = ?' PHP version: 7.4.3 WoltLab Suite version: 5.3.4 Request URI: POST /ws/forum/index.php?ajax-proxy/&t=c15468923c82b33c369f3805aa1d74e2653e571a Referrer: http://localhost/ws/forum/index.php?thread/124-test-thema/ User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36 Peak Memory Usage: 2923736/134217728 ====== Error Class: wcf\system\database\exception\DatabaseQueryExecutionException Error Message: Could not execute statement 'UPDATE wcf1_user_activity_point SET activityPoints = activityPoints - ?, items = items - ? WHERE objectTypeID = ? AND userID = ?' Error Code: 22007 File: /home/tim/Projects/ws/lib/system/database/statement/PreparedStatement.class.php (105) Extra Information: YTo0OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjU7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO2k6MTt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aTozNTE7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO3M6MjoiJyciO319 Stack Trace: [{"file":"\/home\/tim\/Projects\/ws\/lib\/system\/user\/activity\/point\/UserActivityPointHandler.class.php","line":179,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":93,"function":"removeEvents","class":"wcf\\system\\user\\activity\\point\\UserActivityPointHandler","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":66,"function":"updatePostAuthor","class":"wbb\\data\\post\\AuthorChangePostAction","type":"::","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"change","class":"wbb\\data\\post\\AuthorChangePostAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}] ====== Error Class: PDOException Error Message: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect INTEGER value: '' Error Code: 22007 File: /home/tim/Projects/ws/lib/system/database/statement/PreparedStatement.class.php (93) Extra Information: - Stack Trace: [{"file":"\/home\/tim\/Projects\/ws\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/system\/user\/activity\/point\/UserActivityPointHandler.class.php","line":179,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":93,"function":"removeEvents","class":"wcf\\system\\user\\activity\\point\\UserActivityPointHandler","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":66,"function":"updatePostAuthor","class":"wbb\\data\\post\\AuthorChangePostAction","type":"::","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"change","class":"wbb\\data\\post\\AuthorChangePostAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/tim\/Projects\/ws\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
-
-
So, ich hab da mal ein Update veröffentlich, die Version2.1.0 pl 5 damit sollte der Fehler behoben sein
Der Fehler von mir (von Gast Autor zu reg. Benutzer Autor) aber noch nicht oder?
Das andere wird mit der nächsten Version behoben und ist leider ein Problem mit Einträgen die ein Gast Beitrag vorher waren.
Also "nächste Version" heißt dann 2.1.1?
-
Hi,
das ist mir auch schon aufgefallen.Das Problem tritt auf, wenn man versucht, den Autor von einem Beitrag zu ändern, der von einem Gast stammt. Der Gast hat keine userID.
Man kann also den Autor von einem Mitglied auf einen Gast ändern, umgekehrt geht das dann aber nicht mehr.