Lil Problem I Have

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Majestic3d
    Member
    • Nov 2001
    • 37

    Lil Problem I Have

    Does anybody know what is causing this error on my board ?

    Majestic3d Forums
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    From the HTML source:

    <!-- Database error in vBulletin 2.2.5:

    Invalid SQL: SELECT userid,username
    FROM user
    WHERE userid<>
    AND (usergroupid=5
    OR usergroupid=6
    OR usergroupid=7
    OR usergroupid=2)
    ORDER BY RAND()
    LIMIT 1
    mysql error: You have an error in your SQL syntax near 'AND (usergroupid=5
    OR usergroupid=6
    ' at line 4

    mysql error number: 1064

    Date: Saturday 06th of April 2002 12:59:52 AM
    Script: http://majestic3d.com/forums/forums/index.php
    Referer: http://www.vbulletin.com/forum/showt...774#post272774
    -->
    Have you installed any hacks?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • Majestic3d
      Member
      • Nov 2001
      • 37

      #3
      Yes i do have a couple installed, statistics panel, moddrop down and welcome panel.

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Did the error start happening after installing one of those hacks? Did you make any changes prior to this error?

        You could try running repair.php to see if it fixes the problem. Other than that I don't know what to suggest other than installing fresh copies of the vB PHP files. In particular I'd start with index.php in your forums directory. Good luck!
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • Majestic3d
          Member
          • Nov 2001
          • 37

          #5
          I have fixed the error and removed the hack, the hack that was causing it was " Statistics Panel " 2.2.4 version. now the board is sweeter. Thankyou for your quick replies much appreciated.

          Comment

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #6
            Good job!
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...