Hi,
ich krieg auf der Seite "News-Kategorien (Auflistung)" wenn ich in der Seitenleiste die Box "Aktivste News (News system)" aktiviere die nachfolgende Fehlermeldung
Code
Sun, 24 Apr 2016 13:19:18 +0000
Message: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'xxxxxx.news.comments' which is not in SELECT list; this is incompatible with DISTINCT
File: xxxxxxx/wcf/lib/system/database/Database.class.php (231)
PHP version: 7.0.5-1~dotdeb+8.1
WCF version: 2.1.10 (Typhoon)
Request URI: /news/
Referrer:
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0
Information: "<b>sql type:<\/b> wcf\\system\\database\\MySQLDatabase<br \/><b>sql error:<\/b> Expression #1 of ORDER BY clause is not in SELECT list, references column 'xxxxxxx.news.comments' which is not in SELECT list; this is incompatible with DISTINCT<br \/><b>sql error number:<\/b> HY000<br \/><b>sql version:<\/b> 5.7.12-log<br \/><b>sql query:<\/b> SELECT\tDISTINCT news.newsID AS objectID, news.time\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.time > ? AND news.comments > 0\r\t\t\t\tORDER BY news.comments DESC, news.time DESC LIMIT 5<br \/>"
Stacktrace:
#0 xxxxxxx/news/lib/data/news/NewsList.class.php(46): wcf\system\database\Database->prepareStatement('SELECT\tDISTINCT...', 5, 0)
#1 xxxxxxx/news/lib/data/news/MostActiveNewsList.class.php(79): news\data\news\NewsList->readObjectIDs()
#2 xxxxxxx/news/lib/system/dashboard/box/MostActiveNewsDashboardBox.class.php(34): news\data\news\MostActiveNewsList->readObjects()
#3 xxxxxxx/wcf/lib/system/dashboard/DashboardHandler.class.php(71): news\system\dashboard\box\MostActiveNewsDashboardBox->init(Object(wcf\data\dashboard\box\DashboardBox), Object(news\page\CategoryListPage))
#4 xxxxxxx/news/lib/page/CategoryListPage.class.php(147): wcf\system\dashboard\DashboardHandler->loadBoxes('de.wbb-elite.ne...', Object(news\page\CategoryListPage))
#5 xxxxxxx/wcf/lib/page/AbstractPage.class.php(276): news\page\CategoryListPage->assignVariables()
#6 xxxxxxx/wcf/lib/page/AbstractPage.class.php(100): wcf\page\AbstractPage->show()
#7 xxxxxxx/wcf/lib/system/request/Request.class.php(58): wcf\page\AbstractPage->__run()
#8 xxxxxxx/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
#9 xxxxxxx/news/index.php(3): wcf\system\request\RequestHandler->handle('news')
#10 {main}
Alles anzeigen
Ist für mich jetzt nicht ganz so schlimm, ich wollte es nur Testen. Aber falls es ein allgemeiner Fehler ist nur als Info für dich.