Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Removed USER (Bountiful MYSQL errors in functions.php)

[Samuel]

A customer of mine removed a very large username from their vbulletin and now all of their posts on the board are kicking back functions.php errors.

Anyone run into this before?

[The Prohacker]

No.. Whats the error exactly... Maybe we can tell you how to fix it...

You might try updating all the counters...

[Samuel]

Hrmm didnt think of the counters, thanks for that, trying it now.

The error is specifically:

User was registered
Had many posts
Was removed from the board (The user)
Now their posts have this error on all of them

PHP Code:

mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mycustomer/public_html/forums/admin/functions.php on line 93  
  
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/mycustomer/public_html/forums/admin/functions.php on line 97  
  
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mycustomer/public_html/forums/admin/functions.php 


[The Prohacker]

How did they remove the user?

From phpMyAdmin? Or from the Admin CP?

What vB version and PHP version?

[Samuel]

2.2.5 and it was from the CP

It was just remove user the admin panel.

PHP 4.2.2

[The Prohacker]

PHP 4.2.x has a major problem with vB 2.2.5, you would either need to apply the 4.2.x vB patch to it, or upgrade to 2.2.6

[Samuel]

Powered by: vBulletin Version 2.2.6


Sorry, my mistake

Updating the counters didn't help.

Repairing the database through WHM root didn't help.

Any other ideas?

Thanks for the replies so far.

[The Prohacker]

Hmm.. Damn, just couldn't make it easy huh??

Ok.. Try uploading repair.php from the extras dir in the vB zip..


Run that from the web...

You should prolly ask over at vbulletin.com also...

[Samuel]

The customer has in three places, they have a modified vb so they are out of luck (First thing I asked).

The repair.php I havent any experience with (Never needed it), but will have them give it a try.

Really appreciate the help, and I am sure she does too.