Announcement

Collapse
No announcement yet.

DB Issue.

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

  • 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
    '10734)


    AND deletionlog.primaryid IS NULL' at line 8

    mysql error number: 1064
    Gentoo Geek

  • #2
    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....
    Gentoo Geek

    Comment

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