NTLDR, you are nothing short of a god in my book!!! If you only knew how aggravated I was gettting. Thank you so much!!!
As I was changed around some options, I ran into an error when I tried to enable "news". Here is the error message I got, what do you make of it??
----------------------------------------
Database error in vBulletin 3.0.1:
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 4
mysql error: You have an error in your SQL syntax near ')
AND deletionlog.primaryid IS NULL
AND forumid NOT IN (0)
AND thread.open' at line 14
mysql error number: 1064
Date: Wednesday 12th of May 2004 04:19:03 PM
Script:
http://www.my domain.com/vbindex.php
Referer:
Username: (edited)
IP Address: (edited)
-----------------------------------------------
What do I need to do???
Thanks again,
Rob