Results 1 to 5 of 5

Thread: Cannot add a Moderator

  1. #1
    Join Date
    Jun 2008
    Location
    Brisbane
    Posts
    31

    Default Cannot add a Moderator

    When we try to add a moderator, we get a database error.

    PHP Code:
    Database error in vBulletin 3.7.0:

    Invalid SQL:

            
    SELECT userid
            FROM 
    ******adv_links_moderator
            WHERE userid 
    1
                
    AND catid =;

    MySQL Error   You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
    Error Number  
    1064
    Request Date  
    TuesdayJune 3rd 2008 02:59:24 PM
    Error Date    
    TuesdayJune 3rd 2008 02:59:24 PM
    Script        
    http://www.******.com/forum/admincp/vba_links_admin.php?do=doaddmod
    Referrer      http://www.******.com/forum/admincp/vba_links_admin.php?do=addmoderator&catid=1&s=
    IP Address    12x.18x.2x.2x
    Username      
    admin 
    Any suggestions please, have masked the ip and site

  2. #2
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: Cannot add a Moderator

    Thank you for pointing this out. I've just applied the fix to the download package here, so if you will download the files again and replace your forum/admincp/vba_links_admin.php file with the updated version, that should take care of the issue.

  3. #3
    Join Date
    Jun 2008
    Location
    Brisbane
    Posts
    31

    Default Re: Cannot add a Moderator

    Quote Originally Posted by Brian View Post
    Thank you for pointing this out. I've just applied the fix to the download package here, so if you will download the files again and replace your forum/admincp/vba_links_admin.php file with the updated version, that should take care of the issue.
    Many Thanks.

    Just noticed you are from Georgia.

    One of my fave places.

    Esp: Lake Lanier, Buckhead, Stone Mountain and the best place in the world. Tybee Island

  4. #4
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: Cannot add a Moderator

    Never been a big fan of Buckhead. The last time I went there I got really lost and ended up getting a ticket for trying to turn somewhere I apparently wasn't supposed to. First ticket I had in about 10 years too. Haven't been back since.
    Love Typee Island and Lake Lanier though. My dad used to tell me a story about how one of my great-great-great grandfathers used to own Stone Mountain and ended up trading it for something cheap because he figured he was getting a good deal since all he was trading was a giant rock. No clue if it's actually true though.

  5. #5
    Join Date
    Jun 2008
    Location
    Brisbane
    Posts
    31

    Default Re: Cannot add a Moderator

    lol GOLD !
    Admin of YBMF

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Bug: Moderator name change
    By iardon in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 04-04-2008, 01:20 PM
  2. Moderator Cache
    By Kirby in forum Feedback & Suggestions
    Replies: 0
    Last Post: 02-26-2008, 05:02 AM
  3. Moderator Box
    By shaffer in forum Bugs From 1.0.1
    Replies: 6
    Last Post: 02-24-2006, 05:30 PM
  4. Report to Moderator
    By kittymother in forum "How Do I..." Questions
    Replies: 6
    Last Post: 07-09-2004, 02:07 PM
  5. Bug Moderator Column
    By TraumTeam in forum Bugs From 1.0 RC1
    Replies: 2
    Last Post: 07-04-2004, 01:57 PM

Posting Permissions

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