feeds results in 500 error

[ormus7577]

Hi,

I'm helping a friend with his blog (on the technical side). Now I'm having a problem that I never had in any other s9y installation. Trying to access feeds results in 500 errors. It used to work though! I'm pretty sure it's a timeout or the silly provider (1und1) killing it for memory/cpu usage. Because the feeds with only few entries (like categories) work. Is there anything I could do to improve the performance? Or is there another possible reason for this problem?

Link:
http://www.rote-couch.com

[garvinhicking]

Hi!

Traffic/DB usage/MEmory is most likely the problem. You can only get the clear message in the CGI error logs, but 1&1 only hands them out when you REALLY bug them.

Regards,
Garvin

[ormus7577]

I think I broke something

Now when trying to call any feed at http://rote-couch.com/ there's an (nasty) sql error messages instead of the feed. I installed the propertiers for categories plugin and uninstalled it. But the options (like hide from rss) are still available in the category admin panel. Any ideas on how to fix this?

[garvinhicking]

Hi!

Actually the RSS feed reveals that serendipity_event_categorytemplates is NOT uninstalled!

You are using an outdated mysql version that does nto support SQL subqueries, which is used by that plugin to be able to hide all entries of specific categories...

So either upgrade mysql or do remove the mentioned plugin through the s9y interface. Check the checkbox, click on "delete selected plugins" or sth like that.

Regards,
Garvin

[ormus7577]

Oops, silly mistake. But, big surprise: The feeds are working again! Not that I do know why... but they are working...