Syfaka

Q: Delete incorrect face suggestions

Does anyone know how to prevent incorrect face names from being suggested when tagging new photos in the Photos app?

 

Example:

When tagging a new face, I incorrectly spell “Tom” as “Ton” and press Return by mistake. The incorrect record “Ton” is written to the Person.db database file in the Photos library package. From now on, every time I start typing “To…”, Photos suggests “Tom” and “Ton” in the menu dropping down from the Faces data entry field.

Posted on Apr 19, 2015 2:23 AM

Close

Q: Delete incorrect face suggestions

  • All replies
  • Helpful answers

Previous Page 2
  • by sjbissett,

    sjbissett sjbissett Apr 19, 2015 3:52 PM in response to Rysz
    Level 1 (35 points)
    Apr 19, 2015 3:52 PM in response to Rysz

    I have tried all of the items you mentioned and I still see the unused names.  I even spent an hour on the phone with Apple support yesterday who shadowed my machine and was able to recreate the issue but couldn't find a solution.  How to you rebuild the DB?

  • by Rysz,

    Rysz Rysz Apr 19, 2015 4:21 PM in response to sjbissett
    Level 7 (20,482 points)
    iTunes
    Apr 19, 2015 4:21 PM in response to sjbissett

    Hold down the Option + Command keys when you launch Photos.

  • by sjbissett,

    sjbissett sjbissett Apr 19, 2015 4:26 PM in response to Rysz
    Level 1 (35 points)
    Apr 19, 2015 4:26 PM in response to Rysz

    I rebuilt the library and re-tried your suggestion, still no luck for me...

  • by Syfaka,

    Syfaka Syfaka Apr 20, 2015 12:35 AM in response to Rysz
    Level 1 (1 points)
    Apr 20, 2015 12:35 AM in response to Rysz

    Indeed, deleting records without understanding all the dependencies in the various database tables is asking for big trouble... thanks for highlighting this!

     

    Dragging over the incorrect face name over the correct one was the first thing I tried, followed by a full reboot. It didn't work for me; the incorrect face name continued to appear as a suggestion. I don't use the iCloud Photo Library.

  • by Syfaka,

    Syfaka Syfaka Apr 20, 2015 12:45 AM in response to sjbissett
    Level 1 (1 points)
    Apr 20, 2015 12:45 AM in response to sjbissett

    DB Browser for SQLite (http://sqlitebrowser.org/). Please consider Rysz's warning about deleting records records in system databases without understanding the dependencies!

     

    I opened the library package, copied the Person.db to a different location on my hard drive (to avoid messing up the original) and opened the copy with the SQLite browser. Scroll through the various tables in the database and you'll find the incorrect face names.

  • by lthaddix,

    lthaddix lthaddix Apr 22, 2015 4:22 AM in response to Syfaka
    Level 1 (0 points)
    Apr 22, 2015 4:22 AM in response to Syfaka

    Just to add to the discussion...There was mention that Apple Support suggested rebuilding the data base.  That did not work for me.  I deleted all the photos in my library and then deleted them again from the "Show Recently Deleted" file.  I then re-checked my iCloud.com account to ensure there were no photos remaining.  I rebooted my computer and then checked my photo library again to ensure there were no photos remaining.  I then deleted the actual .photoslibrary file from my computer, rebooted, and then created a new .photoslibrary file.  At this point, I should have a "start from scratch" photos library.  I then imported one photo into the new library.  When I attempted to add a new name to this one photo, I noticed that all the names from my previously deleted library (correct and incorrect) were still being suggested in the drop-down list.  I am not a Mac expert, but it is possible the incorrect names are being kept in another file outside of the photos application, particularly since they are grouped with the contact list names in the drop-down list.  I suppose one could remove the Photos App and reinstall it to see if the incorrect names disappeared from the drop-down list, but that is a step I am not going to take. 

  • by sjbissett,Solvedanswer

    sjbissett sjbissett Apr 23, 2015 6:13 PM in response to lthaddix
    Level 1 (35 points)
    Apr 23, 2015 6:13 PM in response to lthaddix

    I figured out a way to get rid of them but proceed at your own risk if you decide  to try it for yourself.  Make sure you have a backup....

     

    I opened the file person.db in database folder of the packaged pictures library using sqlite browser. Found the unwanted names in the RK person table and changed the name to "null."  I tried to delete the entry but could't so I chose to change the name to null.  It worked and I have not experienced any issues with my photos library!

  • by sjbissett,

    sjbissett sjbissett Apr 23, 2015 6:49 PM in response to sjbissett
    Level 1 (35 points)
    Apr 23, 2015 6:49 PM in response to sjbissett

    I Should also add that I had to reboot my machine to see the changes

  • by Syfaka,

    Syfaka Syfaka Apr 24, 2015 8:02 AM in response to sjbissett
    Level 1 (1 points)
    Apr 24, 2015 8:02 AM in response to sjbissett

    Bold move and happy to hear it worked!

    I'll give it a try on my machine.

  • by Syfaka,

    Syfaka Syfaka Apr 24, 2015 9:56 AM in response to sjbissett
    Level 1 (1 points)
    Apr 24, 2015 9:56 AM in response to sjbissett

    Your method seems to be spot on! I removed 2 incorrect suggestions, by over-writing "null" in the name field of the RKPerson table of the Person.db database file, located in the database folder of the Photos library package.

     

  • by Dbrillh,

    Dbrillh Dbrillh Apr 24, 2015 10:26 AM in response to Syfaka
    Level 1 (54 points)
    Safari
    Apr 24, 2015 10:26 AM in response to Syfaka

    I think there is a simpler method than some of the drastic measures posted here.  I have been able to select a page of named photos, linked to the incorrect name, then click on the name in the upper left corner and you can edit it.  If you spell it like it is on other, correctly named, photos, it will merge these photos into the correctly named list, and the incorrect name will no longer appear in the drop down of suggested names (usually). 

     

    It usually works, but in a couple of instances the incorrect name still appeared as a suggestion from a file name, not from the faces database.

     

    The only problem with this approach is that not all methods of getting to the faces page reveal the name in the upper left corner.  I think that using search to find the name usually does not work, but clicking on the name in an identified circle will open the window of named photos with the name as an editable entity in the upper left.

  • by Syfaka,

    Syfaka Syfaka Apr 24, 2015 11:33 AM in response to Dbrillh
    Level 1 (1 points)
    Apr 24, 2015 11:33 AM in response to Dbrillh

    I hadn't tried your suggestion before, so I tested it after reading your post. In my case it didn’t work.

     

    For the avoidance of doubt, I wanted to eliminate misspelled/incorrect name suggestions from the box dropping down from this menu,

    2.jpg

    in the default Faces Album of Photos

    1.jpg.

     

    Merging incorrectly tagged photos with correct records never presented a problem.

  • by Rysz,

    Rysz Rysz Apr 24, 2015 12:17 PM in response to Rysz
    Level 7 (20,482 points)
    iTunes
    Apr 24, 2015 12:17 PM in response to Rysz

    UPDATE:

    When I wrote my earlier posts, what I described worked as I explained. The next date I updated my Mac to a beta version of OS X and now dragging one face group circle over another no longer works. The current behavior is to rename the "wrong" face group name to the "correct" one and both groups will be combined automatically and all individual "wrong" faces will be rekabeled with the "correct" one.

     

    The suggested name list still works the same way. Please check your Contacts list. If, by chance, you have that "incorrect" name in Contacts, it will continue to be suggested in Faces.

  • by sjbissett,

    sjbissett sjbissett Apr 24, 2015 12:10 PM in response to Dbrillh
    Level 1 (35 points)
    Apr 24, 2015 12:10 PM in response to Dbrillh

    This method didn't work for me.    It did rename the photos but the old name still appears as an auto suggestion. 

  • by Matt Sephton,

    Matt Sephton Matt Sephton Apr 15, 2016 9:05 AM in response to Syfaka
    Level 2 (254 points)
    Apr 15, 2016 9:05 AM in response to Syfaka

    Sorry to resurrect the post, but @Syfaka do you have an person "null" after editing the Person.db?

Previous Page 2