vBadvanced CMPS - Old Support Thread

Tigga - let me be the first to say what an absolutely outstanding hack this is. I've been using it now for about a month (or whenever you first released it on your website).

Installed and working great on 3.0.1. Fantastic work !!!! Waiting to vote for it on 'Hack of the Month'.



* Intex clicks INSTALL. Even though it was installed a few weeks ago .

[BaBa2002]

after that the vbadvanced works perfect for a few weeks
i got now this problem
can anybody help me fixing this?

Database error in vBulletin 3.0.3:

Invalid SQL: 
			SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
			thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext, allowsmilie
			, showsignature, usertextfield.signature
  		,thread.iconid AS threadiconid, iconpath AS threadiconpath 
  		, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision 
  		, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed  
  		, attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
			FROM thread AS thread
			LEFT JOIN post AS post ON (post.postid = thread.firstpostid) 
  		LEFT JOIN icon USING (iconid) 
  		LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid) 
			LEFT JOIN user AS user ON (user.userid = post.userid)
			
			LEFT JOIN usertextfield AS usertextfield ON (post.userid = usertextfield.userid)
  		
				LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
				LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
			 
  		 LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1') 
			LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
			WHERE forumid IN(14,15) AND thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL
			GROUP BY post.postid
			ORDER BY  postdateline DESC 
			LIMIT 4
mysql error: Got error 28 from table handler

mysql error number: 1030

[h75]

Nobody can't help me? or is it dispensable?????? :disappointed:
https://vborg.vbsupport.ru/showpost....&postcount=377

Pllllllleeeeeeaaaaaaaaccccceee :disappointed:

[Torqued]

h75:

you may want to ask at http://www.vbadvanced.com/ as well.

[h75]

I also postet it there, but the Thread was not considered!

http://www.vbadvanced.com/forum/show...7707#post17707

[Action-N]

Originally Posted by h75

I also postet it there, but the Thread was not considered!

http://www.vbadvanced.com/forum/show...7707#post17707

Don't be a whiner, whiners don't get helped as you can see. Reading the errors it looks like like there is an HTML table tag that doesn't get closed. So start opening some templates an track it down yourself, maybe you'll learn something.

[SamirDarji]

Try also checking the database itself for errors.

[h75]

I found that ++++ty error!!!

WRONG!!! :ninja:

<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder"width="100%">

RIGHT!!!

<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">

CHANGE THIS IS ANY TEMPLATES please !!!!

[sjenkins]

Guys,
Doing something really wrong...I am getting a message :

Warning: main(./includes/init.php): failed to open stream: No such file or directory in /home/sjenkins/public_html/upload/admincp/global.php on line 50

Fatal error: main(): Failed opening required './includes/init.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/sjenkins/public_html/upload/admincp/global.php on line 50

Any thoughts ?

[COTTEN]

I need a lil help....I did the whole edit in dreamweaver and everything seems to be working on the forum and everywhere else.....BUT...this is what I get when I hit the home page......

Fatal error: Call to undefined function: print_portal_output() in /home/httpd/vhosts/rideartcustoms.com/httpdocs/index.php on line 27

do I need to edit on note pad and redo it all or what...?

please help.... :disappointed:

[traderx]

Originally Posted by sjenkins

Guys,
Doing something really wrong...I am getting a message :

Warning: main(./includes/init.php): failed to open stream: No such file or directory in /home/sjenkins/public_html/upload/admincp/global.php on line 50

Fatal error: main(): Failed opening required './includes/init.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/sjenkins/public_html/upload/admincp/global.php on line 50


Any thoughts ?

hmmm what the deal with the upload folder.... that might be it