Yeah, I know that, the original photos are indeed ok, not so sure about my extensive edits in picasa. The problem I am reporting is that as far as I can tell it was Ccleaner that wrecked the database. I'm hoping piriform will change the defaults so it does not do that. I notice that they have added to picasa to the list of applications, I'm pretty sure that wasn't there before.
Thanks for the link to rebuild the database, I'll try that.