Results 1 to 9 of 9
  1. #1

    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]

  2. #2
    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...

  3. #3
    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]

  4. #4
    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?

  5. #5
    2.2.5 and it was from the CP

    It was just remove user the admin panel.

    PHP 4.2.2
    dotGig
    <:<: [Fruit eating linux administrator]

  6. #6
    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

  7. #7
    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]

  8. #8
    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...

  9. #9
    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]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •