Super! Direkt installiert und sieht bis jetzt alles gut aus. Danke!
Beiträge von PoooMukkel im Thema „Fehler bei Reaktion auf eine News“
-
-
Und vielen Dank für die schnelle Hilfe!
-
Den Fehler habe ich bisher noch nicht erhalten...
-
Tatsächlich. Das funktioniert nun!
Kurz zur Erläuterung für die Mitleser: Das Ändern der zuerst genannten PHP Datei brachte zwar bei einer Reaktion auf eine News keinen direkten Fehler mehr, allerdings wurde die Reaktion auf die News in der Box "Letzte Aktivitäten" falsch angezeigt. Diese Box befindet sich auf meinem Dashboard und nachdem ich auf eine News reagiert hatte, knallte es beim Anzeigen des Dashboards. Ich habe die Box deaktiviert und mein Dashboard wurde wieder angezeigt.
Nun, nach Änderung der zweiten PHP Datei wird die Reaktion auch in der Box "Letzte Aktivitäten" korrekt angezeigt und ich erhalte keinen Fehler mehr beim Aufruf meiner Seite.
Puh, da fiel mir das Herz auf ein Mal schlagartig in die Hose...
-
Hmmm, irgendwie lässt sich nun meine Seite gar nicht mehr anzeigen. Bis zur Änderung ging es noch und ich habe keine Ahnung, in wie weit das miteinander zu tun hat...
Wenn ich eingeloggt bin, sehe ich sofort diesen Fehler:
Code
Alles anzeigenFri, 21 Feb 2020 13:01:14 +0000 Message: Undefined index: reactionType PHP version: 7.2.27-6+ubuntu18.04.1+deb.sury.org+1 WoltLab Suite version: 5.2.2 Request URI: / Referrer: User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.107 Safari/537.36 Peak Memory Usage: 19424880/268435456 ====== Error Class: wcf\system\exception\ErrorException Error Message: Undefined index: reactionType Error Code: 0 File: /var/www/compiware-forum.de/htdocs/compiware-forum.de/lib/system/WCF.class.php (341) Extra Information: - Stack Trace: [{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/template\/TemplateEngine.class.php(598) : eval()'d code","line":1,"function":"handleError","class":"wcf\\system\\WCF","type":"::","args":[8,"Undefined index: reactionType","\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/template\/TemplateEngine.class.php(598) : eval()'d code",1,{"compiledSource":"[redacted]","variables":"[redacted]","sandbox":"[redacted]"}]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/template\/TemplateEngine.class.php","line":598,"function":"eval","class":"","type":"","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/language\/Language.class.php","line":153,"function":"fetchString","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["Hat mit <span title=\"<?=wcf\\util\\StringUtil::encodeHTML($this->v['reactionType']->getTitle());?>\" class=\"jsTooltip\"><?=$this->v['reactionType']->renderIcon();?><\/span> auf die News <a href=\"<?=$this->v['news']->getLink();?>\" class=\"newsPreview\" data-news-id=\"<?=$this->v['news']->newsID;?>\"><?=wcf\\util\\StringUtil::encodeHTML($this->v['news']->getTitle());?><\/a> von <span><?=wcf\\util\\StringUtil::encodeHTML($this->v['news']->username);?><\/span> reagiert.",{"news":"[redacted]","__language":"[redacted]"}]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/deals\/lib\/system\/user\/activity\/event\/LikeableNewsUserActivityEvent.class.php","line":47,"function":"getDynamicVariable","class":"wcf\\data\\language\\Language","type":"->","args":["de.wbb-elite.news.recentActivity.likedNews",{"news":"[redacted]","__language":"[redacted]"}]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/user\/activity\/event\/ViewableUserActivityEventList.class.php","line":83,"function":"prepare","class":"news\\system\\user\\activity\\event\\LikeableNewsUserActivityEvent","type":"->","args":[["[redacted]"]]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":352,"function":"readObjects","class":"wcf\\data\\user\\activity\\event\\ViewableUserActivityEventList","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/box\/RecentActivityListBoxController.class.php","line":164,"function":"readObjects","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":326,"function":"readObjects","class":"wcf\\system\\box\\RecentActivityListBoxController","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/box\/AbstractDatabaseObjectListBoxController.class.php","line":293,"function":"loadContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/box\/RecentActivityListBoxController.class.php","line":131,"function":"hasContent","class":"wcf\\system\\box\\AbstractDatabaseObjectListBoxController","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/box\/Box.class.php","line":291,"function":"hasContent","class":"wcf\\system\\box\\RecentActivityListBoxController","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/box\/Box.class.php","line":276,"function":"hasContent","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/templates\/compiled\/26_wcf_1_cms.php","line":4849,"function":"render","class":"wcf\\data\\box\\Box","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/template\/TemplateEngine.class.php","line":334,"args":["\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/templates\/compiled\/26_wcf_1_cms.php"],"function":"include","class":"","type":""},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":["cms","wcf"]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
Als Gast sehe ich die Wartungsmeldung, die ich soeben aktiviert habe.
Ich habe die Änderungen an der PHP Datei wieder rückgängig gemacht, aber der Fehler bleibt. Zuletzt wurden 3 Beiträge geschrieben, die ich aus der DB gelöscht habe. Hatte gehofft, dass da vielleicht etwas enthalten war... Negativ.
Kommt die Meldung vom News System??
-
Funktioniert! Zumindest erscheint keine Fehlermeldung mehr.
-
Richtig. Das passiert.
-
Ich dachte schon, es läge an mir... Dann bin ich beruhigt.
-
Gibt es dafür einen schnellen Fix, den ich einbauen könnte, falls das Update länger dauert?
Frage mich, ob nur ich allein von diesem Problem betroffen bin. Lassen die anderen Nutzer des News Systems alle keine Reaktionen in den News zu?
-
Nachdem ich heute auf das WSC 5.2 aktualisiert habe, erhalte ich Fehlermeldungen beim Versuch, auf eine News zu reagieren.
Code
Alles anzeigenThu, 20 Feb 2020 21:52:41 +0000 Message: Could not prepare statement 'UPDATE news1_news news SET cumulativeLikes = COALESCE((SELECT SUM(cumulativeLikes) FROM news1_entry WHERE newsID = news.newsID AND isDisabled = 0 AND isDeleted = 0 AND isPublished = 1), 0) WHERE news.newsID = ?' PHP version: 7.2.27-6+ubuntu18.04.1+deb.sury.org+1 WoltLab Suite version: 5.2.2 Request URI: /deals/index.php?ajax-proxy/&t=7c19bb1d9c18215fd80bc49b1ec8847d394f0312 Referrer: https://www.compiware-forum.de/deals/news/420-faeria-assassin-s-creed-syndicate-kostenlos-im-epic-games-store/ User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.107 Safari/537.36 Peak Memory Usage: 10660416/268435456 ====== Error Class: wcf\system\database\exception\DatabaseQueryException Error Message: Could not prepare statement 'UPDATE news1_news news SET cumulativeLikes = COALESCE((SELECT SUM(cumulativeLikes) FROM news1_entry WHERE newsID = news.newsID AND isDisabled = 0 AND isDeleted = 0 AND isPublished = 1), 0) WHERE news.newsID = ?' Error Code: 42 File: /var/www/compiware-forum.de/htdocs/compiware-forum.de/lib/system/database/Database.class.php (284) Extra Information: - Stack Trace: [{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/deals\/lib\/data\/news\/LikeableNews.class.php","line":83,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["UPDATE\tnews1_news news\n\t\t\tSET\tcumulativeLikes = COALESCE((SELECT SUM(cumulativeLikes) FROM news1_entry WHERE newsID = news.newsID AND isDisabled = 0 AND isDeleted = 0 AND isPublished = 1), 0)\n\t\t\tWHERE news.newsID = ?"]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/reaction\/ReactionHandler.class.php","line":357,"function":"updateLikeCounter","class":"news\\data\\news\\LikeableNews","type":"->","args":[1]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/reaction\/ReactionAction.class.php","line":160,"function":"react","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":["news\\data\\news\\LikeableNews","wcf\\data\\user\\User",1]},{"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/deals\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["news"]}] ====== Error Class: PDOException Error Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pooomukkel_forum.news1_entry' doesn't exist Error Code: 42 File: /var/www/compiware-forum.de/htdocs/compiware-forum.de/lib/system/database/Database.class.php (279) Extra Information: - Stack Trace: [{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/database\/Database.class.php","line":279,"function":"prepare","class":"PDO","type":"->","args":["UPDATE\tnews1_news news\n\t\t\tSET\tcumulativeLikes = COALESCE((SELECT SUM(cumulativeLikes) FROM news1_entry WHERE newsID = news.newsID AND isDisabled = 0 AND isDeleted = 0 AND isPublished = 1), 0)\n\t\t\tWHERE news.newsID = ? -- '\/deals\/index.php?ajax-proxy\/&t=7c19bb1d9c18215fd80bc49b1ec8847d394f0312 (\\\\wcf\\\\data\\\\reaction\\\\ReactionAction:react)'"]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/deals\/lib\/data\/news\/LikeableNews.class.php","line":83,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["UPDATE\tnews1_news news\n\t\t\tSET\tcumulativeLikes = COALESCE((SELECT SUM(cumulativeLikes) FROM news1_entry WHERE newsID = news.newsID AND isDisabled = 0 AND isDeleted = 0 AND isPublished = 1), 0)\n\t\t\tWHERE news.newsID = ?"]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/reaction\/ReactionHandler.class.php","line":357,"function":"updateLikeCounter","class":"news\\data\\news\\LikeableNews","type":"->","args":[1]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/reaction\/ReactionAction.class.php","line":160,"function":"react","class":"wcf\\system\\reaction\\ReactionHandler","type":"->","args":["news\\data\\news\\LikeableNews","wcf\\data\\user\\User",1]},{"function":"react","class":"wcf\\data\\reaction\\ReactionAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/deals\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["news"]}]