Announcement

Collapse
No announcement yet.

what is this sql error?

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

  • d3nnis
    replied
    Originally posted by Steve Machol
    You didn't post the complete error, including the script info.

    oops sorry i think its attachment.php (i delete the mail already)

    Leave a comment:


  • Steve Machol
    replied
    You didn't post the complete error, including the script info.

    Leave a comment:


  • d3nnis
    started a topic what is this sql error?

    what is this sql error?

    Database error in vBulletin 3.0.0:

    Invalid SQL:
    SELECT attachment.attachmentid, attachment.postid, post.threadid, thread.forumid, thread.open, attachment.userid, post.dateline as p_dateline
    IF(attachment.postid = 0, 1, 0) AS inprogress
    FROM vb3_attachment AS attachment
    LEFT JOIN vb3_post AS post ON (attachment.postid = post.postid)
    LEFT JOIN vb3_thread AS thread ON (thread.threadid = post.threadid)
    LEFT JOIN vb3_deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
    WHERE attachmentid IN (0,901) AND attachment.userid = 8556
    AND ((forumid IN(0,5,75,38,50,51,10,37,19,32,56,42,46,30,26,31,28,33,76,77,12,35,52,53,54,67,73,27,74,1, 49,43,62,39,68,69,70,71,64,65,66,2,15,16,17,18,3,21,20,14,58,59,13,41,57,72,4,22,23,61,11, 34,7,36,48,24,6,25,8,47) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) OR attachment.postid = 0)

    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 'IF(attachment.postid = 0, 1, 0) AS inprogress
    FROM vb3_attach

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