Smug RSS Feeds & WordPress

SciurusNiger

I use two RSS feeds on my WordPress-powered wildlife rehab site to link to my Smug galleries and they are apparently generating hundreds of error messages and thereby using up precious server space.

Here's the beginning of one (1Mb) error message:

WordPress database error Got a packet bigger than 'max_allowed_packet' bytes for query INSERT INTO `wp_options`

Has anyone had this problem or have any idea what might be wrong?

Thanks bunches,
PJ.

Twoofy

SciurusNiger wrote: »

I use two RSS feeds on my WordPress-powered wildlife rehab site to link to my Smug galleries and they are apparently generating hundreds of error messages and thereby using up precious server space.

Here's the beginning of one (1Mb) error message:

WordPress database error Got a packet bigger than 'max_allowed_packet' bytes for query INSERT INTO `wp_options`

Has anyone had this problem or have any idea what might be wrong?

Thanks bunches,
PJ.

Hello PJ,

This is an error from your wordpress database - specifically an error with MySQL. As you point out in your question, wordpress is sending a query to your mysql database (INSERT into wp_options...), but the length of that query has exceeded the value that mysql is configured for. For example, if that setting was "100 bytes" (which would be very small) then a query that had more then 100 characters in it would not be able to be inserted into the database.

I will confess that I am a bit perplexed why wordpress would be complaining about an insert into the wp_options table. That table is used to store default settings, standard options, that sort of thing. But I hope this gives you some clues.

The fixes are to either reconfigure mysql to allow larger queries, or figure out what is causing such a large query in the first place and reduce its size.

- Greg

SciurusNiger

Thanks, Greg. I've been tied up with my mom unexpectedly in the hospital so am only now getting back to this.

After digging into the error log more, it seems that the culprit is the RSS feeds. They are being placed into a sidebar widget but my guess is that one of the feed parameters Smug generates isn't playing nice with Wordpress. So I cut it off and, so far, no more problems.

Before:
http://www.garneredimages.com/hack/feed.mg?Type=nicknameRecentPhotos&Data=SciurusNiger&format=rss200

After:
http://www.garneredimages.com/hack/feed.mg?Type=nicknameRecentPhotos&Data=SciurusNiger

Thought I'd post this in case anyone else runs into something similar.

Happy new year!

PJ.

Twoofy wrote: »

Hello PJ,

This is an error from your wordpress database - specifically an error with MySQL. As you point out in your question, wordpress is sending a query to your mysql database (INSERT into wp_options...), but the length of that query has exceeded the value that mysql is configured for. For example, if that setting was "100 bytes" (which would be very small) then a query that had more then 100 characters in it would not be able to be inserted into the database.

I will confess that I am a bit perplexed why wordpress would be complaining about an insert into the wp_options table. That table is used to store default settings, standard options, that sort of thing. But I hope this gives you some clues.

The fixes are to either reconfigure mysql to allow larger queries, or figure out what is causing such a large query in the first place and reduce its size.

- Greg