Limit size of RSS feedtext

[Ghostt]

Database error in vBulletin 3.8.4:

Invalid SQL:

		REPLACE INTO vbexternalcache
			(cachehash, dateline, text, headers, forumid)
		VALUES
			(


...........

MySQL Error   : Got a packet bigger than 'max_allowed_packet' bytes
Error Number  : 1153
Script:    /external.php?type=RSS2

I am getting this error i think because there come to mutch BIG Theards to rss .
for example first 200 characters.

How can i limit the size of the text in rss?
if it isnt possible we need urgent a mod to find!

[Ghostt]

no support?

[kh99]

Well, maybe you could increase the max packet size? If you google the error message you will find many web pages discussing how to do it.

[Ghostt]

no thats a bad solution. i dont want to overload my server by increasing the size....

the theards are just to big...

only 1 soultion is there by limit the words shown in rss

[kh99]

OK, well, I have a few more ideas: if you request the feed like this:

external.php?type=RSS2&&fulldesc=false&nohtml=true

then the size will be limited to whatever "Length of Thread Preview Text" in "Forum Display Options" is set to. You could force this by creating a plugin using "external_start" with the code:

$vbulletin->GPC['fulldesc'] = false;
$vbulletin->GPC['nohtml'] = true;

you might also be able to set $vbulletin->options['threadpreview'] to whatever you want at the same time.


Another thing you could do is disable caching by a plugin on the "external_complete" hook with the code

$insert_cache = false;

but of course that would affect your performance. But maybe you could do it conditionally with something like:

if (strlen($output) > some value)
{
    $insert_cache = false; 
}

Also, I don't think it would be very hard to modify the caching to allow it to use more than one database record, but that would require modifying the external.php file.

I haven't tried any of this.

[Ghostt]

thanks for the help, but i need a solution that not effet on perfomance.

[Ghostt]

Does noone has a idea for this?