Issue: You have an error in your SQL syntax AbstractStatement SELECT COUNT(`commentid`)

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 `visible` IN (1) AND dateline <' at line 1 src/XF/Db/AbstractStatement.php:228
Generated by: Unknown account Mar 15, 2020 at 2:55 PM
Stack trace
SELECT COUNT(`commentid`) AS `counter` FROM `vw_comment` WHERE discussionid = AND `visible` IN (1) AND dateline <
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1064, '42000')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1064, '42000')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/addons/vw/vw/_core/controller/db/xf2.php(203): XF\Db\AbstractAdapter->query('SELECT COUNT(`...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(25): vw_DB_Controller_XF2->query_first('SELECT COUNT(`...')
#6 src/addons/vw/vw/_core/controller/ui/discussion/xf0.php(207): vw_DB_MySQL_Model->select(Array)
#7 src/addons/vw/vw/_core/controller/proxy/like/comment/vw.php(30): vw_UI_Discussion_Controller_XF0->get_comment_number()
#8 src/addons/vw/vw/_core/controller/proxy/like/vw.php(74): vw_Proxy_Like_Comment_Controller->setup(Object(vw_Proxy_Like_Controller_XF2))
#9 src/addons/vw/vw/_core/controller/proxy/like/vw.php(60): vw_Proxy_Like_Controller->delegate('Comment')
#10 src/addons/vw/vw/_core/controller/proxy/like/vw.php(100): vw_Proxy_Like_Controller->setup(Object(vw_UI_Stack_Controller), Array, 'Comment', 'commentid')
#11 src/addons/vw/vw/_core/controller/ui/discussion/vw.php(2770): vw_Proxy_Like_Controller->likes(Object(vw_UI_Stack_Controller), Array, 'Comment', 'commentid')
#12 src/addons/vw/vw/_core/controller/ui/discussion/vw.php(160): vw_UI_Discussion_Controller->likes()
#13 src/addons/vw/vw/_core/controller/ui/discussion/xf0.php(61): vw_UI_Discussion_Controller->execute()
#14 src/addons/vw/vw/_core/controller/ui/discussion/xf2.php(28): vw_UI_Discussion_Controller_XF0->execute()
#15 src/addons/vw/vw/_core/controller/ui/page/vw.php(889): vw_UI_Discussion_Controller_XF2->execute()
#16 src/addons/vw/vw/_core/controller/ui/page/vw.php(841): vw_UI_Page_Controller->do_comments(true)
#17 src/addons/vw/vw/_core/controller/ui/page/vw.php(215): vw_UI_Page_Controller->comments()
#18 src/addons/vw/vw/_core/controller/ui/stack/vw.php(294): vw_UI_Page_Controller->execute()
#19 src/addons/vw/vw/Pub/Controller/Wiki/Wiki.php(80): vw_UI_Stack_Controller->execute()
#20 src/addons/vw/vw/Mvc/Dispatcher.php(30): vw\vw\Pub\Controller\Wiki\Wiki->_actionIndex(Object(XF\Mvc\ParameterBag))
#21 src/addons/vw/vw/Pub/Controller/Wiki/AbstractController.php(26): vw\vw\Mvc\Dispatcher::dispatch(Object(vw\vw\Pub\Controlle r\Wiki\Wiki), 'index', Object(XF\Mvc\ParameterBag))
#22 src/XF/Mvc/Dispatcher.php(350): vw\vw\Pub\Controller\Wiki\AbstractController->actionIndex(Object(XF\Mvc\ParameterBag))
#23 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('\\vw\\vw\\Pub\\Cont...', 'Index', Object(XF\Mvc\RouteMatch), Object(vw\vw\Pub\Controller\Wiki\Wiki), NULL)
#24 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(vw\vw\Pub\Controller\Wiki\Wiki), NULL)
#25 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#26 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#27 src/XF.php(391): XF\App->run()
#28 index.php(20): XF::runApp('XF\\Pub\\App')
#29 {main}
Request state
array(4) {
["url"] => string(71) "/Folklore/Rebecca-Lidia-Fourtuna?do=comments&action=likes&commentid=153"
["referrer"] => bool(false)
["_GET"] => array(4) {
["/Folklore/Rebecca-Lidia-Fourtuna"] => string(0) ""
["do"] => string(8) "comments"
["action"] => string(5) "likes"
["commentid"] => string(3) "153"
}
["_POST"] => array(0) {
}
}