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

0 Alerts 0 Inbox after upgrade to 1.1 and server error log

Discussion in 'Troubleshooting and Problems' started by tenants, Nov 23, 2011.

  1. tenants

    tenants Well-Known Member

    I'm seeing this for every user (see attached):

    I always see the 0 alerts and 0 inbox pop up (if they have 0),
    but after hoving over both go away (acting as if the js is in the wrong order, that's a guess)

    << Seen with both FF and chrome (havent tried other browsers)


    I've also got a server error log:
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'surreyfo_xenfo.xf_thread_prefix' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77

    This was an upgrade from 1.0.4
     

    Attached Files:

  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Revert navigation.css. That has fixed this problem for everyone who has reported it:

    Admin CP -> Appearance -> Templates -> navigation.css

    xf_thread_prefix is created during the upgrade to 1.1. That might just be a temporary error during the upgrade. If you can load this page then you know the table exists in which case you can ignore that error in the log:

    Admin CP -> Applications -> Thread Prefixes
     
  3. tenants

    tenants Well-Known Member

    okay, I've updated all the templates.. you were right about the 0 alerts and 0 inbox being due to the out of date navigation template.

    I'm now getting:

    Mysqli prepare error: Unknown column 'forum.find_new' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77

    the error is from visiting "what's new" when not logged in

    uggg, it's a plugin issue..
     
  4. TrevC

    TrevC Well-Known Member

    If anyone is running heavily customised CSS (ours is all served from a single external stylesheet), you only need to update this section:
    Code:
    /* Alert Balloons */
    .navTabs .navLink .itemCount{@property "alertBalloon";font-weight:bold;font-size:9px;color:white;background-color:#e03030;padding:0 2px;border-radius:2px;position:absolute;right:2px;top:-12px;line-height:16px;min-width:12px;_width:12px;text-align:center;text-shadow:none;white-space:nowrap;word-wrap:normal;box-shadow:2px 2px 5px rgba(0,0,0,0.25);height:16px;@property "/alertBalloon";}
    .navTabs .navLink .itemCount .arrow{@property "alertBalloonArrow";border:3px solid transparent;border-top-color:#e03030;border-bottom:1px none black;position:absolute;bottom:-3px;right:4px;line-height:0px;text-shadow:none;_display:none;/* Hide from IE6 */
    width:0px;height:0px;@property "/alertBalloonArrow";}
    .navTabs .navLink .itemCount.Zero{display:none;}
     
    Mr. Wah likes this.
  5. Mr. Wah

    Mr. Wah Member

    This fixed the issue on my site.
     
  6. Temexter

    Temexter Member

    Hello folks, we have loads of these errors in server error log too:
    Code:
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'forum.find_new' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: Unknown Account, A moment ago
    Stack Trace
    #0 /var/www/prteamwork.com/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT thr...')
    #1 /var/www/prteamwork.com/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT thr...')
    #2 /var/www/prteamwork.com/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT thr...')
    #3 /var/www/prteamwork.com/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT thr...', Array, 2)
    #4 /var/www/prteamwork.com/library/XenForo/Model/Thread.php(518): XenForo_Model->fetchAllKeyed('?????SELECT thr...', 'thread_id')
    #5 /var/www/prteamwork.com/library/XenForo/ControllerPublic/FindNew.php(162): XenForo_Model_Thread->getThreads(Array, Array)
    #6 /var/www/prteamwork.com/library/XenForo/ControllerPublic/FindNew.php(35): XenForo_ControllerPublic_FindNew->findNewPosts()
    #7 /var/www/prteamwork.com/library/XenForo/FrontController.php(337): XenForo_ControllerPublic_FindNew->actionPosts()
    #8 /var/www/prteamwork.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /var/www/prteamwork.com/index.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
    ["url"] => string(43) "http://prteamwork.com/find-new/113376/posts"
    ["_GET"] => array(1) {
    ["/find-new/113376/posts"] => string(0) ""
    }
    ["_POST"] => array(0) {
    }
    }
    I'm not familiar with XF CSS system, only file containing "Alert Balloons" is /var/www/prteamwork.com/install/data/templates.xml

    If the fix applies, where should i replace the code?

    We are also pested with other error:
    Code:
    Server Error Log
    Error Info
    ErrorException: Undefined index: forum - library/AVForums/Checkpoint/ControllerPublic/Forum.php:20
    Generated By: atom9CH, 6 minutes ago
    Stack Trace
    #0 /var/www/prteamwork.com/library/AVForums/Checkpoint/ControllerPublic/Forum.php(20): XenForo_Application::handlePhpError(8, 'Undefined index...', '/var/www/prteam...', 20, Array)
    #1 /var/www/prteamwork.com/library/XenForo/FrontController.php(337): AVForums_Checkpoint_ControllerPublic_Forum->actionIndex()
    #2 /var/www/prteamwork.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #3 /var/www/prteamwork.com/index.php(13): XenForo_FrontController->run()
    #4 {main}
    Request State
    array(3) {
    ["url"] => string(29) "http://prteamwork.com/forums/"
    ["_GET"] => array(1) {
    ["/forums/"] => string(0) ""
    }
    ["_POST"] => array(0) {
    }
    }
    Could these be related somehow?

    We are running XenForo 1.2.1.

    Cheers,

    Temexter
     
    Last edited: Apr 22, 2014
  7. borbole

    borbole Well-Known Member


    From reading above, the error with the what 's new section, which you have as well, was caused from a plugin.

    Seeing the second error that you posted, it is caused by a plugin too.

    I think it would be best if you started your own thread about it rather than bumping up an old thread.
     
  8. Temexter

    Temexter Member

    Yep, this sure was a necrobump, failed to notice the timestamps :D

    I'll make a new thread...
     
    borbole likes this.
  9. Temexter

    Temexter Member

    Okay, i made a new thread about the Moderator Checkpoint error to Add-On thread: http://xenforo.com/community/thread...eckpoint-system-paid.55889/page-4#post-759838

    I couldn't find anything new about the other error. Nor do i know what add-on it is related to... I checked that this error is generated when user not signed in clicks "Recent Posts", like earlier stated in this thread. Here's the error once more:
    Code:
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'forum.find_new' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: Unknown Account, 1 minute ago
    Stack Trace
    #0 /var/www/prteamwork.com/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT thr...')
    #1 /var/www/prteamwork.com/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT thr...')
    #2 /var/www/prteamwork.com/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT thr...')
    #3 /var/www/prteamwork.com/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT thr...', Array, 2)
    #4 /var/www/prteamwork.com/library/XenForo/Model/Thread.php(518): XenForo_Model->fetchAllKeyed('?????SELECT thr...', 'thread_id')
    #5 /var/www/prteamwork.com/library/XenForo/ControllerPublic/FindNew.php(162): XenForo_Model_Thread->getThreads(Array, Array)
    #6 /var/www/prteamwork.com/library/XenForo/ControllerPublic/FindNew.php(24): XenForo_ControllerPublic_FindNew->findNewPosts()
    #7 /var/www/prteamwork.com/library/XenForo/FrontController.php(337): XenForo_ControllerPublic_FindNew->actionPosts()
    #8 /var/www/prteamwork.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /var/www/prteamwork.com/index.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
    ["url"] => string(36) "http://prteamwork.com/find-new/posts"
    ["_GET"] => array(1) {
    ["/find-new/posts"] => string(0) ""
    }
    ["_POST"] => array(0) {
    }
    }
    
    I'd appreciate any help/hints very much as these errors make server error log quite unreadable, haven't noticed any anomaly in functionality though.

    Cheers,

    Temexter
     
  10. Temexter

    Temexter Member

    Hmmmm, digged into code and found in /var/www/prteamwork.com/library/XenForo/Model/Thread.php:
    PHP:
    // fetch threads only from forums with find_new = 1
    if (!empty($conditions['find_new']) && isset($fetchOptions['join']) && $fetchOptions['join'] & self::FETCH_FORUM_OPTIONS)
    {
    $sqlConditions[] = 'forum.find_new = 1';
    }
    I just tested and commented the code and no more errors. I'm not so familiar with XF code, so would be nice to know what is this code? The file might be edited, as we had earlier a guy developing our forum and (as usual) now one knows nothing and no documentation done :D
     

Share This Page