Database error in vBulletin 4.2.2 after upgrade

[Bryanb]

Hi All,

I just upgraded from 4.1.3 to 4.2.2 yesterday, and since then I've been getting a crapload of database errors like the following:


Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = '';
MySQL Error :
Error Number :
Request Date : Friday, November 15th 2013 @ 12:33:04 PM
Error Date : Friday, November 15th 2013 @ 12:33:04 PM
Script : http://www.mywebsite.com/forums/external.php?type=RSS2
Referrer :
IP Address : 72.14.199.3
Username : Unregistered
Classname : vB_Database
MySQL Version :
++++++++++++++++++++++

Each one refers to an RSS URL and has a different IP (all are from Unregistered users). How do I trouble shoot this. I've never really messed with RSS feeds in vBulletin.

I should add that I've turned off vBSEO since it is no longer supported and does not work with the current version of vB. I hope that is not the problem.

[Zachery]

That is the ENTIRE database error?

[Bryanb]

That is the ENTIRE database error?

Yes, that's it (that's what I receive via email).

[Zachery]

Was it just one email?

[Bryanb]

Was it just one email?

Sorry, no. They are coming in about one every one to two minutes. here are the last three:

Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = '';
MySQL Error :
Error Number :
Request Date : Friday, November 15th 2013 @ 08:40:43 PM
Error Date : Friday, November 15th 2013 @ 08:40:43 PM
Script : http://www.mywebsite.com//forums/external.php?type=RSS2
Referrer :
IP Address : 82.145.222.99
Username : Unregistered
Classname : vB_Database
MySQL Version :

Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = '';
MySQL Error :
Error Number :
Request Date : Friday, November 15th 2013 @ 08:34:44 PM
Error Date : Friday, November 15th 2013 @ 08:34:44 PM
Script : http://www.mywebsite.com/forums/external.php?type=RSS2&forumids=4
Referrer :
IP Address : 209.85.238.169
Username : Unregistered
Classname : vB_Database
MySQL Version :

Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = '';
MySQL Error :
Error Number :
Request Date : Friday, November 15th 2013 @ 08:33:43 PM
Error Date : Friday, November 15th 2013 @ 08:33:43 PM
Script : http://www.mywebsite.com/forums/external.php?type=RSS2&forumids=4
Referrer :
IP Address : 209.85.238.169
Username : Unregistered
Classname : vB_Database
MySQL Version :

I've gone through them and these are all being generated by unregistered users with differing IPs..

When clicking the URL, it's a blank page with this message:

XML Parsing Error: no element found
Location: http://www.mywebsite.com/forums/external.php?type=RSS2
Line Number 1, Column 1:

[Zachery]

Go into the AdminCP > Maintenance > Clear System cache

See if that improves anything.

[Bryanb]

Did that about an hour ago. I'm still getting these notofications.

[Zachery]

Ask your webhost what their MySQL max_packet_size and wait_timeout are.

[Bryanb]

Ok - will do.

[Bryanb]

My site admin guy is on leave at the moment, so I haven't been able to get the info on the server's max packet size data. One thing I have found out is that it only applies to some of the RSS feed links. On the main forum section, there is the little RSS feed image that you click to get the feed for each forum. Most of these work fine. But a handful when clicked open up to a page that states:

XML Parsing Error: no element found
Location: http://www.myforum.com/forums/extern...SS2&forumids=4
Line Number 1, Column 1:

I've tried to repair/optimize RSS feed tables in the admin control panel, but this had no effect. Is there something else that I can do? This only happened after the upgrade.

[Bryanb]

Any ideas?

[Zachery]

Still need you to make those adjustments

[Bryanb]

Still need you to make those adjustments

What adjustments?

[Bryanb]

My max packet size is 16 MB and waitout time is 28.800. Any ideas on how to fix the broken RSS feeds? Please let me know. Thanks!

[Zambfd]

The same Problem here.

VB 4.1.3 & 4.2.2
Max Packet Size, wait timeout is more than adequate (commercial used boards with an expensive hardware setup behind it, no private hosting)
Cache clear and rebuilding the cache table is not working.


http://www.vbulletin.com/forum/forum...-after-upgrade
http://www.vbulletin.com/forum/forum...ase-error-help