[Dsmed]

Database error in vBulletin 3.0.0:

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,
NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed,
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)

LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
WHERE forumid IN (http://www.highertuning.com/forums/f...splay.php4?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 4
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.highertuning.com/forums/forumdisplay.php4?f=2)
AND de

mysql error number: 1064

Date: Sunday 11th of April 2004 02:17:13 PM
Script: http://www.highertuning.com/
Referer:
Username: Dsmed
IP Address: 68.97.154.219

i keep getting this error when i enable the news groups...any idea on what im doing wrong?

thanks
-Brian