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