Whats news / New wiki comments traceback
Trying to reach /whats-new/wiki-comments/ on XF2 install gives error, (admin shows 2 errors even)
Err1:
Code:
ErrorException: [E_NOTICE] Undefined index: c src/addons/vw/vw/Handler/FindNew/Comment.php:144
#0 src/addons/vw/vw/Handler/FindNew/Comment.php(144): XF::handlePhpError(8, '[E_NOTICE] Unde...', '/home/nginx/dom...', 144, Array)
#1 src/XF/ControllerPlugin/FindNew.php(63): vw\vw\Handler\FindNew\Comment->getResultIds(Array, '100')
#2 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(72): XF\ControllerPlugin\FindNew->runFindNewSearch(Object(vw\vw\Handler\FindNew\Comment), Array)
#3 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(28): XF\Pub\Controller\AbstractWhatsNewFindType->triggerNewFindNewAction(Object(vw\vw\Handler\FindNew\Comment), Array)
#4 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\AbstractWhatsNewFindType->actionIndex(Object(XF\Mvc\ParameterBag))
#5 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('vw\\vw:WhatsNew\\...', 'Index', Object(XF\Mvc\RouteMatch), Object(vw\vw\Pub\Controller\WhatsNew\Comments), NULL)
#6 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(vw\vw\Pub\Controller\WhatsNew\Comments), NULL)
#7 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#8 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#9 src/XF.php(391): XF\App->run()
#10 index.php(20): XF::runApp('XF\\Pub\\App')
#11 {main}
array(4) {
["url"] => string(25) "/whats-new/wiki-comments/"
["referrer"] => string(60) "..."
["_GET"] => array(1) {
["/whats-new/wiki-comments/"] => string(0) ""
}
["_POST"] => array(0) {
}
Err2:
Code:
XF\Db\InvalidQueryException: MySQL statement prepare error [1064]: 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 '< `noderead`.`readtime`) WHERE `discussion`.`visible` = 1 AND `page`.`areaid`' at line 3 src/XF/Db/AbstractStatement.php:228
SELECT `discussion`.`discussionid` AS `itemid`,`discussion`.`contenttypeid`,`discussion`.`contentid` FROM `vw_discussion` `discussion` LEFT JOIN `vw_page` `page` ON (`discussion`.`contentid` = `page`.`pageid` AND `discussion`.`contenttypeid` = 1)
LEFT JOIN `vw_markread` `markread` ON (`discussion`.`discussionid` = `markread`.`itemid` AND 5 = `markread`.`itemtypeid` AND `markread`.`userid` = 16614 AND `discussion`.`lastupdate` < `markread`.`readtime`)
LEFT JOIN `vw_noderead` `noderead` ON (`page`.`areaid` = `noderead`.`nodeid` AND 1 = `noderead`.`nodetypeid` AND `noderead`.`userid` = 16614 AND < `noderead`.`readtime`) WHERE `discussion`.`visible` = 1 AND `page`.`areaid` IN (0,2,3) AND `markread`.`itemid` IS NULL AND `noderead`.`nodeid` IS NULL ORDER BY `discussion`.`lastupdate` DESC LIMIT 100
------------
#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(148): XF\Db\AbstractAdapter->query('SELECT `discuss...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(25): vw_DB_Controller_XF2->query_read('SELECT `discuss...')
#6 src/addons/vw/vw/Handler/FindNew/Comment.php(167): vw_DB_MySQL_Model->select(Array)
#7 src/XF/ControllerPlugin/FindNew.php(63): vw\vw\Handler\FindNew\Comment->getResultIds(Array, '100')
#8 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(72): XF\ControllerPlugin\FindNew->runFindNewSearch(Object(vw\vw\Handler\FindNew\Comment), Array)
#9 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(28): XF\Pub\Controller\AbstractWhatsNewFindType->triggerNewFindNewAction(Object(vw\vw\Handler\FindNew\Comment), Array)
#10 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\AbstractWhatsNewFindType->actionIndex(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('vw\\vw:WhatsNew\\...', 'Index', Object(XF\Mvc\RouteMatch), Object(vw\vw\Pub\Controller\WhatsNew\Comments), NULL)
#12 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(vw\vw\Pub\Controller\WhatsNew\Comments), NULL)
#13 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#15 src/XF.php(391): XF\App->run()
#16 index.php(20): XF::runApp('XF\\Pub\\App')
#17 {main}
array(4) {
["url"] => string(25) "/whats-new/wiki-comments/"
["referrer"] => string(60) "..."
["_GET"] => array(1) {
["/whats-new/wiki-comments/"] => string(0) ""
}
["_POST"] => array(0) {
}
}