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

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
 

Attachments

  • inboxalerts.webp
    inboxalerts.webp
    13.9 KB · Views: 15
Sort by date Sort by votes
tenants said:
I always see the 0 alerts and 0 inbox pop up (if they have 0)
Click to expand...

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

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

tenants said:
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
Click to expand...

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
 
Upvote 0 Downvote
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..
 
Upvote 0 Downvote
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;}
 
Upvote 0 Downvote
TrevC said:
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;}
Click to expand...

This fixed the issue on my site.
 
Upvote 0 Downvote
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:
Upvote 0 Downvote
Temexter said:
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
Click to expand...


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.
 
Upvote 0 Downvote
borbole said:
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.
Click to expand...
Yep, this sure was a necrobump, failed to notice the timestamps :D

I'll make a new thread...
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

jb9826
  • Question Question
XF 1.5 Batch Update Threads Timeout
Replies
0
Views
316
jb9826
jb9826
Zardoz43
  • Question Question
After last system update - the forum SEARCH feature is GARBAGE - did up I mess up? I just did the Automated system upgrade to
Replies
3
Views
501
Zardoz43
Zardoz43
Erin Nicole
  • Question Question
XF 2.2 Moved from a VPS to shared hosting and the server errors will not stop.
Replies
4
Views
802
Erin Nicole
Erin Nicole
Cethlenn
  • Question Question
XF 2.2 Registration error seen after site move and upgrade.
Replies
10
Views
1K
Mike
Mike
BassMan
  • Solved
XF 2.2 MySQL query error [126]: xf_search_index.MYI is corrupt; try to repair it
Replies
4
Views
662
BassMan
BassMan
Top Bottom