Hallo,
ich wollte eben eine Box sortieren nach: "Titel" "aufsteigend nach", doch sobald ich auf Absenden gehe, erscheint folgende Fehlermeldung:
PHP
Error Message:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'title' in 'ORDER BY'
Error Type:
PDOException (42S22)
*/lib/system/database/Database.class.php:331
Template Context:
$this->foreachVars['a6026ac494f5ed0c175590781b230a43e039c3c3']['item'] = $this->v['box'] ?? null;
if ((is_countable($_foreach_a6026ac494f5ed0c175590781b230a43e039c3c3) && count($_foreach_a6026ac494f5ed0c175590781b230a43e039c3c3) > 0) || (!is_countable($_foreach_a6026ac494f5ed0c175590781b230a43e039c3c3) && $_foreach_a6026ac494f5ed0c175590781b230a43e039c3c3)) {
foreach ($_foreach_a6026ac494f5ed0c175590781b230a43e039c3c3 as $this->v['box']) {
?>
====> <?=$this->v['box']->render();?>
<?php }
unset($this->v['box']);$this->v['box'] = $this->foreachVars['a6026ac494f5ed0c175590781b230a43e039c3c3']['item'];
unset($this->foreachVars['a6026ac494f5ed0c175590781b230a43e039c3c3']);
} ?>
</div>
</div>
Stack Trace
#0 PDO->prepare('SELECT tracked_visit.visitTime,article.cumulativeLikes AS cumulativeLikes, like_object.cachedReactions, article.* FROM easyrating1_article article LEFT JOIN wcf1_tracked_visit tracked_visit ON tracked_visit.objectTypeID = 1298 AND tracked_visit.objectID = article.articleID AND tracked_visit.userID = 1 LEFT JOIN wcf1_like_object like_object ON like_object.objectTypeID = 1306 AND like_object.objectID = article.articleID WHERE EXISTS ( SELECT * FROM easyrating1_article_to_category article_category WHERE article_category.articleID = article.articleID AND article_category.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) AND EXISTS ( SELECT * FROM easyrating1_article_to_category articleToCategory WHERE articleToCategory.articleID = article.articleID AND articleToCategory.categoryID IN (?) ) ORDER BY title ASC, article.articleID ASC LIMIT 999 -- \'/rating/category/268-meine-spiele-f%C3%BCr-die-playstation/\'')
*/lib/system/database/Database.class.php:331
#1 wcf\system\database\Database->prepareStatement('SELECT tracked_visit.visitTime,article.cumulativeLikes AS cumulativeLikes, like_object.cachedReactions, article.* FROM easyrating1_article article LEFT JOIN wcf1_tracked_visit tracked_visit ON tracked_visit.objectTypeID = 1298 AND tracked_visit.objectID = article.articleID AND tracked_visit.userID = 1 LEFT JOIN wcf1_like_object like_object ON like_object.objectTypeID = 1306 AND like_object.objectID = article.articleID WHERE EXISTS ( SELECT * FROM easyrating1_article_to_category article_category WHERE article_category.articleID = article.articleID AND article_category.categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) AND EXISTS ( SELECT * FROM easyrating1_article_to_category articleToCategory WHERE articleToCategory.articleID = article.articleID AND articleToCategory.categoryID IN (?) ) ORDER BY title ASC, article.articleID ASC LIMIT 999', 999, 0)
*/lib/data/DatabaseObjectList.class.php:202
#2 wcf\data\DatabaseObjectList->readObjects()
*/rating/lib/data/article/ViewableArticleList.class.php:87
#3 easyrating\data\article\ViewableArticleList->readObjects()
*/lib/system/box/AbstractDatabaseObjectListBoxController.class.php:371
#4 wcf\system\box\AbstractDatabaseObjectListBoxController->readObjects()
*/rating/lib/system/box/ArticleListBoxController.class.php:122
#5 easyrating\system\box\ArticleListBoxController->readObjects()
*/lib/system/box/AbstractDatabaseObjectListBoxController.class.php:337
#6 wcf\system\box\AbstractDatabaseObjectListBoxController->loadContent()
*/lib/system/box/AbstractDatabaseObjectListBoxController.class.php:303
#7 wcf\system\box\AbstractDatabaseObjectListBoxController->hasContent()
*/rating/lib/system/box/ArticleListBoxController.class.php:86
#8 easyrating\system\box\ArticleListBoxController->hasContent()
*/lib/data/box/Box.class.php:332
#9 wcf\data\box\Box->hasContent()
*/lib/data/box/Box.class.php:313
#10 wcf\data\box\Box->render()
*/templates/compiled/7_wcf_1___boxxerTabsBox.php:70
#11 include('*/templates/compiled/7_wcf_1___boxxerTabsBox.php')
*/lib/system/template/TemplateEngine.class.php:458
#12 wcf\system\template\TemplateEngine->display('__boxxerTabsBox', 'wcf', false)
*/lib/system/template/TemplateEngine.class.php:711
#13 wcf\system\template\TemplateEngine->fetch('__boxxerTabsBox', 'wcf', [ box => , hideEmptyColumns => , columns => , boxes => , uniqueID => ], true)
*/lib/system/box/BoxxerColumnsBoxController.class.php:150
#14 wcf\system\box\BoxxerColumnsBoxController->loadContent()
*/lib/system/box/AbstractBoxController.class.php:55
#15 wcf\system\box\AbstractBoxController->getContent()
*/lib/system/box/AbstractBoxController.class.php:68
#16 wcf\system\box\AbstractBoxController->hasContent()
*/lib/data/box/Box.class.php:332
#17 wcf\data\box\Box->hasContent()
*/lib/data/box/Box.class.php:313
#18 wcf\data\box\Box->render()
*/templates/compiled/7_wcf_1___boxxerTabsBox.php:70
#19 include('*/templates/compiled/7_wcf_1___boxxerTabsBox.php')
*/lib/system/template/TemplateEngine.class.php:458
#20 wcf\system\template\TemplateEngine->display('__boxxerTabsBox', 'wcf', false)
*/lib/system/template/TemplateEngine.class.php:711
#21 wcf\system\template\TemplateEngine->fetch('__boxxerTabsBox', 'wcf', [ box => , hideEmptyColumns => , columns => , boxes => , uniqueID => ], true)
*/lib/system/box/BoxxerColumnsBoxController.class.php:150
#22 wcf\system\box\BoxxerColumnsBoxController->loadContent()
*/lib/system/box/AbstractBoxController.class.php:55
#23 wcf\system\box\AbstractBoxController->getContent()
*/lib/system/box/AbstractBoxController.class.php:68
#24 wcf\system\box\AbstractBoxController->hasContent()
*/lib/data/box/Box.class.php:332
#25 wcf\data\box\Box->hasContent()
*/lib/data/box/Box.class.php:313
#26 wcf\data\box\Box->render()
*/templates/compiled/7_easyrating_1_category.php:1858
#27 include('*/templates/compiled/7_easyrating_1_category.php')
*/lib/system/template/TemplateEngine.class.php:458
#28 wcf\system\template\TemplateEngine->display('category', 'easyrating')
*/lib/page/AbstractPage.class.php:372
#29 wcf\page\AbstractPage->show()
*/lib/page/AbstractPage.class.php:124
#30 wcf\page\AbstractPage->__run()
*/lib/system/request/Request.class.php:50
#32 wcf\http\Pipeline->process(Laminas\Diactoros\ServerRequest, wcf\http\RequestHandlerMiddleware)
*/lib/system/request/RequestHandler.class.php:161
#33 wcf\system\request\RequestHandler->handle('easyrating')
*/rating/index.php:11
Alles anzeigen