MBSki 1114 Posted October 25, 2021 Posted October 25, 2021 Why are these 2 different people getting linked together? I favorited Chris Evans (aka Captain America; IMDB: nm0262635) and Chris Evans (IMDB: nm0262632) from Bob the Builder was favorited too. The IMDB numbers are different so these are clearly 2 different people. It seems to be doing a name match only. Is this a bug? Any known workaround?
Happy2Play 9780 Posted October 26, 2021 Posted October 26, 2021 Pretty sure this is the first report of this, but is reproducible. Find any same named actor and favorite one of them.
MBSki 1114 Posted October 26, 2021 Author Posted October 26, 2021 21 minutes ago, Happy2Play said: Pretty sure this is the first report of this, but is reproducible. Find any same named actor and favorite one of them. Well then. That's disappointing. @Luke Can we get this fixed?
MBSki 1114 Posted October 30, 2021 Author Posted October 30, 2021 Following up. @Luke Can you fix this issue?
Happy2Play 9780 Posted October 30, 2021 Posted October 30, 2021 (edited) Looking in the database it is do to same named people having the same userdatakeyid. So they both appear when favorited per that id. So I have 707 instances where this will happen. Execution finished without errors. Result: 707 rows returned in 486ms At line 1: SELECT UserDataKeyId, COUNT(*) c FROM MediaItems GROUP BY UserDataKeyId HAVING c > 1; Edited October 30, 2021 by Happy2Play
MBSki 1114 Posted October 30, 2021 Author Posted October 30, 2021 Oh my. And why are they getting the same userdatakeyid? Don't they have different IMDBid's? Mine did.
Happy2Play 9780 Posted October 30, 2021 Posted October 30, 2021 7 minutes ago, mbarylski said: Oh my. And why are they getting the same userdatakeyid? Don't they have different IMDBid's? Mine did. Yes they all have different ids.
MBSki 1114 Posted October 30, 2021 Author Posted October 30, 2021 30 minutes ago, Happy2Play said: Yes they all have different ids. That's good I suppose. Now we just need @Luke to use the IMDb or TMDB id instead of just a name match.
Happy2Play 9780 Posted October 30, 2021 Posted October 30, 2021 1 minute ago, mbarylski said: That's good I suppose. Now we just need @Luke to use the IMDb or TMDB id instead of just a name match. It is a matter of what generates the UserDataKeyId to make them unique as that appears to what is used in the UserDatas table when favorited. 2
crusher11 1101 Posted October 31, 2021 Posted October 31, 2021 People are a mess. Apparently the director of the original Child's Play starred as Spider-Man in a few MCU movies, according to my server.
Happy2Play 9780 Posted October 31, 2021 Posted October 31, 2021 5 hours ago, crusher11 said: People are a mess. Apparently the director of the original Child's Play starred as Spider-Man in a few MCU movies, according to my server. A old install will maintain these defects where a new install will not. They will be a mess without a total Refresh, and/or rebuild or new database as all old entries will not be replaced properly as this has changed over time from by name to also get their id from provider metadata. 1
MBSki 1114 Posted November 2, 2021 Author Posted November 2, 2021 @Luke Can you provide thoughts on a solution to this issue?
Happy2Play 9780 Posted November 2, 2021 Posted November 2, 2021 5 minutes ago, mbarylski said: @Luke Can you provide thoughts on a solution to this issue? Updating the database so these items don't get same UserDataKeyId.
MBSki 1114 Posted November 2, 2021 Author Posted November 2, 2021 3 minutes ago, Happy2Play said: Updating the database so these items don't get same UserDataKeyId. Was that for me @Happy2Play?
Happy2Play 9780 Posted November 2, 2021 Posted November 2, 2021 1 minute ago, mbarylski said: Was that for me @Happy2Play? Depending on what the dev has to change and how destructive that change will have to be. It may be a issue of having to start over to reindex. But have to what for a comment from Luke. 1 1
Luke 42077 Posted November 11, 2021 Posted November 11, 2021 I think happy2play pretty much covered it.
MBSki 1114 Posted November 11, 2021 Author Posted November 11, 2021 5 hours ago, Luke said: I think happy2play pretty much covered it. @Luke So you're going to fix it then?
MBSki 1114 Posted November 29, 2021 Author Posted November 29, 2021 @Luke Can you please fix this issue?
MBSki 1114 Posted December 6, 2021 Author Posted December 6, 2021 @Luke Following up on this. Can you please fix this issue?
Luke 42077 Posted December 10, 2021 Posted December 10, 2021 Best thing I can do right now is add a change for new installations to base person user data on external IDs. But I can't offer a migration right now, so that means restoring a backup of person user data, e.g. favorite people may no longer work if it was based on the previous method.
MBSki 1114 Posted December 10, 2021 Author Posted December 10, 2021 4 minutes ago, Luke said: Best thing I can do right now is add a change for new installations to base person user data on external IDs. Ok, so if you do that wouldn't we be able to fix it manually by changing the external ID for each person?
Luke 42077 Posted December 10, 2021 Posted December 10, 2021 That and then manually changing the user data for that person to be how you want it.
MBSki 1114 Posted December 10, 2021 Author Posted December 10, 2021 2 minutes ago, Luke said: That and then manually changing the user data for that person to be how you want it. I think that works, but are you saying it won't pull in metadata? I'm not certain what info I would change. So for example, Chris Evans data would all still be there right? I wouldn't have to re-enter all the day below would I?
Luke 42077 Posted December 10, 2021 Posted December 10, 2021 Quote but are you saying it won't pull in metadata? I never said that.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now