I just bought a licensed copy of vBulletin. And upon installation of vBulletin, I went straight here to get some hacks. I found this one and I got excited about this fine work so I installed it immediately. Well, I installed it successfully (I think), but when I enabled the blocks. A database error occured:
Code:
Database error in vBulletin 3.0.3:
Invalid SQL:
## GET NEWS ##
SELECT thread.*,thread.iconid AS threadiconid, threadpost.pagetext AS pagetext,
threadpost.attach AS attachcount,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
LEFT JOIN post AS threadpost ON (thread.firstpostid = threadpost.postid)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN ()
AND deletionlog.primaryid IS NULL
AND forumid NOT IN (0)
AND thread.open <> 10
AND thread.visible = '1'
ORDER BY thread.dateline DESC
LIMIT 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 ')
AND deletionlog.primaryid IS NULL
AND forumid NOT IN (0)
mysql error number: 1064
Date: Wednesday 29th of December 2004 07:45:01 AM
Script: http://www.xxxxxxx.com/
Referer:
Username: xxxxx
IP Address: xxx.xxx.xxx.xxx
How do I solve this?