Zitat von Nanum

Hallo,

ich fürchte das Update führt zu einem Fehler, wenn man versucht im Benutzerprofil eines beliebigen Benutzers den Reiter "Likes" zu öffnen. Folgender Fehler erscheint:

Code

Tue, 15 Aug 2017 23:53:22 +0000
Message: Could not execute statement 'SELECT    
                     like_table.*
                 FROM    wcf1_like like_table
                     
                     WHERE              (                 (                     like_table.objectTypeID = ?                     AND like_table.objectID IN                     (                         SELECT post.postID FROM wbb1_post post                         WHERE post.threadID IN                                 (                                     SELECT threadID FROM wbb1_thread thread                                     WHERE                                     thread.threadID = post.threadID                                     AND                                     (                                         (                                             thread.boardID IN(?)                                             AND thread.userID = ?                                         )                                         OR thread.isSticky = 1                                         OR thread.isAnnouncement = 1                                         OR thread.boardID NOT IN(?)                                                                      )                                 )                     )                 )                 OR like_table.objectTypeID != ?             ) AND like_table.objectUserID = ? AND like_table.likeValue = ?
                     ORDER BY like_table.time DESC LIMIT 20'
PHP version: 7.0.22
WoltLab Suite version: 3.0.8 pl 1
Request URI: /index.php?ajax-proxy/&t=7f047205b87ba6d5b5e27aa645a5ef70bfee50c3
Referrer: https://pyrolyse-gaming.de/benutzer/52-the-locki/
User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:54.0) Gecko/20100101 Firefox/54.0
Peak Memory Usage: 9472992/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'SELECT    
                     like_table.*
                 FROM    wcf1_like like_table
                     
                     WHERE              (                 (                     like_table.objectTypeID = ?                     AND like_table.objectID IN                     (                         SELECT post.postID FROM wbb1_post post                         WHERE post.threadID IN                                 (                                     SELECT threadID FROM wbb1_thread thread                                     WHERE                                     thread.threadID = post.threadID                                     AND                                     (                                         (                                             thread.boardID IN(?)                                             AND thread.userID = ?                                         )                                         OR thread.isSticky = 1                                         OR thread.isAnnouncement = 1                                         OR thread.boardID NOT IN(?)                                                                      )                                 )                     )                 )                 OR like_table.objectTypeID != ?             ) AND like_table.objectUserID = ? AND like_table.likeValue = ?
                     ORDER BY like_table.time DESC LIMIT 20'
Error Code: 0
File: /*/pyro/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTo1OntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjE4OTt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7aToyO31pOjI7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDMiO2k6MTtpOjE4OTt9aTozO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA0IjtpOjE7aTo1Mjt9aTo0O2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciA1IjtpOjE7aToxO319
Stack Trace: [{"file":"*/pyro\/lib\/data\/DatabaseObjectList.class.php","line":195,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"*/pyro\/lib\/data\/like\/ViewableLikeList.class.php","line":45,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"*/pyro\/lib\/system\/menu\/user\/profile\/content\/LikesUserProfileMenuContent.class.php","line":24,"function":"readObjects","class":"wcf\\data\\like\\ViewableLikeList","type":"->","args":[]},{"file":"*/pyro\/lib\/data\/user\/profile\/menu\/item\/UserProfileMenuItemAction.class.php","line":57,"function":"getContent","class":"wcf\\system\\menu\\user\\profile\\content\\LikesUserProfileMenuContent","type":"->","args":[52]},{"function":"getContent","class":"wcf\\data\\user\\profile\\menu\\item\\UserProfileMenuItemAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"*/pyro\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"*/pyro\/lib\/action\/AJAXProxyAction.class.php","line":74,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"*/pyro\/lib\/action\/AJAXInvokeAction.class.php","line":104,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"*/pyro\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"*/pyro\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"*/pyro\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"*/pyro\/lib\/system\/request\/RequestHandler.class.php","line":94,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"*/pyro\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[HY093]: Invalid parameter number
Error Code: 0
File: /*/pyro/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"*/pyro\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"*/pyro\/lib\/data\/DatabaseObjectList.class.php","line":195,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"]]},{"file":"*/pyro\/lib\/data\/like\/ViewableLikeList.class.php","line":45,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"*/pyro\/lib\/system\/menu\/user\/profile\/content\/LikesUserProfileMenuContent.class.php","line":24,"function":"readObjects","class":"wcf\\data\\like\\ViewableLikeList","type":"->","args":[]},{"file":"*/pyro\/lib\/data\/user\/profile\/menu\/item\/UserProfileMenuItemAction.class.php","line":57,"function":"getContent","class":"wcf\\system\\menu\\user\\profile\\content\\LikesUserProfileMenuContent","type":"->","args":[52]},{"function":"getContent","class":"wcf\\data\\user\\profile\\menu\\item\\UserProfileMenuItemAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"*/pyro\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"*/pyro\/lib\/action\/AJAXProxyAction.class.php","line":74,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"*/pyro\/lib\/action\/AJAXInvokeAction.class.php","line":104,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"*/pyro\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"*/pyro\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"*/pyro\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"*/pyro\/lib\/system\/request\/RequestHandler.class.php","line":94,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"*/pyro\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

Alles anzeigen

Abgesehen von dem Update habe ich nichts verändert. Gestern hat es noch funktioniert^^.

Ich werde dazu gleich einen Hotfix hochladen.

Zitat von Nanum

Hallo,

funktioniert. Dass der überflüssige ungelesene Beiträge Zähler nicht entfernt werden kann, wurde ja bereits an anderer Stelle mehrfach bestätigt. Danke für den ultraschnellen Fix.

das werde ich bei der nächsten Version nochmal überprüfen. Leider besteht immer noch der Fehler/Problem mit den Benachrichtigungen leider lässt Woltlab dies von deren Seiten nicht zu dies mit einem Plugin zu ändern.

Alles andere sollte jedoch möglich sein

Und das Update war schon länger geplant, jetzt wollte ich es einfach mal nach vorne schieben.

Ich habe aber eine Möglichkeit soeben gefunden, diese muss noch getestet werden

Kann ich im WSC3 bestätigen, leider gibt es da ein Problem, das gab es im WCF2.1 nicht.

Ich kann diese nicht entfernen

Ich gucke mal ob es irgendwie eine Lösung gibt.

[jira='KNETL-2'][/jira]

Welche Version hast du genau installiert und welche Box verwendest du?

Die Standard von Woltlab?