- Affected Version
- WoltLab Suite 5.5
- Affected App
- WoltLab Suite Forum
Hallo,
in letzter Zeit (seit ca. 3 oder 4 Monaten) verschwinden in meinem Forum immer mal wieder Datenbanktabellen spurlos. In der letzten Woche hat es so sich sehr gehäuft, dass ich in den täglichen Backups von Freitag bis heute die Zahl von 185 über 183 auf letztlich 180 Tabellen schrumpfen sehen konnte. Darunter waren jetzt im letzten Schritt auch die Tabelle wcf1_search sowie wcf1_user_notification und noch einzelne Untertabellen sowie wcf1_acl_option_category. Bei Suche und Öffnen von Beiträgen kam es zu Fehlern, weshalb User*innen mich nun darauf aufmerksam gemacht haben und ich das erstmal bemerkt habe. Die vorher verschwundenen Tabellen kann ich nicht mehr so klar nachvollziehen, das hatte aber neulich schon mal einen Fehler beim Aufrufen der Benachrichtigungen aufgeworfen, war nach Wiederherstellen aber in Ordnung.
Aufgetreten ist das alles in Version 5.4, ich habe erst heute nach Lizenzerneuerung auf 5.5 aktualisiert. An Konfigurationen, Plugins usw. hat sich sonst nichts verändert.
Jetzt habe ich die als fehlend identifizierten Tabellen aus dem Backup von vorgestern wiederhergestellt, es kommt aber zu (zumindest diesen beiden, vielleicht auch noch weiteren mir unbekannten) Fehlern:
1. Am wichtigsten: beim Aufrufen eines Themas mit neuem Beitrag (oder einzelner von mir geschriebener Themen ohne neuen Beitrag, die aber als neu angezeigt werden) kommt folgende Fehlermeldung, die beim zweiten Aufrufen des Themas (also nach Aktualisierung der Benachrichtigungen) auch wieder verschwindet:
Display Spoiler
Mon, 09 Jan 2023 17:52:22 +0000
Message: Could not execute statement 'SELECT notificationID FROM wcf1_user_notification notification WHERE notification.userID = ? AND notification.confirmTime = ? AND notification.eventID IN (?) AND notification.objectID IN ( SELECT postID FROM wbb1_post WHERE threadID IN (?) AND time <= ? )'
PHP version: 7.4.3
WoltLab Suite version: 5.5.7
Request URI: GET /board/index.php?thread/363-thrombus-in-herzleistung/
Referrer: https://forum.patientensim2.de/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36
Peak Memory Usage: 3814608/134217728
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'SELECT notificationID FROM wcf1_user_notification notification WHERE notification.userID = ? AND notification.confirmTime = ? AND notification.eventID IN (?) AND notification.objectID IN ( SELECT postID FROM wbb1_post WHERE threadID IN (?) AND time <= ? )'
Error Code: HY093
File: /var/www/patientensim2/forum/lib/system/database/statement/PreparedStatement.class.php (144)
Extra Information: YTo0OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjE7fWk6MTthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgMiI7aToxO2k6MDt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aTozNjM7fWk6MzthOjI6e2k6MDtzOjE3OiJRdWVyeSBQYXJhbWV0ZXIgNCI7aToxO2k6MTY3MzI2NDYzMjt9fQ==
Stack Trace: [{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/data\/thread\/ThreadAction.class.php","line":472,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"markAsRead","class":"wbb\\data\\thread\\ThreadAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/page\/AbstractThreadPage.class.php","line":363,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/page\/AbstractThreadPage.class.php","line":202,"function":"updateThreadVisit","class":"wbb\\page\\AbstractThreadPage","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/page\/ThreadPage.class.php","line":79,"function":"readData","class":"wbb\\page\\AbstractThreadPage","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/page\/AbstractPage.class.php","line":353,"function":"readData","class":"wbb\\page\\ThreadPage","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[HY093]: Invalid parameter number
Error Code: HY093
File: /var/www/patientensim2/forum/lib/system/database/statement/PreparedStatement.class.php (126)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/patientensim2\/forum\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":126,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/data\/thread\/ThreadAction.class.php","line":472,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"markAsRead","class":"wbb\\data\\thread\\ThreadAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/page\/AbstractThreadPage.class.php","line":363,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/page\/AbstractThreadPage.class.php","line":202,"function":"updateThreadVisit","class":"wbb\\page\\AbstractThreadPage","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/page\/ThreadPage.class.php","line":79,"function":"readData","class":"wbb\\page\\AbstractThreadPage","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/page\/AbstractPage.class.php","line":353,"function":"readData","class":"wbb\\page\\ThreadPage","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
2. Kommt beim Aktualisieren der Anzeigen im ACP beim Ausführen der Aktion "Diskussions-Themen für Artikel aktualisieren" folgender Fehler, die Aktion kann dadurch nicht abgeschlossen werden:
Display Spoiler
Mon, 09 Jan 2023 17:53:13 +0000
Message: Undefined offset: 1
PHP version: 7.4.3
WoltLab Suite version: 5.5.7
Request URI: POST /acp/index.php?worker-proxy/&t=e8d15437e0175b0e20c019c183eb8f8db61cca67a53fe51bbf20dabd4884b6d3-m9Cgz3wYitdkysbKskfzBA==
Referrer: https://forum.patientensim2.de/acp/index.php?rebuild-data/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36
Peak Memory Usage: 2695488/134217728
======
Error Class: wcf\system\exception\ErrorException
Error Message: Undefined offset: 1
Error Code: 0
File: /var/www/patientensim2/forum/lib/system/WCF.class.php (341)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/system\/worker\/ArticleThreadsRebuildDataWorker.class.php","line":91,"function":"handleError","class":"wcf\\system\\WCF","type":"::","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/acp\/action\/WorkerProxyAction.class.php","line":104,"function":"execute","class":"wbb\\system\\worker\\ArticleThreadsRebuildDataWorker","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\acp\\action\\WorkerProxyAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
3. (Ergänzung): beim Setzen eines Labels kommt folgender Fehler:
Display Spoiler
Mon, 09 Jan 2023 18:28:18 +0000
Message: Unknown event com.woltlab.wbb.moderation.thread-moderate given
PHP version: 7.4.3
WoltLab Suite version: 5.5.7
Request URI: POST /board/index.php?ajax-proxy/&t=a21e1c3fdd032c5a88797e2427d69f8f0bfe9f92655a04454a43f886c6f70cfc-kJlmjveyelMldGqN1A537Q==
Referrer: https://forum.patientensim2.de/board/index.ph…ng/&postID=1315
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36
Peak Memory Usage: 3419704/134217728
======
Error Class: wcf\system\exception\SystemException
Error Message: Unknown event com.woltlab.wbb.moderation.thread-moderate given
Error Code: 0
File: /var/www/patientensim2/forum/lib/system/user/notification/UserNotificationHandler.class.php (107)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/system\/log\/modification\/ThreadModificationLogHandler.class.php","line":317,"function":"fireEvent","class":"wcf\\system\\user\\notification\\UserNotificationHandler","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/system\/log\/modification\/ThreadModificationLogHandler.class.php","line":161,"function":"fireNotification","class":"wbb\\system\\log\\modification\\ThreadModificationLogHandler","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/system\/thread\/editor\/LabelThreadEditor.class.php","line":134,"function":"setLabel","class":"wbb\\system\\log\\modification\\ThreadModificationLogHandler","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/system\/thread\/ThreadHandler.class.php","line":107,"function":"saveEdit","class":"wbb\\system\\thread\\editor\\LabelThreadEditor","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/lib\/data\/thread\/ThreadAction.class.php","line":911,"function":"saveEdit","class":"wbb\\system\\thread\\ThreadHandler","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"saveEdit","class":"wbb\\data\\thread\\ThreadAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/patientensim2\/forum\/board\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
Langsam hab ich den Eindruck, da geht gar nichts mehr..
Vielen Dank für sämtliche Hilfe vorweg!
Beste Grüße
Lukas
