Code:
XenForo_Exception: Database Error: SELECT `page`.`pageid` AS `itemid`,`page`.`dateline` FROM `vw_page` `page` LEFT JOIN `vw_chapter` `is_chapter` ON (`page`.`pageid` = `is_chapter`.`pageid`) WHERE `page`.`visible` = 1 AND `page`.`dateline` <= 1498162899 AND 1498162837 < `page`.`dateline` AND `page`.`areaid` IN (0,2,3,6,7,8,9,10) AND `is_chapter`.`itembookid` IN () ORDER BY `page`.`dateline` DESC Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY `page`.`dateline` DESC' at line 1 - vault/core/controller/db/xf.php:187
Code:
#0 /home/community/vault/core/controller/db/xf.php(203): vw_DB_Controller_XF->throw_error(Object(Zend_Db_Statement_Mysqli_Exception), 'SELECT `page`.`...')
#1 /home/community/vault/core/model/db/mysql/vw.php(27): vw_DB_Controller_XF->query_read('SELECT `page`.`...')
#2 /home/community/vault/core/controller/ui/activity/page/vw.php(64): vw_DB_MySQL_Model->select(Array)
#3 /home/community/vault/core/controller/ui/activity/vw.php(107): vw_UI_Activity_Page_Controller->get(Object(vw_UI_Activity_Controller), Array, 1498162899, 1498162837)
#4 /home/community/vault/core/controller/ui/activity/vw.php(67): vw_UI_Activity_Controller->get_results(Array, 1498162899, 1498162837)
#5 /home/community/vault/core/controller/ui/ajax/feed/vw.php(107): vw_UI_Activity_Controller->get_count(Array, 1498162899, 1498162837)
#6 /home/community/library/vw/XenForo/ControllerPublic/Wiki/Ajax.php(50): vw_UI_AJAX_Feed_Controller->execute()
#7 /home/community/library/XenForo/FrontController.php(351): vw_XenForo_ControllerPublic_Wiki_Ajax->actionIndex()
#8 /home/community/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/community/index.php(13): XenForo_FrontController->run()
#10 {main}
Here is the request state just in case:
Code:
array(3) {
["url"] => string(59) "http://community.adeptgamer.com/index.php?wiki-ajax/&c=feed"
["_GET"] => array(2) {
["wiki-ajax/"] => string(0) ""
["c"] => string(4) "feed"
}
["_POST"] => array(8) {
["ajax"] => int(1)
["pageid"] => string(2) "77"
["countonly"] => string(1) "1"
["uppertime"] => string(1) "0"
["lowertime"] => string(10) "1498162837"
["filter"] => string(0) ""
["_xfToken"] => string(8) "********"
["c"] => string(4) "feed"
}
}