I recently had a situation where several missing pictures were turning up in my "Photos" app. They were images I had previously deleted, but somehow turned up again days after an update after a reboot. I may never know why and I doubt it'll happen again.
HOWTO: Reset the File Indexer
It's really trivially easy to fix this. However, if this breaks your phone, do not blame me, I don't have any idea what I'm doing.
- cd /var/luna/data
- stop fileindexer
- rsync -vaP mediadb.db3 mediadb.oops.db3
- delete from com_palm_media_image | sqlite3 mediadb.db3
- start fileindexer
That's it. Fixed.