• 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

tenants

Well-known member
#1
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

Jake Bunce

XenForo moderator
Staff member
#2
I always see the 0 alerts and 0 inbox pop up (if they have 0)
Revert navigation.css. That has fixed this problem for everyone who has reported it:

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

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
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
 

tenants

Well-known member
#3
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..
 

TrevC

Well-known member
#4
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;}
 
#5
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;}
This fixed the issue on my site.
 
#6
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:

borbole

Well-known member
#7
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

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
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.
Yep, this sure was a necrobump, failed to notice the timestamps :D

I'll make a new thread...
 
#9
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
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