No announcement yet.

DB Issue.

  • Filter
  • Time
  • Show
Clear All
new posts

  • snakes1100
    Nevermind i found the issue. Site owner doing admin stuff beyond his reading capabilities.

    Seperating users in the conventry with commas instead of spaces.

    AND postuserid NOT IN (36300,,10734) <--- caused that....

    Leave a comment:

  • snakes1100
    started a topic DB Issue.

    DB Issue.

    Any ideas on this one, forum was fine util this morning?

    Database error in vBulletin 3.0.3:

    Invalid SQL:
    SELECT COUNT(*) AS threads,
    SUM(IF(lastpost>=1102799608 AND open<>10,1,0)) AS newthread
    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON(thread.threadid =
    deletionlog.primaryid AND type = 'thread')
    WHERE forumid = 97
    AND sticky = 0
    AND visible = 1
    AND postuserid NOT IN (36300,,10734)

    AND deletionlog.primaryid IS NULL

    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 deletionlog.primaryid IS NULL' at line 8

    mysql error number: 1064
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.