Bug Error in Apache Log

[webi]

Following entry in the Apache logfile we find activated vBSuper PM and the attempt to call the archive/index.php and the page stays white.
Once the addon is disabled, the archive/index.php be called without problems.

[error] [client x.x.x.x] PHP Fatal error: Call to a member function query_first() on a non-object in /var/www/VirtualHost/html/global.php(37) : eval()'d code on line 4

 

[Ozzy47]

Have you uploaded the files recently, or are they from some time ago? Another user is reporting the same thing, but this was after I changed a file.

 

[webi]

This newly downloaded - New uploaded - same problem

Google already vain attempts to access it

[Wed Oct 09 06:13:38 2013] [error] [client 66.249.78.183] PHP Fatal error: Call to a member function query_first() on a non-object in /var/www/VirtualHost/html/global.php(37) : eval()'d code on line 4

 

[webi]

Is there already a solution for my problem?

 

[Ozzy47]

Not yet, I am still looking for the best solution. What version of php are you running?

 

[webi]

PHP Version

PHP 5.3.3-7+squeeze14 with Suhosin-Patch (cli) (built: Aug 6 2012 14:18:06)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with Suhosin v0.9.32.1, Copyright (c) 2007-2010, by SektionEins GmbH

 

[webi]

Any idea?
I'm open to any ideas!

 

[Fillip H.]

Can you please paste me the contents of every single plugin you are running on the hook global_setup_complete ?

 

[webi]

How do I determine which is best for you?

 

[Fillip H.]

Sorry?

I need to see the contents of all the hooks you have running (via the Plugin Manager) on the specified hook location. Once I see those, I should be able to detect what the issue is.

 

[webi]

OK now I understand it.

 

[Fillip H.]

Can you please click Edit on the vBulletin Self-Delete plugin and paste the contents of this plugin here?

 

[webi]

if ($vbulletin->options['vbselfdelete_cool_forumhome'] == 1 AND $vbulletin->options['vbselfdelete_cool_stop'] == 1)
{
	$existing = $db->query_first("
		SELECT * 
		FROM " . TABLE_PREFIX . "vbselfdelete_user 
		WHERE userid = '" . intval($vbulletin->userinfo['userid']) . "'
	");

	if ($existing['status'] == 2 AND $existing['deltime'] > TIMENOW)
	{
		$show['selfdeleteinfo'] = true;
		$show['selfdeleteremain'] = round((($existing['deltime'] - TIMENOW) / 60), 0);
	}
}

 

[Fillip H.]

In the code you showed me, find

$existing = $db->query_first("

and replace with

$existing = $vbulletin->db->query_first("

Let me know if this works for you

 

[webi]

It works perfectly

Thank you

The support at DragonByte Technologies is just Brilliant.

 

[webi]

Too bad not quite solved.
Can you possibly help me with this also?

Database error in vBulletin 4.2.1:

Invalid SQL:

		SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
		FROM vbpost AS post
		LEFT JOIN vbuser AS user ON (user.userid = post.userid)
		WHERE threadid = 
			AND visible = 1
			
		ORDER BY dateline ASC
		LIMIT 0,250;

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 'AND visible = 1
			
		ORDER BY dateline ASC
		LIMIT 0,250' at line 5
Error Number  : 1064
Request Date  : Saturday, October 12th 2013 @ 09:48:40 PM
Error Date    : Saturday, October 12th 2013 @ 09:48:40 PM
Script        : [url]http://www.Domain.com/archive/index.php/t-1051.html[/url]
Referrer      : 
IP Address    : XXX.XXX.XXX.XXX
Username      : *****
Classname     : vB_Database
MySQL Version : 5.5.31-0+wheezy1-log

 

[Fillip H.]

Hmm, that's a default vBulletin query. Does it work if you disable vBSEO?

Keep in mind that you should also temporarily remove the .htaccess rewrite rules for vBSEO, and use the non-SEO'd archive URL to test it.

 

[webi]

Hmm, that's a default vBulletin query. Does it work if you disable vBSEO?

Keep in mind that you should also temporarily remove the .htaccess rewrite rules for vBSEO, and use the non-SEO'd archive URL to test it.

Everything disabled and changed as suggested. No difference: (.

So the archive looks