I was missing some posts in the forum , so I updated thread count / forum information = post count is zero now ??? any ideas ? 3.84 patch level 2 .. thanks
updated thread count / forum information = post count is zero now ???
Collapse
X
-
Should be noted that 3.8.4 is old and unsupported and won't work with latest versions of php.
With that in mind...what is the php version reported in the admincp?MARK.B
vBulletin Support
------------
My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
My Unofficial vBulletin Cloud Demo: https://www.adminammo.com -
3.8.4 won't work properly on that.
You will need to either upgrade vBulletin (3.8.11), which would involve you buying a vB4 license upgrade ($149) to enable you to gain access to the latest versions of vB3.
OR downgrade php to 5.3.
Note that php 5.3 is end of life and unsupported. The license upgrade is your best bet.MARK.B
vBulletin Support
------------
My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
My Unofficial vBulletin Cloud Demo: https://www.adminammo.comComment
-
3.8.4 won't work properly on that.
You will need to either upgrade vBulletin (3.8.11), which would involve you buying a vB4 license upgrade ($149) to enable you to gain access to the latest versions of vB3.
OR downgrade php to 5.3.
Note that php 5.3 is end of life and unsupported. The license upgrade is your best bet.
Comment
-
Most likely there's some php code in use that is not compatible with the version of php you are running. If so, this will have been updated in 3.8.11.
It is impossible to say for certain, however 3.8.4 is definitely NOT compatible with php 5.6, so if you don't upgrade you will likely see other problems over time.MARK.B
vBulletin Support
------------
My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
My Unofficial vBulletin Cloud Demo: https://www.adminammo.comComment
-
MARK.B
vBulletin Support
------------
My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
My Unofficial vBulletin Cloud Demo: https://www.adminammo.comComment
-
I did re-run the "update the ost count " again , posts are still 0 . Script would be great ,thanks .Comment
-
using this sql-statement would help to get the counters up-to-date again :
Code:update user as U set U.posts = ( SELECT count(*) FROM post as A, thread as B, forum as C WHERE A.userid = U.userid and A.visible = 1 and A.threadid = B.threadid and B.visible = 1 and B.forumid = C.forumid and (C.options & 4096) ) where U.userid = 95
Comment
-
using this sql-statement would help to get the counters up-to-date again :
Code:update user as U set U.posts = ( SELECT count(*) FROM post as A, thread as B, forum as C WHERE A.userid = U.userid and A.visible = 1 and A.threadid = B.threadid and B.visible = 1 and B.forumid = C.forumid and (C.options & 4096) ) where U.userid = 95
Do I run this in the admin panel ? thanksComment
-
u can run this in the admin panel but than u need access to execute sql-commands (which isn't allowed to everyone) ... u need special rights in the config.php-file to do this
other possibility is to do it by using phpmyadmin-module (if available) on your hosting-softwareComment
-
just saw one mistake in my query
correct version should be
Code:update user as U set U.posts = ( SELECT count(*) FROM post as A, thread as B, forum as C WHERE A.userid = U.userid and A.visible = 1 and A.threadid = B.threadid and B.visible = 1 and B.forumid = C.forumid and (C.options & 4096) )
Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment