There used to be Core Forums but now that url just redirects to this thread. Apparantly this thread is now the sole point of contact for this portal script. Unfortunately the support has also disappeared as I never did get a response for my own issue. Core Forums had a few good modifications / add-ons too, so it's a shame to have lost that.

I am gettin this mySQL error message on my vB index homepage:

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 vb3thread AS thread
LEFT JOIN vb3user AS user ON (thread.postuserid = user.userid)
LEFT JOIN vb3post AS threadpost ON (thread.firstpostid = threadpost.postid)
LEFT JOIN vb3deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')

LEFT JOIN vb3customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN vb3avatar AS avatar ON (avatar.avatarid = user.avatarid)

LEFT JOIN vb3subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
WHERE forumid IN (http://www.underworld-chaos.net/boar...=newpost&t=432)
AND deletionlog.primaryid IS NULL
AND forumid NOT IN (0)
AND thread.open <> 10
AND thread.visible = '1'
AND thread.postuserid NOT IN (90,61)

ORDER BY thread.dateline DESC
LIMIT 10
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.underworld-chaos.net/boards/showthread.php?goto=newpost&

mysql error number: 1064

Date: Friday 19th of November 2004 02:07:16 AM
Script: http://www.underworld-chaos.net/boards/vbindex.php
Referer:
Username: Pandora
IP Address: *CONFIDENTIAL*

Can someone please help me???

~Pandora~

Right, I have read 40+ pages now and cant seem to find the answer to this.

I have installed this hack and everything seems fine, I still need to change path to smilies though.

The only problem is, I use a flash header which has links to forum and home. This seems to have been changed when I installed the hack. It is pointing to the wrong address on the home page.

I havent renamed the home page yet so see the link here:

http://www.mobilephonemadness.com/vbindex.php

Any idea what I need to change to fix this? Where are the variables such as $stylevar[imgdir_misc] defined?


Thanks In Advance
Mark
www.mobilephonemadness.com

This is my very first post here since I'm such a newb at this I thaught I'd say thanks for the hack and a HUGE thank you to KWOPPER for these instructions.
I just last week purchased VB and installed vbindex last night, It was a bit of work till I came across this one post.
Things went as smooth as anyone would want.
One question I have though is it ok that I removed the powered by disclamer at the bottom of the vbindex page?
I have purchased the branded free licence for VB and didnt see a point in having it there.I did however keep (vBindex Copyright ? MMII - MMIV Winter Systems). on the page per the posted disclaimer.
I have it setup at http://www.offroadrc.com
Any feedback would be appreciated.


******Clicks Install******

hi, can anyone help me transfer the statistics box (threads, posts and newest member)from the forum to the vbindex portal?

has anyone got the photopost block code handy, cannot find it in this thread, i have photopost and vbindex, i would like to include some thumbs on vbindex, please advise, cheers

-b6

lol I attempted to install this and I'm not sure where itwent. I got the options in the control panel but I don't see it as my first page. Help please
http://www.werbeyond.com/forum/index.php?

<a href="http://www.werbeyond.com/forum/vbindex.php?" target="_blank">http://www.werbeyond.com/forum/vbindex.php?</a> Here's your vbindex page, looks like you've got some errors though..,.

Nice Hack which I have installed. Everything is fine but I get these errors once in awhile:

--------------------------------
Database error in vBulletin 3.0.3:

Invalid SQL: ## COUNT SHOUTS ##
SELECT COUNT(*) AS shouts
FROM vbindex_shoutbox
WHERE 1 = 1

AND shoutbox.userid NOT IN (137,465,508,197)
mysql error: Unknown table 'shoutbox' in where clause

mysql error number: 1109

--------------------

Or several variations of the same error message.

Anyone ever figure out why Firefox opens the index page out of align randomly? This was mentioned on the old core forums but never replied to I believe.