Announcement

Collapse
No announcement yet.

Weird error

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

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

    Leave a comment:


  • Zachery
    replied
    The thread and forum counters.

    Leave a comment:


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

    Which counters?

    Leave a comment:


  • Zachery
    replied
    Could you try running the update forum counter as well as providing the information Steve requested

    Leave a comment:


  • bspiller
    replied
    PHP version: 4.4.1
    MySQL version: 4.1.19-standard

    Leave a comment:


  • Steve Machol
    replied
    Whhich versions of PHP and MySQL are you running?

    Leave a comment:


  • bspiller
    started a topic Weird error

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X