MySQL Statement Prepare Error
XF\Db\InvalidQueryException: MySQL statement prepare error [1064]: 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 ') AND `feed`.`visible` = 1 AND `feed`.`feedtype` = 0' at line 1 src/XF/Db/AbstractStatement.php:230
Generated by: Unknown account Apr 17, 2022 at 6:26 AM
Stack trace
SELECT COUNT(*) AS `resultcount` FROM `xf_vw_feed` `feed` WHERE `feed`.`areaid` IN () AND `feed`.`visible` = 1 AND `feed`.`feedtype` = 0
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1064, '42000')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1064, '42000')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/addons/vw/vw/_core/controller/db/xf2.php(251): XF\Db\AbstractAdapter->query('SELECT COUNT(*...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(25): vw_DB_Controller_XF2->query_first_slave('SELECT COUNT(*...')
#6 src/addons/vw/vw/_core/view/content/list/base/vw.php(573): vw_DB_MySQL_Model->select(Array)
#7 src/addons/vw/vw/_core/view/content/list/base/vw.php(47): vw_Content_List_Base_View->do_query(Array, Array)
#8 src/addons/vw/vw/_core/view/ui/feed/vw.php(1102): vw_Content_List_Base_View->get('Feed', Array, Array, Array, Array)
#9 src/addons/vw/vw/_core/view/ui/feed/xf2.php(63): vw_UI_Feed_View->feeds(Array)
#10 src/addons/vw/vw/_core/view/reply/view/vw.php(48): vw_UI_Feed_View_XF2->feeds(Array)
#11 src/addons/vw/vw/_core/view/reply/base/vw.php(134): vw_Reply_View_View->render_type('html')
#12 src/addons/vw/vw/_core/view/reply/stack/vw.php(45): vw_Reply_base_View->render('html')
#13 src/addons/vw/vw/XF/Mvc/View.php(25): vw_Reply_Stack_View->render('html')
#14 src/XF/Mvc/Renderer/AbstractRenderer.php(91): vw\vw\XF\Mvc\View->renderHtml()
#15 src/XF/Mvc/Renderer/Html.php(47): XF\Mvc\Renderer\AbstractRenderer->renderViewObject('vw\\vw:Wiki', 'public:vw_gener...', Array)
#16 src/XF/Mvc/Dispatcher.php(460): XF\Mvc\Renderer\Html->renderView('vw\\vw:Wiki', 'public:vw_gener...', Array)
#17 src/XF/Mvc/Dispatcher.php(442): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#18 src/XF/Mvc/Dispatcher.php(402): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#19 src/XF/Mvc/Dispatcher.php(60): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'html')
#20 src/XF/App.php(2352): XF\Mvc\Dispatcher->run()
#21 src/XF.php(524): XF\App->run()
#22 index.php(20): XF::runApp('XF\\Pub\\App')
#23 {main}
Request state
array(4) {
["url"] => string(38) "/forums/wiki-feed/personal?action=list"
["referrer"] => bool(false)
["_GET"] => array(1) {
["action"] => string(4) "list"
}
["_POST"] => array(0) {
}
}