Fehlermeldung beim Ändern eines Autor

Bitte in den Beiträgen keine externe Bilder einbinden, sondern nur die Dateianhänge verwenden.
Vielen dank.

    Ich nutze das Plugin "Beitrags-Autor ändern". Das hat auch bisher wunderbar funktioniert.

    Seit gestern bekomme ich allerdings die Fehlermeldung. (siehe Anhang)

    Fri, 19 Feb 2021 14:41:12 +0000 Message: Could not execute statement 'UPDATE wcf4_user SET wbbPosts = wbbPosts + ? WHERE userID = ?' PHP version: 7.3.19-1~deb10u1 WoltLab Suite version: 5.3.4 Request URI: POST /WSCNew/forum/index.php?ajax-proxy/&t=1af1d7adc843dad441a53305d05e93a83cc1b6e0 Referrer: http://10ausden70ern.org/WSCNew/forum/i…ead/2131-chase/ User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36 Edg/88.0.705.68 Peak Memory Usage: 3269768/134217728 ====== Error Class: wcf\system\database\exception\DatabaseQueryExecutionException Error Message: Could not execute statement 'UPDATE wcf4_user SET wbbPosts = wbbPosts + ? WHERE userID = ?' Error Code: 22007 File: /var/www/html/WSCNew/lib/system/database/statement/PreparedStatement.class.php (105) Extra Information: YToyOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOi0xO31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtzOjI6IicnIjt9fQ== Stack Trace: [{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/PostEditor.class.php","line":40,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":75,"function":"updatePostCounter","class":"wbb\\data\\post\\PostEditor","type":"::","args":[{"":"[redacted]"}]},{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":65,"function":"updatePostAuthor","class":"wbb\\data\\post\\AuthorChangePostAction","type":"::","args":["wbb\\data\\post\\PostEditor","wcf\\data\\user\\User"]},{"file":"\/var\/www\/html\/WSCNew\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"change","class":"wbb\\data\\post\\AuthorChangePostAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wbb"]}] ====== Error Class: PDOException Error Message: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect INTEGER value: '' Error Code: 22007 File: /var/www/html/WSCNew/lib/system/database/statement/PreparedStatement.class.php (93) Extra Information: - Stack Trace: [{"file":"\/var\/www\/html\/WSCNew\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/PostEditor.class.php","line":40,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":75,"function":"updatePostCounter","class":"wbb\\data\\post\\PostEditor","type":"::","args":[{"":"[redacted]"}]},{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":65,"function":"updatePostAuthor","class":"wbb\\data\\post\\AuthorChangePostAction","type":"::","args":["wbb\\data\\post\\PostEditor","wcf\\data\\user\\User"]},{"file":"\/var\/www\/html\/WSCNew\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"change","class":"wbb\\data\\post\\AuthorChangePostAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wbb"]}]

    Wo ist der Haken?

    Danke für kurze Hilfestellung.

    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.

  • Cyperghost 20. Februar 2021 um 14:44

    Hat das Label bestätigt hinzugefügt.

    [jira='AUTCHANGE-6'][/jira]

    Das andere wird mit der nächsten Version behoben und ist leider ein Problem mit Einträgen die ein Gast Beitrag vorher waren.

    Zitat von 1070er

    Nein, auch beim Ändern auf "Gast" kommt bei mir eine Fehlermeldung.

    Der Parameter „username“ fehlt oder ist ungültig.

    Was tun?.......

    Hast du auch einen Benutzernamen eingeben? Du musst leider neben dem Gast Haken auch einen Benutzernamen dafür hinterlegen.

  • Cyperghost 28. Februar 2021 um 14:05

    Hat das Label von bestätigt auf behoben geändert.

    Could not execute statement 'UPDATE wcf1_user_activity_point SET activityPoints = activityPoints - ?, items = items - ? WHERE objectTypeID = ? AND userID = ?'

    Bei m ir kommt diese Meldung:

    Mon, 01 Mar 2021 11:10:19 +0000

    Message: Could not execute statement 'UPDATE wcf4_user SET wbbPosts = wbbPosts + ? WHERE userID = ?'

    PHP version: 7.3.27-1~deb10u1

    WoltLab Suite version: 5.3.4

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

    Referrer: http://10ausden70ern.org/WSCNew/forum/i…te-blood-cells/

    User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36 Edg/88.0.705.74

    Peak Memory Usage: 3278224/134217728

    ======

    Error Class: wcf\system\database\exception\DatabaseQueryExecutionException

    Error Message: Could not execute statement 'UPDATE wcf4_user SET wbbPosts = wbbPosts + ? WHERE userID = ?'

    Error Code: 22007

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

    Extra Information: YToyOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOi0xO31pOjE7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDIiO2k6MTtzOjI6IicnIjt9fQ==

    Stack Trace: [{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/PostEditor.class.php","line":40,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":75,"function":"updatePostCounter","class":"wbb\\data\\post\\PostEditor","type":"::","args":[{"":"[redacted]"}]},{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":65,"function":"updatePostAuthor","class":"wbb\\data\\post\\AuthorChangePostAction","type":"::","args":["wbb\\data\\post\\PostEditor","wcf\\data\\user\\User"]},{"file":"\/var\/www\/html\/WSCNew\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"change","class":"wbb\\data\\post\\AuthorChangePostAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wbb"]}]

    ======

    Error Class: PDOException

    Error Message: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect INTEGER value: ''

    Error Code: 22007

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

    Extra Information: -

    Stack Trace: [{"file":"\/var\/www\/html\/WSCNew\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/PostEditor.class.php","line":40,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]"]]},{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":75,"function":"updatePostCounter","class":"wbb\\data\\post\\PostEditor","type":"::","args":[{"":"[redacted]"}]},{"file":"\/var\/www\/html\/WSCNew\/forum\/lib\/data\/post\/AuthorChangePostAction.class.php","line":65,"function":"updatePostAuthor","class":"wbb\\data\\post\\AuthorChangePostAction","type":"::","args":["wbb\\data\\post\\PostEditor","wcf\\data\\user\\User"]},{"file":"\/var\/www\/html\/WSCNew\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"change","class":"wbb\\data\\post\\AuthorChangePostAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/html\/WSCNew\/forum\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wbb"]}]