PDA

View Full Version : forumid error?


synn
04-14-2005, 02:39 PM
This is a long error code...can someone please help translate this for me?

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT

thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
, thread.iconid AS threadiconid, iconpath AS threadiconpath
,thread.forumid, forum.title AS forumtitle
, post.pagetext AS preview

FROM thread as thread
LEFT JOIN icon USING (iconid)
LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')

WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(15,18,30,41,31,33,42,36,32,34,35,17,16,37,38) Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 4

mysql error: You have an error in your SQL syntax near 'Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 4
' at line 15

mysql error number: 1064

Marco van Herwaarden
04-14-2005, 02:57 PM
Well, there is an array variable used at that point, where it should be a normal variable.

Did you just install a hack?
And on what php-file are you getting this error?