What the helll? I've had this installed for a couple of days, and it's been working fine. Now, suddenly i've been getting this error.
Code:
Database error in vBulletin 3.0.0 Release Candidate 4:
Invalid SQL:
## GET NEWS ##
SELECT thread.*,thread.iconid AS threadiconid, threadpost.pagetext AS pagetext,
threadpost.attach AS attachcount,
avatarpath, NOT ISNULL(avatardata) AS customavatar, user.avatarrevision, customavatar.dateline AS customdateline,
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')
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
WHERE forumid IN (http://www.*.com/forums/forumdisplay.php?f=2)
AND deletionlog.primaryid IS NULL
AND forumid NOT IN (0)
AND thread.open <> 10
AND thread.visible = '1'
ORDER BY thread.sticky DESC, thread.dateline DESC
LIMIT 5
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 '://www.*.com/forums/forumdisplay.php?f=2)
AN
mysql error number: 1064
Date: Tuesday 27th of April 2004 04:39:08 PM
Script: http://www.*.com/forums/vbindex.php
Referer:
Username: *
IP Address: *