Code:
XenForo_Exception: Database Error: SELECT SQL_CALC_FOUND_ROWS `o`.`pageid` AS `itemid` FROM `vw_chapterorder` `o` LEFT JOIN `vw_route` `i` ON (`o`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1) LEFT JOIN `vw_page` `page` ON (`page`.`pageid` = `o`.`pageid`) WHERE `o`.`parentid` IN (441) AND `o`.`pageid` <> 441 AND `page`.`areaid` IN (0,2,6,17,4,7,8,5,16,3,9,10,11,12,13,14,15,18) AND `page`.`visible` = 1 ORDER BY ASC, `i`.`parentprefixid` ASC LIMIT 0,200 Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ASC, `i`.`parentprefixid` ASC LIMIT 0,200' at line 2 - vault/core/controller/db/xf.php:187
Generated By: Bajeda, 1 minute ago
Stack Trace
#0 /public_html/vault/core/controller/db/xf.php(226): vw_DB_Controller_XF->throw_error(Object(Zend_Db_Statement_Mysqli_Exception), 'SELECT SQL_CALC...')
#1 /public_html/vault/core/model/db/mysql/vw.php(27): vw_DB_Controller_XF->query_read_slave('SELECT SQL_CALC...')
#2 /public_html/vault/core/view/content/list/base/vw.php(466): vw_DB_MySQL_Model->select(Array)
#3 /public_html/vault/core/view/content/list/book/vw.php(48): vw_Content_List_Base_View->do_query(Array, Array)
#4 /public_html/vault/core/view/ui/book/vw.php(344): vw_Content_List_Book_View->get('Page', Array, Array, Array)
#5 /public_html/vault/core/controller/ui/book/vw.php(981): vw_UI_Book_View->book_list(Object(vw_UI_Book_Controller))
#6 /public_html/vault/core/controller/ui/book/vw.php(65): vw_UI_Book_Controller->book_list()
#7 /public_html/vault/core/controller/ui/stack/vw.php(276): vw_UI_Book_Controller->execute()
#8 /public_html/library/vw/XenForo/ControllerPublic/Wiki.php(70): vw_UI_Stack_Controller->execute()
#9 /public_html/library/XenForo/FrontController.php(351): vw_XenForo_ControllerPublic_Wiki->actionIndex()
#10 /public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /public_html/index.php(13): XenForo_FrontController->run()
#12 {main}
Request State
array(3) {
["url"] => string(56) "https://forum.com/wiki/?title=Book:Faq&do=contents"
["_GET"] => array(2) {
["title"] => string(8) "Book:Faq"
["do"] => string(8) "contents"
}
["_POST"] => array(7) {
["filter"] => string(1) "0"
["sort"] => string(5) "title"
["sortorder"] => string(3) "asc"
["_xfToken"] => string(8) "********"
["do"] => string(8) "contents"
["title"] => string(8) "Book:Faq"
["bb2_screener_"] => string(22) "1499786267 xxx"
}
}