Duplicate People

[awildeemby 0]

Hi,

 

I seem to have 3 duplicate entries for the same person. The left most entry contains the majority of the work (1 movie, 3 shows) whereas the other 2 have 1 show each. I went ahead and added the imdb and tvdb IDs to the new entries and reran the "refresh people" task but all the entries remain. Is there an easy way to merge the 3 entries into 1?

 

Cheers

 

 

[dansblackcat 37]

For the two entries that only have 1 show each go into that show and remove the actor from the cast list.  Then run a full scan and then refresh people.

[Happy2Play 9781]

These can be hard to find but as mentioned above you will have to work with the items metadata to try and resolve this.  Could you list the items that appear in each Actor entry.

[awildeemby 0]

For the two entries that only have 1 show each go into that show and remove the actor from the cast list.  Then run a full scan and then refresh people.

I'll give that a go!

 

These can be hard to find but as mentioned above you will have to work with the items metadata to try and resolve this.  Could you list the items that appear in each Actor entry.

Matt Berry

- Movies

- - Moon

- Shows

- - The IT Crowd

- - The Mighty Boosh

- - What We Do in the Shadows

 

Matt Berry

- Shows

- - Toast of London

 

Matt Berry

- Shows

- - Year of the Rabbit

[awildeemby 0]

For the two entries that only have 1 show each go into that show and remove the actor from the cast list.  Then run a full scan and then refresh people.

 

Gave it a go, removed his entry from the 2 shows which gave him a separate entry , rescanned the library and refreshed people. That didn't work immediately, so I edited the metadata for the 2 shows and added him back in. That worked! I should I tried removing and readding him to the shows before, but negelected to rescan and refresh people between those two steps. 

 

Thanks! 

[Luke 42079]

Do you happen to recall that imdb, moviedb, or tvdb id's the three people may have had before? Were any of those values filled in on some of them?

[Happy2Play 9781]

Do you happen to recall that imdb, moviedb, or tvdb id's the three people may have had before? Were any of those values filled in on some of them?

 

I just was testing this on Steven R. Mcqueen (2 entries) as I had one entry with one movie, two series, and one episode and one with two episodes.  They both has the same IMDB and TMDB ids.  No way to see TVDB ids but they are different on every series as actor images are unique to the series on TVDB.

 

Did the same as above, removed person from both episode xmls and did a library scan to remove on person entry and add the actor back to each episode xml and did a scan and those items were added to the existing entry.

 

If I had to guess it would be something with all the database upgrades/migration.  But it does not happen to everyone.

 

Additional note one had a path to metadata\people and the other didn't.  I just happened to remove the one that didn't have Path in MM.

Edited June 12, 2019 by Happy2Play

[Luke 42079]

I just was testing this on Steven R. Mcqueen (2 entries) as I had one entry with one movie, two series, and one episode and one with two episodes.  They both has the same IMDB and TMDB ids.  No way to see TVDB ids but they are different on every series as actor images are unique to the series on TVDB.

 

Did the same as above, removed person from both episode xmls and did a library scan to remove on person entry and add the actor back to each episode xml and did a scan and those items were added to the existing entry.

 

If I had to guess it would be something with all the database upgrades/migration.  But it does not happen to everyone..

 

Are you able to re-create the situation of having the duplicate?

[Happy2Play 9781]

Are you able to re-create the situation of having the duplicate?

 

No, for me it is hard to say as I use MCM and it updates Series metadata with every episode added.  I just by chance doing a search found a duplicate actor.  Also not sure how or if the People backup plugin could have any play in this either.

[Luke 42079]

Yea i need to review what it's doing because it could.

[Happy2Play 9781]

@@Luke

 

But here is another person with different itemids.  Both entries have the same tmdbid.  One with path and the other without.  Both linked to different media.

 

[Luke 42079]

Yea the question is how did they get there because the current core server does a pretty good job of preventing this. So they could either be created by older versions of the server, from the plugin, or some rare edge case.

[Happy2Play 9781]

Things like this are going to be hard to find unless someone is seeing it on a new installation.  But with the metadata\people folder out of the question on a new installation I would think this wouldn't be possible.  But in the OPs case with three entries more information would be needed.  But will keep my eye out for a situation like that.

Edited June 12, 2019 by Happy2Play

[dansblackcat 37]

Most users will probably never even know that they have this issue. 

It was just pure luck that I noticed when I was watching Married with Children that Christina Applegate was only listed in that one series.  When I knew that I have her in heaps more stuff.

Same with Ed O'neill.

[awildeemby 0]

Do you happen to recall that imdb, moviedb, or tvdb id's the three people may have had before? Were any of those values filled in on some of them?

So originally the correct person entry had imdb and tvdb values filled and they were correct. The other 2 with one show entry each had no imdb or tvdb values filled by default. I added in the values manually and rescanned / refreshed people and they remained there. 

 

Yea the question is how did they get there because the current core server does a pretty good job of preventing this. So they could either be created by older versions of the server, from the plugin, or some rare edge case.

Should have stated in my original post, I'm using Emby 4.2.0.15 Beta in Docker on unRaid. I can't say when the container was originally created, but it was probably approximately a month ago, at a stretch 2 months. 

[Luke 42079]

Thanks for the info.

[pünktchen 1409]

Yea the question is how did they get there because the current core server does a pretty good job of preventing this. So they could either be created by older versions of the server, from the plugin, or some rare edge case.

My plugin doesn't create new people items. It only uses existing people entries to set metadata and images.

[Luke 42079]

Can I still take a look at what it's doing? Thanks.

[TeamB 2438]

@@Luke

Did this ever get sorted out? I have a number of TV Show with duplicate people, refreshing meta data does not fix it, any suggestions to fix this automatically? I really dont want to have to check my whole library item by item.

[TeamB 2438]

what table are the people -> item links stored in now?

[TeamB 2438]

think I found it

select
    ItemId,
    MediaItems.name,
    PersonId,
    Role,
    count(1) as PersonCount
from ItemPeople
join MediaItems on MediaItems.Id = ItemPeople.ItemId
group by ItemId, MediaItems.name, PersonId, Role
having PersonCount > 1;

This shows me the duplicate list, example:

 

61159, Star Trek: Picard, 24070, Jean-Luc Picard, 2

 

So the ItemPeople table has duplicate entries for some people.

Edited March 15, 2020 by TeamB

[TeamB 2438]

@@Luke

 

I have about 20 movies and TV shows with duplicate people, some with up to 5 duplicates.

The above query can help me find them but do you have any idea how or why it happened and how I can fix it?

Doing a meta data refresh on an item does not fix it.

[Luke 42079]

@@Luke

 

I have about 20 movies and TV shows with duplicate people, some with up to 5 duplicates.

The above query can help me find them but do you have any idea how or why it happened and how I can fix it?

Doing a meta data refresh on an item does not fix it.

Right, the question is how did they get there, and the things discussed earlier in this thread are possible reasons.

[Luke 42079]

Continued here: https://emby.media/community/index.php?/topic/83753-duplicate-people-new/