Results 1 to 9 of 9
-
08-21-2002, 12:39 AM #1Web Hosting Master
- Join Date
- May 2002
- Posts
- 3,416
Removed USER (Bountiful MYSQL errors in functions.php)
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?dotGig
<:<: [Fruit eating linux administrator]
-
08-21-2002, 12:49 AM #2Web Hosting Master
- Join Date
- May 2001
- Location
- Dayton, Ohio
- Posts
- 4,977
No.. Whats the error exactly... Maybe we can tell you how to fix it...
You might try updating all the counters...
-
08-21-2002, 12:53 AM #3Web Hosting Master
- Join Date
- May 2002
- Posts
- 3,416
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
dotGig
<:<: [Fruit eating linux administrator]
-
08-21-2002, 12:55 AM #4Web Hosting Master
- Join Date
- May 2001
- Location
- Dayton, Ohio
- Posts
- 4,977
How did they remove the user?
From phpMyAdmin? Or from the Admin CP?
What vB version and PHP version?
-
08-21-2002, 02:11 AM #5Web Hosting Master
- Join Date
- May 2002
- Posts
- 3,416
2.2.5 and it was from the CP
It was just remove user the admin panel.
PHP 4.2.2dotGig
<:<: [Fruit eating linux administrator]
-
08-21-2002, 07:20 AM #6Web Hosting Master
- Join Date
- May 2001
- Location
- Dayton, Ohio
- Posts
- 4,977
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
-
08-21-2002, 07:23 AM #7Web Hosting Master
- Join Date
- May 2002
- Posts
- 3,416
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.dotGig
<:<: [Fruit eating linux administrator]
-
08-21-2002, 07:31 AM #8Web Hosting Master
- Join Date
- May 2001
- Location
- Dayton, Ohio
- Posts
- 4,977
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...
-
08-21-2002, 07:47 AM #9Web Hosting Master
- Join Date
- May 2002
- Posts
- 3,416
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.dotGig
<:<: [Fruit eating linux administrator]