[CMS] 4.0.2 upgrade database errors

[smoke10010]

Hello,

I did the 4.0.2 upgrade, lost all my templates and reverted everything back to the basics and this error won't go away:

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT cacheid, data, expires, locktime, serialized
FROM cache
WHERE cacheid in ();

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 ')' at line 3
Error Number : 1064
Request Date : Saturday, February 20th 2010 @ 05:16:52 PM
Error Date : Saturday, February 20th 2010 @ 05:16:52 PM
Script : http://onhercam.com/network/
Referrer : http://onhercam.com/network/
IP Address : 173.32.90.123
Username : Staff
Classname : vB_Database
MySQL Version : 5.0.58-log4

http://onhercam.com/network/

Any idea what would be causing this?

[smoke10010]

The only 2 products I have installed at VBulletin Blog and the CMS

[smoke10010]

SELECT cacheid, data, expires, locktime, serialized
FROM cache
WHERE cacheid in ();

Is there a way to just completely disable the cache so the forums will at least load? Seems like it can't figure what to use as the cacheid in the brackets and it's leaving it blank.

[smoke10010]

I've narrowed it down to this:

/vb/cache/db.php line 154

$rst = vB::$db->query_read_slave("
SELECT cacheid, data, expires, locktime, serialized
FROM " . TABLE_PREFIX . "cache
WHERE cacheid in (" . implode(',' , $cacheids) . ")"
);

[smoke10010]

And finally.. this may have fixed it.

1. I removed " WHERE cacheid in (" . implode(',' , $cacheids) . ") " so the new mysql statement came out like this:

$rst = vB::$db->query_read_slave("
SELECT cacheid, data, expires, locktime, serialized
FROM " . TABLE_PREFIX . "cache"
);

I then completely reloaded the website which may have completely refreshed the cache.

Then I added the code back in and reset everything back to it's original form.

The forum started working properly and things are loading but we're missing a lot of the old data... at least the forums load... I'm not sure if this is a real solution or if it will happen again. An admin or someone with more experience may be able to comment further.

[smoke10010]

And on a final note... if you do use this "fix" ... you will need to republish all your articles if you want them to show up in the site search which affects the latest articles, etc.

[Destron]

How terrible that nobody came to help, this is why I'm holding off on upgrading

[Zachery]

I would advise if you're not getting support on the forums to start a support ticket.

[crazyace]

So was this ever fixed?

[shiaforums]

Database error in vBulletin 4.1.0:

Invalid SQL:

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vb_types.types';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, December 18th 2010 @ 12:24:55 PM
Error Date : Saturday, December 18th 2010 @ 12:25:06 PM
Script : **********************************
Referrer : http://***********************
IP Address : **********
Username : ******
Classname : vB_Database
MySQL Version :

[Steve Machol]

This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:

http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265

Also from the MySQL site:

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html