Results 1 to 2 of 2

database error help

This is a discussion on database error help within the General Discussion forums, part of the vBulletin SEO Discussion category; I hope this is the right section, but here it goes. I have been getting a few database errors for ...

  1. #1
    Senior Member
    Real Name
    Matt
    Join Date
    May 2006
    Posts
    973
    Liked
    3 times

    database error help

    I hope this is the right section, but here it goes.

    I have been getting a few database errors for quite some time now, and I'm thinking it may be a hack that i've installed but i've been unable to work out which one or if it is even one.

    This is the error

    Code:
    Database error in vBulletin 3.6.4:
    
    Invalid SQL:
    
                                    SELECT usergroupid FROM vb3_icon AS icon
                                    INNER JOIN vb3_imagecategorypermission USING (imagecategoryid)
                                    WHERE icon.iconid = 10
                                            AND usergroupid IN ();
    
    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 4
    Error Number : 1064
    Date         : Thursday, February 1st 2007 @ 03:26:51 AM
    Script       : Gamerz Needs - For All Your Gaming Needs!
    Referrer     : Gamerz Needs - For All Your Gaming Needs!
    and another

    Code:
    Database error in vBulletin 3.6.4:
    
    Invalid SQL:
    
                                    SELECT usergroupid FROM vb3_icon AS icon
                                    INNER JOIN vb3_imagecategorypermission USING (imagecategoryid)
                                    WHERE icon.iconid = 10
                                            AND usergroupid IN ();
    
    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 4
    Error Number : 1064
    
    Date         : Thursday, February 1st 2007 @ 03:29:08 AM
    
    Script       : Gamerz Needs - For All Your Gaming Needs!
    
    Referrer     : Gamerz Needs - For All Your Gaming Needs!
    and another

    Code:
    atabase error in vBulletin 3.6.4:
    
    Invalid SQL:
    
                                    SELECT usergroupid FROM vb3_icon AS icon
                                    INNER JOIN vb3_imagecategorypermission USING (imagecategoryid)
                                    WHERE icon.iconid = 12
    
                                            AND usergroupid IN ();
    
    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 4
    Error Number : 1064
    
    Date         : Thursday, February 1st 2007 @ 03:30:08 AM
    
    Script       : Gamerz Needs - For All Your Gaming Needs!
    
    Referrer     : Gamerz Needs - For All Your Gaming Needs!

    hopefully the above will be able to help you track down the error and possible give me a fix to end this database error thats been going on for a while. (I've never had the error, so it makes it hard for me to know what is causing it)

    Thanks.

  2. #2
    vBSEO Staff Ace Shattock's Avatar
    Real Name
    Ace Shattock
    Join Date
    Jul 2005
    Location
    Auckland, New Zealand, New Zealand
    Posts
    3,998
    Liked
    11 times
    Looks to be a mod that deals with assigining permissions .. possibly to the default post icons?

Similar Threads

  1. vBulletin Database Error
    By Chewie in forum Bug Reporting
    Replies: 11
    Last Post: 01-19-2007, 08:44 AM
  2. VBSEO and my Database
    By sinjix_media in forum General Discussion
    Replies: 4
    Last Post: 01-04-2007, 11:19 AM
  3. Database Errors
    By majordude in forum Off-Topic & Chit Chat
    Replies: 4
    Last Post: 09-21-2006, 10:28 PM
  4. Database errors and problems with
    By drex in forum Bug Reporting
    Replies: 2
    Last Post: 11-02-2005, 09:02 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
  •