spoiler alert The answer to this post is in a comment below.
I had an awesome debug session on my iPhoto project tonight. This is the kind of mystery that programmers live for, in my opinion. It’s a pretty easy puzzle in retrospect (my 7-year-old saw the answer right away), but it thrilled me when I realized the solution. Read on…
I’m querying the iPhoto SQLite database to find all of the faces that the user has tagged. Out of my 5,000 photos, I found 10 that had duplicates. I was concerned that my SQL query had a problem, like I once forgot the clause “AND isInTrash=0”. But that was not the case this time.
I picked one of the offending photos and dug into the data. I saw that it had three recognized faces: one “Dan Dolan” and two “Holly Dolan”. Once I opened up the actual photo, the light bulb illuminated. Below is a cropped version.
Answer to the mystery in a comment below.