Issue: [4.1.0 RC3 B002] Three Errors Experienced

Several errors today, after updating to RC3 Build 002:

Error #1:



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 '< `noderead`.`readtime`) WHERE `discussion`.`visible` = 1 AND `page`.`areaid`' at line 3 src/XF/Db/AbstractStatement.php:228

Generated by: Eno May 13, 2020 at 10:18 AM

Stack trace

SELECT `discussion`.`discussionid` AS `itemid`,`discussion`.`contenttypeid`,`discussion`.`conte ntid` 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` = 5156 AND `discussion`.`lastupdate` < `markread`.`readtime`)
LEFT JOIN `vw_noderead` `noderead` ON (`page`.`areaid` = `noderead`.`nodeid` AND 1 = `noderead`.`nodetypeid` AND `noderead`.`userid` = 5156 AND < `noderead`.`readtime`) WHERE `discussion`.`visible` = 1 AND `page`.`areaid` IN (0,2,5) AND `markread`.`itemid` IS NULL AND `noderead`.`nodeid` IS NULL ORDER BY `discussion`.`lastupdate` DESC LIMIT 200
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException()
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException()
#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()
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(25): vw_DB_Controller_XF2->query_read()
#6 src/addons/vw/vw/Handler/FindNew/Comment.php(167): vw_DB_MySQL_Model->select()
#7 src/XF/ControllerPlugin/FindNew.php(63): vw\vw\Handler\FindNew\Comment->getResultIds()
#8 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(72): XF\ControllerPlugin\FindNew->runFindNewSearch()
#9 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(28): XF\Pub\Controller\AbstractWhatsNewFindType->triggerNewFindNewAction()
#10 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\AbstractWhatsNewFindType->actionIndex()
#11 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass()
#12 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch()
#13 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop()
#14 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#15 src/XF.php(391): XF\App->run()
#16 index.php(20): XF::runApp()
#17 {main}

Request state

array(4) {
["url"] => string(32) "/forums/whats-new/wiki-comments/"
["referrer"] => string(57) "https://www.500eboard.co/forums/whats-new/latest-activity"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}





Error #2:



ErrorException: [E_NOTICE] Trying to access array offset on value of type null src/addons/vw/vw/Handler/FindNew/Comment.php:144

Generated by: Eno May 13, 2020 at 10:18 AM

Stack trace

#0 src/addons/vw/vw/Handler/FindNew/Comment.php(144): XF::handlePhpError()
#1 src/XF/ControllerPlugin/FindNew.php(63): vw\vw\Handler\FindNew\Comment->getResultIds()
#2 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(72): XF\ControllerPlugin\FindNew->runFindNewSearch()
#3 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(28): XF\Pub\Controller\AbstractWhatsNewFindType->triggerNewFindNewAction()
#4 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\AbstractWhatsNewFindType->actionIndex()
#5 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass()
#6 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch()
#7 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop()
#8 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#9 src/XF.php(391): XF\App->run()
#10 index.php(20): XF::runApp()
#11 {main}

Request state

array(4) {
["url"] => string(32) "/forums/whats-new/wiki-comments/"
["referrer"] => string(57) "https://www.500eboard.co/forums/whats-new/latest-activity"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}




Error #3:



ErrorException: [E_NOTICE] Undefined index: c src/addons/vw/vw/Handler/FindNew/Comment.php:144

Generated by: Eno May 13, 2020 at 10:18 AM

Stack trace

#0 src/addons/vw/vw/Handler/FindNew/Comment.php(144): XF::handlePhpError()
#1 src/XF/ControllerPlugin/FindNew.php(63): vw\vw\Handler\FindNew\Comment->getResultIds()
#2 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(72): XF\ControllerPlugin\FindNew->runFindNewSearch()
#3 src/XF/Pub/Controller/AbstractWhatsNewFindType.php(28): XF\Pub\Controller\AbstractWhatsNewFindType->triggerNewFindNewAction()
#4 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\AbstractWhatsNewFindType->actionIndex()
#5 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass()
#6 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch()
#7 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop()
#8 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#9 src/XF.php(391): XF\App->run()
#10 index.php(20): XF::runApp()
#11 {main}

Request state

array(4) {
["url"] => string(32) "/forums/whats-new/wiki-comments/"
["referrer"] => string(57) "https://www.500eboard.co/forums/whats-new/latest-activity"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

Delete