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

I have never installed vBindex before this is a brand new board. I keep getting this error.

Fatal error: Failed opening required './admincp/functions_vbiupgrade.php' (include_path='.:/usr/share/pear') in /home/httpd/vhosts/mysite.net/httpdocs/14words/admincp/vbiupgrade.php on line 57

Is there an initial install I have to do? This is an upgrade but I havent had the pre - grade yet. Please help

Well I have a noob question I'm sure. What does the CR mean in the version number? I'm running vB 3.0.1 and would like to make sure this will work on my board before installing it. From what I've seen, it looks great!

if you are refering to 'RC'

That stands for Release Candidate


and yes it will work with the version of vBulletin you have installed.

If i recall it should work with vBulletin v3.0.0 RC4 and Above.

You need to add the forumid that you wish to pull the news from in the options. See the admin help by clicking the (?) icon next to that option.

Make sure you upload all the files to the correct place as detailed by the readme file.

At the next Final Release there will be a complete "new" German Translation for all german Users.

It will be in the next Final *.zip too !

ok, stupid question, but how do i get my browser to point to vbindex.php as my index page for the site?

Rename it index.php.

i already replied to your post :

https://vborg.vbsupport.ru/showpost....postcount=1466

didn't u go back a few pages and see?