Still having the Datastore-related sql errors

As posted on the official forums without a shred of fixing it:

I have been getting these odd emails every so often, sometimes in batches.

They come from NZB and vBE, I don't seem to have received any from my other vBSEO-powered sites.

Both use Datastore_Filecache style file caching. No EA or whatever that thing is.

From what I know, the only other people experiencing this are vBSEOed, so lets see if we can track it down.

Okay..

Checking the times against my error log in cPanel, I see the following entries at the same time as my email was generated:

Code:

[Mon Apr 30 11:41:11 2007] [error] PHP Warning:  mysql_errno(): 12 is not a valid MySQL-Link resource in /home/nzboards/public_html/forums/includes/class_core.php on line 856
[Mon Apr 30 11:41:11 2007] [error] PHP Warning:  mysql_error(): 12 is not a valid MySQL-Link resource in /home/nzboards/public_html/forums/includes/class_core.php on line 838
[Mon Apr 30 11:41:11 2007] [error] PHP Warning:  mysql_query(): 12 is not a valid MySQL-Link resource in /home/nzboards/public_html/forums/includes/class_core.php on line 364

The relevant lines in class_core.php are all about how vB sends the sql errors:

364 (* Executes an SQL query through the specified connection):

PHP Code:

if ($queryresult = $this->functions[$buffered ? 'query' : 'query_unbuffered']($this->sql, $link)) 


856 (Returns the numerical value of the error message from previous database operation):

PHP Code:

$this->errno = $this->functions['errno']($this->connection_recent); 


838 (Returns the text of the error message from previous database operation):

PHP Code:

$this->error = $this->functions['error']($this->connection_recent); 


So.. there's some more information.

Does it always happen on the same type of pages? (archive pages)
Also, are you using the latest vBSEO?

Just a quote from you vb.com post for reference:

Database error in vBulletin 3.6.0:

Invalid SQL:

UPDATE adminutil SET
text = UNIX_TIMESTAMP()
WHERE title = 'datastorelock' AND text < UNIX_TIMESTAMP() - 15;

MySQL Error :
Error Number :
Date : Saturday, September 9th 2006 @ 08:16:05 PM
Script : http://www.xxxx.com/forums/archive/i.../f-34-p-5.html
Referrer :
IP Address : 72.30.215.139
Username :
Classname : vb_database

I'm pretty sure I am using the latest vBSEO, and I'm using the unreleased 3.6.6 vB at the moment.

It's been happening since at least 3.6.0.. looks like the first email I can find was August 27, 2006. 3.6.0 time.

Does it happen in the same forums area though (archive pages)?

Sorry, yes.. always on archive pages.

I have started getting errors as well

PHP has encountered an Access Violation at 7C82FA21

and

Database error in vBulletin :

mysql_connect(): Can't connect to MySQL server on 'localhost' (10061)
C:\Inetpub\vhosts\my domain\httpdocs\forum\includes\class_core.php on line 273

People are complaining of the site running slow, this has only happened after upgrading vBSEO to 3.0.0 and upgrading the sitemap. Hope this helps.

Please try to comment out this line in archive/index.php:

PHP Code:

exec_shut_down(); 


Alrighty then, will do, and will report what happens over the next few days.

As I don't know what causes the error, I wont be sure until I don't get the error for a while.

Disable the archive. problem solved

/me slaps Brian around a bit with a large trout

so did that fix your problem? i'm still getting those

Hi Mj,

It did indeed.

well thank u!