Total members Incorrect and wont update!

[SatMan2028]

About a month ago I deleted 37 inactive users. The total members never changed which was bad enough. Well then the counter stayed at the same number. The last 94 members are not counted. I then backed up the database and restored it from the backup and my counter is counting new members again but does not reflect the 94 members that fell into the "MEMBERS BLACKHOLE" ..LOL

My question is can you manually reset the members counter to a correct total?

[N9ne]

So you want it to show how many members there are in the database currently? Or you want to show how many members have registered at your forum so far?

[SatMan2028]

Just how many are in the database! I really dont want it to count the inactive members that I deleted but its only 37 that were deleted. I just want to add the 94 that have registered while it was not working.

Hope that helps and sorry for the delay in response.

[N9ne]

Have you modified index.php in anyway? Default vbulletin code in index.php does what you want. What version are you running?

[SatMan2028]

Version 2.2.9

No I have not modified it at all! Everything was fine until I deleted the inactive members. I even verified through phpmyadmin and the user tables are correct but when the $numbersmembers query in index.php does not count those 94 members.

I'm at a loss! Strangest thing ever!

[N9ne]

I think the query counts the number of rows...but i'm not sure, so have you verified that that's correct?

[SatMan2028]

Yes it does count the number of rows! my php database is whats causing the trouble all along. I just discovered it a few minutes ago. The rows are there but it is not counting them correctly. I have saved the info for the rows in question into a text file. If I can figure out how to add 94 empty rows, I have a script to insert the info into the empty rows. I can add rows one at a time but I know there's an easier way. Maybe you know an easier way! Thanks

[N9ne]

This is very odd, what version of MySQL and PHP are you using?

Please post the relevent lines in index.php pertaining to the # of posts on forumhome too.

[SatMan2028]

General server information
cPanel Build 6.4.0-RELEASE #15
Operating system Linux
Apache version 1.3.27 (Unix)
PERL version 5.006001
Path to PERL /usr/bin/perl
Installed Perl Modules Click to View
PHP version 4.3.1
MySQL version 4.0.12

$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbermembers=number_format($numbersmembers['users']);

[N9ne]

Hmm, I really don't understand this, I run the same specs as that ( I think I have build 16 of cPanel though) and I don't have the problem. Try uploading repair.php into your admin folder from the extras folder in the vbulletin files. Run the file.

If that doesn't work, try this query instead of the default vB one:

$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users FROM user');