Bug Hundreds of these errors (maybe thousands)

[Mick]

Hi all,

Just thought I would mention this, my server load has been all over the place lately and can only put it down to DBSEO or the DB LIKES THANKS HACK. as nothing else is new... but I have been getting load spikes of 20+ infrequently just random crazy spikes then zombie processes in the top stats... yesterday I had 21 zombie processes and after killing and restarting php they disappeared...


This is the most common php errors there is 200k of them, and a few others too which I am looking into

mysql_error() expects parameter 1 to be resource, boolean given in /*****/*****/****/****/****/forum/dbtech/dbseo/includes/class_db.php on line 115

Thought I would let you know.

Mick

 

[Mick]

this is also a regular one.

PHP Warning:  include(/*****/*****/*****/*****/forum/includes/config.php): failed to open stream: Permission denied in /*****/*****/*****/*****/forum/dbtech/dbseo/includes/class_core.php on line 267

[09-Jan-2014 17:46:11 UTC] PHP Fatal error:  require(): Failed opening required '/*****/*****/*****/*****/forum/technomate-5000-series-downloads.php' (include_path='.:/usr/local/lib/php') in /*****/*****/*****/*****/forum/dbseo.php on line 433

 

[Fillip H.]

Can you show me what's on line 115? Please also include 5 lines around it (and mark which one is line 115) so I can get some context.

 

[Fillip H.]

this is also a regular one.

PHP Warning:  include(/*****/*****/*****/*****/forum/includes/config.php): failed to open stream: Permission denied in /*****/*****/*****/*****/forum/dbtech/dbseo/includes/class_core.php on line 267

This indicates that your config.php file is not readable, which can happen if it's been CHMOD'ed to not be readable, or if it's owned by a user/group separate from your Apache process.

This is a server configuration issue which you will need to resolve.

[09-Jan-2014 17:46:11 UTC] PHP Fatal error:  require(): Failed opening required '/*****/*****/*****/*****/forum/technomate-5000-series-downloads.php' (include_path='.:/usr/local/lib/php') in /*****/*****/*****/*****/forum/dbseo.php on line 433

This seems to point to a misconfiguration of an URL format. It appears as if a . is a part of a URL format (possibly pertaining to downloads or attachments?) along with either an extension variable or a hardcoded .php extension.

Can you please verify whether this is the case?

If it is not, please provide step-by-step details for replicating this issue.

 

[Mick]

Can you show me what's on line 115? Please also include 5 lines around it (and mark which one is line 115) so I can get some context.

mysql_error() expects parameter 1 to be resource, boolean given in /*****/*****/****/****/****/forum/dbtech/dbseo/includes/class_db.php on line 115

		else
		{
			if ($this->config['MasterServer']['usepconnect'])
			{
				$this->link = mysql_pconnect($this->config['MasterServer']['servername'] . ':' . $this->config['MasterServer']['port'], $this->config['MasterServer']['username'], $this->config['MasterServer']['password']);
			}
			else
			{
				$this->link = mysql_connect($this->config['MasterServer']['servername'] . ':' . $this->config['MasterServer']['port'], $this->config['MasterServer']['username'], $this->config['MasterServer']['password']);
			}

			if (!$this->link)
			{
		die('Connect Error: ' . mysql_error($this->link));
			}

			if (!mysql_select_db($this->config['Database']['dbname'], $this->link))
			{
				echo printf("DB Select Error: %s", mysql_error($this->link));
				die();
			}
		}

Hi Fillip H., thanks for getting back to me I have bolded the line (but if that does not work it is line

line 115 -> die('Connect Error: ' . mysql_error($this->link));

Regards
Mick

 

[Mick]

Also this one is popular

Illegal string offset 'pollid' in /****/****/****/*****/forum/dbtech/dbseo/includes/library/poll.php on line 163

		if (count($queryList))
		{
			$info = DBSEO::$db->generalQuery('
				SELECT thread.forumid, poll.pollid, poll.question
				FROM $thread AS thread
				LEFT JOIN $poll AS poll USING(pollid)
				WHERE pollid IN (' . implode(',', $queryList) . ')
			', true);
			foreach ($info as $arr)
			{
				// Build the cache
				DBSEO::$datastore->build('pollinfo.' . $arr['pollid'], $arr);

				// Cache this info
				DBSEO::$cache['poll'][$arr['pollid']] = $arr;
			}
		}

Line 163: DBSEO::$datastore->build('pollinfo.' . $arr['pollid'], $arr);

 

[Fillip H.]

Both of those issues should now be taken care of

PS: I would recommend changing your config.php to use mysqli rather than mysql, as it's a new & improved MySQL library. The old MySQL library is deprecated, and will be removed in PHP 5.5.

 

[Mick]

Both of those issues should now be taken care of

PS: I would recommend changing your config.php to use mysqli rather than mysql, as it's a new & improved MySQL library. The old MySQL library is deprecated, and will be removed in PHP 5.5.

How do I do that Fillip H. ?

Never been told???

Thanks very much for all tips too.

Mick

 

[Mick]

Figured it out lol.

Thank you.

 

[Mick]

Both of those issues should now be taken care of

PS: I would recommend changing your config.php to use mysqli rather than mysql, as it's a new & improved MySQL library. The old MySQL library is deprecated, and will be removed in PHP 5.5.

Is that a hotfix or a RC release

cheers Fillip H.

 

[Fillip H.]

Hotfix, if you re-download RC2 and re-upload all files you'll get the fix plus others