Bug Fatal Error when visiting the forum page

[Xar]

Hello,

Yesterday I tried to install the Twitch Streaming Mod on my WIP website.
While I did I encountered a weird error which only occurs when going to the forum.

The error is as followed:
"Fatal error: Call to a member function query_first_slave() on a non-object in /var/www/html/vbulletin/dbtech/twitch/hooks/global_bootstrap_complete.php on line 2"

I used to install it on a test vbulletin on which it worked. I have totally no clue why this happened and I could count on some assistance here.
FYI: I recently changed from SMF to vBulletin so my knowledge is still limited but I do understand many parts around it.

Thank you.

P.S. Please select the theme "Wyrm Gnosis Sapphire" for a better overall view, just in case.

 

[Fillip H.]

Please try disabling all other products and re-enable them one by one until you find the culprit, as it's most likely due to a mod conflict.

 

[Xar]

Hello,

I tried disabling all of the plugins but the error still occurs.
What else could be the cause of it?

Thank you.

 

[Fillip H.]

Could you please create and PM me with a temporary FTP and AdminCP account?

For security reasons, we recommend you create a new FTP account only for DBTech support, then disable or delete it after we have both confirmed the issue has been solved and there are no further issues.

The same applies to AdminCP accounts; they should ideally be temporary accounts created for us only. If we have created an account on your site already, you can optionally boost that account to Administrator and then de-admin this account once the issue has been solved.

If you use a .htaccess password protection for your AdminCP directory, it is recommended that you create a new authorised user for DBTech and remove this user once the issue has been solved.

Please test any temporary accounts you create to ensure that the FTP account has access to the forum files, and that the AdminCP account can access the administrative controls for the product we are assisting you with.

Ensuring this is all in order before submitting the information will significantly speed up the process of assisting you. We will alert you via PM if there's any issues with the login information you have provided.

When sending the PM, for your security you should also un-tick the "Save a copy in my Sent Items folder" checkbox. When the access details have been received, we will delete the PM from our inbox. Ensuring you have not kept a copy of the PM reduces the risk of security breaches.

Thank you for helping us debug our products and allowing us to assist you, we appreciate it

 

[Xar]

I was playing around a bit.

In the hooks/global_bootstrap_complete.php
Removing:

if ((THIS_SCRIPT == 'index' OR THIS_SCRIPT == 'vbecommerce') AND $channel = $vbulletin->db->query_first_slave("
	SELECT
		channel.*,
		user.*
		" . ($vbulletin->options['avatarenabled'] ? ', avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb' : '') . "			
	FROM " . TABLE_PREFIX . "dbtech_twitch_channel AS channel
	LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = channel.userid)
	" . ($vbulletin->options['avatarenabled'] ? "
	LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON (avatar.avatarid = user.avatarid)
	LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON (customavatar.userid = user.userid)
	" : '') . "
	WHERE isfeatured = '1'
"))

Makes the forum accessible again.
I'm not sure what this query is for though as I'm not really into mysql.
Could the problem be something because of this?

For some reason, the original navigation for twitch.tv which is added through the plugin isn't showing up either.
Selecting this: "Manually Deploy "Featured Channel" Block" to yes still displays the block when I remove the query.

I'm confused.
The whole install is fresh and I started editing it to my needs.
The Twitch Pro was one of the first installed plugins as well.

EDIT: Oh god, I just figured it out. I will post it after I finished my game.

EDIT 2 (FIXED): I was thinking about the first line since I installed a CMPS.

I changed :

if ((THIS_SCRIPT == 'index' OR THIS_SCRIPT == 'vbecommerce')

to

if ((THIS_SCRIPT == 'forum' OR THIS_SCRIPT == 'vbecommerce')

And basically it fixed the issues.

Not sure if that might help you for other customers that have a CMPS installed but yeh, I'm happy I found it .
Thanks for the quick replies.

 

[Fillip H.]

Are you using vBAdvanced, or the vBulletin CMS?

 

[Xar]

vBAdvanced here.

And sorry I made a letter mistake. It meant to say CMPS.

 

[Fillip H.]

I just asked because by default, vBulletin's forum.php's THIS_SCRIPT is index. If vBAdvanced also uses the exact same THIS_SCRIPT identification, this is incredibly bad form and leads to issues like this.

I would recommend checking out the root vbadvanced .php file (I don't know what it's called) and making sure its definition is set to something else, like vbadvanced (which, I believe, is the default).

 

[Xar]

Ah that's weird.
vbadvanced is using "adv_index" as THIS_SCRIPT.

I also removed the whole ftp setup because I thought it was fixed lol.
Anyway, I'll PM you some new details again so you could take a look .