Total members Incorrect and wont update!
 

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?

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?

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.

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

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!

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

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

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.

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']);

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

Tried your suggestions. Still no luck! Mysql says those rows are corrupted. I deleted them and I guess I'll have to enter in all 94 manually. I saved the info and was hoping to be able to mass upload them but it wont create the rows and write to the columns. If I create blank ones it writes the info in a matter of seconds. I created 5 new rows and inserted the data through php script and they are counted correctly. That will take some time to create 89 more empty rows since it only lets you create one at a time. almost not worth the trouble!

Let me ask this! Is there anyway to have that code in index.php just grab the last userid! Atleast then I'll have a more accurate count since the userid's are used in sequence.

SELECT userid FROM user ORDER BY userid DESC LIMIT 1

That will grab the highest userid.

I hate to be a pain but I done the following and I know it isnt correct.

In /forums/index.php I changed :

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

to

$numbersmembers=$DB_site->query_first('SELECT userid FROM user ORDER BY userid DESC LIMIT 1');
$numbermembers=number_format($numbersmembers['users']);

What is not correct here?

Change $numbermembers=number_format($numbersmembers['users']);
To $numbermembers=number_format($numbersmembers['userid']); ;)

OK I changed it to:

$numbersmembers=$DB_site->query_first('SELECT userid FROM user ORDER BY userid DESC LIMIT 1');
$numbermembers=number_format($numbersmembers['userid']);

AND I get this:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT userid,username FROM user WHERE userid=
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

Date: Tuesday 22nd of April 2003 02:04:41 AM
Script: http://www.satcetera.com/forums/forums/index.php
Referer: http://satcetera.com/admin.php?s=&op=adminMain

I will pay $50.00 USD to anyone who can give me an answer to this problem. Fast money for a fast solution....I am desperate!

I think there are some compatibility problems with MySQL 4, but I don't really know anything about them, so I can't help you unfortunately.

I didn't think it would be this hard but it has me stumped. All I want is for the forums/index.php to show the last registered users id (userid). Instead of counting the number of rows in the 'user' db! So on my forums home page the "total members" shows the userid of the last registered user.

Well how about $100 USD! Please somebody has to know how to do this!

I'm uploading the index.php! If you can make it display the userid of the last registered user instead of total number of current users, you will be my new best friend and be $100 richer!

Thanks