XF 1.1 recent activity 'server error'

[dieketzer]

some people are getting the generic xf 'server error' page when trying to view recent activity. this began immediately after updating to 1.1b2.
any idea what this is about?

error info:

Zend_Db_Statement_Mysqli_Exception: 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 ')) AND (user.user_state IN ('valid', 'email_confirm_edit')) AND (user.is_banned ' at line 30 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Bunnie, 51 minutes ago

stack trace:

#0 /***/public_html/community/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT????...')
#1 /***/public_html/community/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT????...')
#2 /***/public_html/community/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT????...')
#3 /***/public_html/community/library/XenForo/Model.php(218): Zend_Db_Adapter_Abstract->query('?????SELECT????...', Array, 2)
#4 /***/public_html/community/library/XenForo/Model/NewsFeed.php(273): XenForo_Model->fetchAllKeyed('?????SELECT????...', 'news_feed_id')
#5 /***/public_html/community/library/XenForo/Model/NewsFeed.php(104): XenForo_Model_NewsFeed->getNewsFeedItems(Array, Array)
#6 /***/public_html/community/library/XenForo/ControllerPublic/RecentActivity.php(16): XenForo_Model_NewsFeed->getNewsFeed(Array, 0)
#7 /***/public_html/community/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_RecentActivity->actionIndex()
#8 /***/public_html/community/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /***/public_html/community/index.php(13): XenForo_FrontController->run()
#10 {main}

request state:

array(3) {
  ["url"] => string(48) "http://gotvirtual.net/community/recent-activity/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[Jake Bunce]

Already reported and fixed:

http://xenforo.com/community/threads/server-error-when-viewing-recent-activity.21124/

The fix should be included in the next release.