1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 recent activity 'server error'

Discussion in 'Troubleshooting and Problems' started by dieketzer, Oct 15, 2011.

  1. dieketzer

    dieketzer Well-Known Member

    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:
    Code:
    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:
    Code:
    #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:
    Code:
    array(3) {
      ["url"] => string(48) "http://gotvirtual.net/community/recent-activity/"
      ["_GET"] => array(0) {
      }
      ["_POST"] => array(0) {
      }
    }
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    dieketzer likes this.

Share This Page