Database error in vBulletin 3.8.3

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • New Age
    Senior Member
    • Apr 2009
    • 127
    • 3.8.x

    Database error in vBulletin 3.8.3

    Hello Everyone,

    I am continually getting the below error sent to my email!
    Can someone tell me what the problem is and how I can fix it?

    Thankyou in advance.

    Adam

    Database error in vBulletin 3.8.3:

    Invalid SQL:

    SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
    FROM thread AS thread
    INNER JOIN tagthread AS tagthread ON
    (tagthread.tagid = 1 AND tagthread.threadid = thread.threadid)
    WHERE thread.forumid IN()
    AND thread.visible = 1
    AND thread.sticky IN (0, 1)
    AND thread.open <> 10
    GROUP BY tagthread.tagid;

    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 ')
    AND thread.visible = 1
    AND thread.sticky IN (0, 1)' at line 5
    Error Number : 1064
    Request Date : Friday, September 11th 2009 @ 02:02:05 AM
    Error Date : Friday, September 11th 2009 @ 02:02:05 AM
    Script : http://www.new-age.net.au/cron.php?rand=1252598524
    Referrer : http://www.new-age.net.au/online.php...e&pp=20&page=1
    IP Address : 203.171.192.167
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Invalid SQL errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any third-party hacks or plugins, then see if you still have this problem.

    If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

    Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
    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...