Beiträge von Mr.Stone im Thema „Fehlermeldung News-Sytem 5.4.1 pl 3“

Mr.Stone · 9. Januar 2022

Version 5.4.1 pl 5 Beiträge aktualisieren 100% !

Ich hatte noch die 5.4.1 pl 4 installiert...sorry

Somit hat sich dieser Beitrag erledigt.

Danke Olaf für den schnellen Fix

Mr.Stone · 9. Januar 2022

Zitat von Cyperghost

Könnte ich bitte die gesamt Fehlermeldung bekommen?

Code

Message: Could not prepare statement 'SELECT    DISTINCT news.newsID AS objectID, news.*
            FROM    news1_news news
                LEFT JOIN news1_news_to_category category ON(news.newsID = category.newsID)
                WHERE category.categoryID IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND news.newsID IN (?)
                ORDER BY lastUpdate DESC'
PHP version: 7.4.16
WoltLab Suite version: 5.4.10
Request URI: POST /acp/index.php?worker-proxy/&t=8556106742a777eeb70ba66ff85032af0cb1463584be89f9ef9b8e3210c2df33-MDE4MzIyMzgyNTBlN2JjMTU3MjdhNGJkNDkwODVjMzQ=
Referrer: https:///acp/index.php?rebuild-data/
User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15
Peak Memory Usage: 8790952/2097152000
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'SELECT    DISTINCT news.newsID AS objectID, news.*
            FROM    news1_news news
                LEFT JOIN news1_news_to_category category ON(news.newsID = category.newsID)
                WHERE category.categoryID IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND news.newsID IN (?)
                ORDER BY lastUpdate DESC'
Error Code: 42S22
File: /home/www//lib/system/database/Database.class.php (333)
Extra Information: -
Stack Trace: [{"file":"\/home\/www\/\/news\/lib\/data\/news\/NewsList.class.php","line":55,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tDISTINCT news.newsID AS objectID, news.*\r\t\t\tFROM\tnews1_news news\r\t\t\t\tLEFT JOIN news1_news_to_category category ON(news.newsID = category.newsID)\r\t\t\t\tWHERE category.categoryID IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND news.newsID IN (?)\r\t\t\t\tORDER BY lastUpdate DESC",0,0]},{"file":"\/home\/www\/\/news\/lib\/system\/message\/embedded\/object\/NewsMessageEmbeddedObjectHandler.class.php","line":46,"function":"readObjectIDs","class":"news\\data\\news\\NewsList","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/message\/embedded\/object\/MessageEmbeddedObjectManager.class.php","line":120,"function":"parse","class":"news\\system\\message\\embedded\\object\\NewsMessageEmbeddedObjectHandler","type":"->","args":["wcf\\system\\html\\input\\HtmlInputProcessor",{"news":"[redacted]"}]},{"file":"\/home\/www\/\/forum\/lib\/system\/worker\/PostRebuildDataWorker.class.php","line":193,"function":"registerObjects","class":"wcf\\system\\message\\embedded\\object\\MessageEmbeddedObjectManager","type":"->","args":["wcf\\system\\html\\input\\HtmlInputProcessor",true]},{"file":"\/home\/www\/\/lib\/acp\/action\/WorkerProxyAction.class.php","line":104,"function":"execute","class":"wbb\\system\\worker\\PostRebuildDataWorker","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\acp\\action\\WorkerProxyAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lastUpdate' in 'order clause'
Error Code: 42S22
File: /home/www//lib/system/database/Database.class.php (328)
Extra Information: -
Stack Trace: [{"file":"\/home\/www\/\/lib\/system\/database\/Database.class.php","line":328,"function":"prepare","class":"PDO","type":"->","args":["SELECT\tDISTINCT news.newsID AS objectID, news.*\r\t\t\tFROM\tnews1_news news\r\t\t\t\tLEFT JOIN news1_news_to_category category ON(news.newsID = category.newsID)\r\t\t\t\tWHERE category.categoryID IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND news.newsID IN (?)\r\t\t\t\tORDER BY lastUpdate DESC -- '\/acp\/index.php?worker-proxy\/&t=8556106742a777eeb70ba66ff85032af0cb1463584be89f9ef9b8e3210c2df33-MDE4MzIyMzgyNTBlN2JjMTU3MjdhNGJkNDkwODVjMzQ='"]},{"file":"\/home\/www\/\/news\/lib\/data\/news\/NewsList.class.php","line":55,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tDISTINCT news.newsID AS objectID, news.*\r\t\t\tFROM\tnews1_news news\r\t\t\t\tLEFT JOIN news1_news_to_category category ON(news.newsID = category.newsID)\r\t\t\t\tWHERE category.categoryID IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND news.newsID IN (?)\r\t\t\t\tORDER BY lastUpdate DESC",0,0]},{"file":"\/home\/www\/\/news\/lib\/system\/message\/embedded\/object\/NewsMessageEmbeddedObjectHandler.class.php","line":46,"function":"readObjectIDs","class":"news\\data\\news\\NewsList","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/message\/embedded\/object\/MessageEmbeddedObjectManager.class.php","line":120,"function":"parse","class":"news\\system\\message\\embedded\\object\\NewsMessageEmbeddedObjectHandler","type":"->","args":["wcf\\system\\html\\input\\HtmlInputProcessor",{"news":"[redacted]"}]},{"file":"\/home\/www\/\/forum\/lib\/system\/worker\/PostRebuildDataWorker.class.php","line":193,"function":"registerObjects","class":"wcf\\system\\message\\embedded\\object\\MessageEmbeddedObjectManager","type":"->","args":["wcf\\system\\html\\input\\HtmlInputProcessor",true]},{"file":"\/home\/www\/\/lib\/acp\/action\/WorkerProxyAction.class.php","line":104,"function":"execute","class":"wbb\\system\\worker\\PostRebuildDataWorker","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\acp\\action\\WorkerProxyAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

Alles anzeigen

Mr.Stone · 8. Januar 2022

Zitat von Cyperghost

Sollte mit der Version 5.4.1 pl 5 behoben sein

Mahlzeit Olaf,

leider besteht das Problem immer noch

Beiträge aktualisieren wird bei 81% abgebrochen und dann kommt wieder die Fehlermeldung

Code

Could not prepare statement 'SELECT DISTINCT news.newsID AS objectID, news.* FROM news1_news news LEFT JOIN news1_news_to_category category ON(news.newsID = category.newsID) WHERE category.categoryID IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND news.newsID IN (?) ORDER BY lastUpdate DESC'

Mr.Stone · 30. Dezember 2021

Hallo Olaf,

ich bekomme beim aktualisieren (Anzeigen aktualisieren) der Beiträge eine Fehlermeldung

Code

Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lastUpdate' in 'order clause'

Code

Message: Could not prepare statement 'SELECT    DISTINCT news.newsID AS objectID, news.*
            FROM    news1_news news
                LEFT JOIN news1_news_to_category category ON(news.newsID = category.newsID)
                WHERE category.categoryID IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND news.newsID IN (?)
                ORDER BY lastUpdate DESC'
PHP version: 8.0.3
WoltLab Suite version: 5.4.10
Request URI: POST /acp/index.php?worker-proxy/&t=8556106742a777eeb70ba66ff85032af0cb1463584be89f9ef9b8e3210c2df33-MDE4MzIyMzgyNTBlN2JjMTU3MjdhNGJkNDkwODVjMzQ=
Referrer: https://domain/acp/index.php?rebuild-data/
User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15
Peak Memory Usage: 8835144/2097152000
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'SELECT    DISTINCT news.newsID AS objectID, news.*
            FROM    news1_news news
                LEFT JOIN news1_news_to_category category ON(news.newsID = category.newsID)
                WHERE category.categoryID IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND news.newsID IN (?)
                ORDER BY lastUpdate DESC'
Error Code: 42S22
File: /home/www//lib/system/database/Database.class.php (333)
Extra Information: -
Stack Trace: [{"file":"\/home\/www\/\/news\/lib\/data\/news\/NewsList.class.php","line":55,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tDISTINCT news.newsID AS objectID, news.*\r\t\t\tFROM\tnews1_news news\r\t\t\t\tLEFT JOIN news1_news_to_category category ON(news.newsID = category.newsID)\r\t\t\t\tWHERE category.categoryID IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND news.newsID IN (?)\r\t\t\t\tORDER BY lastUpdate DESC",0,0]},{"file":"\/home\/www\/\/news\/lib\/system\/message\/embedded\/object\/NewsMessageEmbeddedObjectHandler.class.php","line":46,"function":"readObjectIDs","class":"news\\data\\news\\NewsList","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/message\/embedded\/object\/MessageEmbeddedObjectManager.class.php","line":120,"function":"parse","class":"news\\system\\message\\embedded\\object\\NewsMessageEmbeddedObjectHandler","type":"->","args":["wcf\\system\\html\\input\\HtmlInputProcessor",{"news":"[redacted]"}]},{"file":"\/home\/www\/\/forum\/lib\/system\/worker\/PostRebuildDataWorker.class.php","line":193,"function":"registerObjects","class":"wcf\\system\\message\\embedded\\object\\MessageEmbeddedObjectManager","type":"->","args":["wcf\\system\\html\\input\\HtmlInputProcessor",true]},{"file":"\/home\/www\/\/lib\/acp\/action\/WorkerProxyAction.class.php","line":104,"function":"execute","class":"wbb\\system\\worker\\PostRebuildDataWorker","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\acp\\action\\WorkerProxyAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lastUpdate' in 'order clause'
Error Code: 42S22
File: /home/www//lib/system/database/Database.class.php (328)
Extra Information: -
Stack Trace: [{"file":"\/home\/www\/\/lib\/system\/database\/Database.class.php","line":328,"function":"prepare","class":"PDO","type":"->","args":["SELECT\tDISTINCT news.newsID AS objectID, news.*\r\t\t\tFROM\tnews1_news news\r\t\t\t\tLEFT JOIN news1_news_to_category category ON(news.newsID = category.newsID)\r\t\t\t\tWHERE category.categoryID IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND news.newsID IN (?)\r\t\t\t\tORDER BY lastUpdate DESC -- '\/acp\/index.php?worker-proxy\/&t=8556106742a777eeb70ba66ff85032af0cb1463584be89f9ef9b8e3210c2df33-MDE4MzIyMzgyNTBlN2JjMTU3MjdhNGJkNDkwODVjMzQ='"]},{"file":"\/home\/www\/\/news\/lib\/data\/news\/NewsList.class.php","line":55,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\tDISTINCT news.newsID AS objectID, news.*\r\t\t\tFROM\tnews1_news news\r\t\t\t\tLEFT JOIN news1_news_to_category category ON(news.newsID = category.newsID)\r\t\t\t\tWHERE category.categoryID IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND news.newsID IN (?)\r\t\t\t\tORDER BY lastUpdate DESC",0,0]},{"file":"\/home\/www\/\/news\/lib\/system\/message\/embedded\/object\/NewsMessageEmbeddedObjectHandler.class.php","line":46,"function":"readObjectIDs","class":"news\\data\\news\\NewsList","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/message\/embedded\/object\/MessageEmbeddedObjectManager.class.php","line":120,"function":"parse","class":"news\\system\\message\\embedded\\object\\NewsMessageEmbeddedObjectHandler","type":"->","args":["wcf\\system\\html\\input\\HtmlInputProcessor",{"news":"[redacted]"}]},{"file":"\/home\/www\/\/forum\/lib\/system\/worker\/PostRebuildDataWorker.class.php","line":193,"function":"registerObjects","class":"wcf\\system\\message\\embedded\\object\\MessageEmbeddedObjectManager","type":"->","args":["wcf\\system\\html\\input\\HtmlInputProcessor",true]},{"file":"\/home\/www\/\/lib\/acp\/action\/WorkerProxyAction.class.php","line":104,"function":"execute","class":"wbb\\system\\worker\\PostRebuildDataWorker","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\acp\\action\\WorkerProxyAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/home\/www\/\/lib\/system\/request\/RequestHandler.class.php","line":119,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/home\/www\/\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

Alles anzeigen

Anscheinend liegt hier wohl ein Fehler vor

PHP: NewsList.class.php

/**
     * @inheritdoc
     */
    public function readObjectIDs() {
        $this->objectIDs = [];
        $sql = "SELECT    DISTINCT " . $this->getDatabaseTableAlias() . "." . $this->getDatabaseTableIndexName() . " AS objectID, " . $this->getDatabaseTableAlias() . ".*
            FROM    " . $this->getDatabaseTableName() . " " . $this->getDatabaseTableAlias() . "
                " . $this->sqlConditionJoins . "
                " . $this->getConditionBuilder() . "
                " . (!empty($this->sqlOrderBy) ? "ORDER BY " . $this->sqlOrderBy : '');
        
        $statement = WCF::getDB()->prepareStatement($sql, $this->sqlLimit, $this->sqlOffset);
        $statement->execute($this->getConditionBuilder()->getParameters());
        
        while ($row = $statement->fetchArray()) {
            $this->objectIDs[] = $row['objectID'];
        }
    }

Alles anzeigen

Beiträge von Mr.Stone im Thema „Fehlermeldung News-Sytem 5.4.1 pl 3“

Fehlermeldung News-Sytem 5.4.1 pl 3

Fehlermeldung News-Sytem 5.4.1 pl 3

Fehlermeldung News-Sytem 5.4.1 pl 3

Fehlermeldung News-Sytem 5.4.1 pl 3

Informationen

Support

Über uns