Announcement

Collapse
No announcement yet.

Weird error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Weird error

    I get an error like this every so often. Maybe once every 2-4 weeks. What does it mean exactly?

    Database error in vBulletin 3.6.0:

    Invalid SQL:

    SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.iconid, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM thread AS thread LEFT JOIN user AS user ON (user.username = thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND thread.visible!=0 AND thread.forumid NOT IN (21,28,34,41,42,43,46,47,48,58,58,28,21,39,)
    ORDER BY views DESC LIMIT 0, 10;

    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 ')
    ORDER BY views DESC LIMIT 0, 10' at line 2 Error Number : 1064
    Date : Tuesday, September 12th 2006 @ 08:54:49 AM
    Script : http://www.247xtreme.com/forums/forumdisplay.php?f=8
    Referrer :
    IP Address :
    Username :
    Classname : vb_database

  • #2
    Whhich versions of PHP and MySQL are you running?
    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


    • #3
      PHP version: 4.4.1
      MySQL version: 4.1.19-standard

      Comment


      • #4
        Could you try running the update forum counter as well as providing the information Steve requested

        Comment


        • #5
          Originally posted by Zachery View Post
          Could you try running the update forum counter as well as providing the information Steve requested

          Which counters?

          Comment


          • #6
            The thread and forum counters.

            Comment


            • #7
              The update counters page can be found at the bottom of the admincp navigation menu under the "maintenance" section.

              Comment

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