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]}]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'];
        }
    } 
		 
		
		
	 
															
		



