[Rampag33]

I tried installing this thing and at first I thought everything went well. Went to the admincp and didn't see any settings or options. All databese entries where made as well as phrases. Just no file edits during the autoinstall. I'm guesssing becuase my vb has ben modded. VB version 3.0.7.

So I attempted to do the first file edit to "forumdisplay.php". After editing the file I tried looking at my forum that used that file to see if any errors came up before moving on to the next file.

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, lastpost, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach

, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1) LEFT JOIN geek_articles as ga ON(ga.threadid = thread.threadid)
LEFT JOIN geek_articles as ga ON(ga.threadid = thread.threadid)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN (0)
ORDER BY sticky DESC, lastpost DESC

Can anyone tell me what might be going wrong to use this mod