I've been using phpFlickr for a month or two and it's been great.
But twice in the past couple of weeks something has gone wrong with my flickr_cache table, and requests from phpFlickr have generated an error:
"1016 ** Can't open file: 'flickr_cache.MYI' (errno: 144)"
Doing 'REPAIR TABLE flickr_cache' fixes the problem.
So I have two questions:
1) Is this a common problem with the phpFlickr cache? I haven't had it with any of my other web applications using the same database.
2) Should phpFlickr generate some kind of noticeable error when this happens? Or is there some way I can test for an error in my application? At the moment I just get empty arrays back (from photos_getCounts()).
I've never run into this on my server and you're the first to report it, so I don't think it's terribly common. Sometimes something goes wrong with the write in mysql and it just messes up. It can also happen if the hard drive is full and you try to write to a database.
If you look up the PEAR::DB documentation on http://pear.php.net, you can find out how to look for errors using the class.