updated thread count / forum information = post count is zero now ???

[Total666]

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

[Mark.B]

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?

[Total666]

5.6.30 is the PHP version

[Mark.B]

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.

[Total666]

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.

Hello , and thanks for the info , Do you think when I upgrade to VB4 my database will be ok ?

[Mark.B]

Hello , and thanks for the info , Do you think when I upgrade to VB4 my database will be ok ?

There's noothung wrong with your database, otherwise you'd see errors.
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.

[Total666]

I updated to Powered by vBulletin® Version 3.8.11 Beta 3 , the posts / threads are still zero ? Ideas ?

[Mark.B]

I updated to Powered by vBulletin® Version 3.8.11 Beta 3 , the posts / threads are still zero ? Ideas ?

Why a beta? You need to be on the full and final version.

[pet0etie]

did u try the "admincp > maintenance > update counters > update post count" again ?
if u did but the counters stay on zero, i can give u a query to use for updating the posts with one single command

[Total666]

Why a beta? You need to be on the full and final version.

RE-ran that upgrade script and now it is Powered by vBulletin® Version 3.8.11

[Total666]

did u try the "admincp > maintenance > update counters > update post count" again ?
if u did but the counters stay on zero, i can give u a query to use for updating the posts with one single command

I did re-run the "update the ost count " again , posts are still 0 . Script would be great ,thanks .

[pet0etie]

using this sql-statement would help to get the counters up-to-date again :

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

use prefixes to the tables users, post, thread and forum if u use that on your forums

[Total666]

using this sql-statement would help to get the counters up-to-date again :

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

use prefixes to the tables users, post, thread and forum if u use that on your forums

Do I run this in the admin panel ? thanks

[pet0etie]

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

[pet0etie]

just saw one mistake in my query
correct version should be

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

FYI : first query did only update for one user (the one with userid = 95)