Tags: network | rss | snow_leopard

Gosh, its a long time since I updated this isn't it..? Since my last post so much has happened. The iPad has been released, Ubuntu Lucid has arrived. And the Microsoft Courier has shown to be vaporware. How would of thought, eh...?

There's also been a new release of OS X, bring it to 10.6.4. To keep up-to-date I use Fever RSS by Shaun Inman. I've been using this for about a year and its been great. Up until I upgraded a Mac Mini to 10.6.4. And then Fever RSS stopped working. What happened, and how did I fix the problem...?

Well, I couldn't see anything in PHP logs, but I did happen on this thread. Based on this I realised that Fever RSS comes with an error console. This is displayed with:

https://myserver.org.uk/fever/?errors/

From this I quickly found the problem to be:

MySQL Error: Table './fever_rss/fever_feeds' is marked as crashed and should be repaired. (145)<br />Query: SELECT 
`last_refreshed_on_time` FROM `fever_feeds` WHERE 1 ORDER BY `last_refreshed_on_time` DESC LIMIT 1

This I've seen before, so I logged into Mysql and used the following to fix it:

repair table fever_feeds;

and to double check the repairs succeeded:

CHECK TABLE fever_feeds;

And all is well again...!