Jump to content
khodges747

Two genres for the price of one

Recommended Posts

ebr

If I do this, when I rescan the library this problem will not be recreated, because of Luke's fix, right?

 

I can't guarantee that because we generate a unique ID for everything in the library and this ID would be based on the name and I'm not sure which version of the name would be correct.

Share this post


Link to post
Share on other sites
khodges747

OK, appreciate the help and the honest answer.

 

I'll post again if I get any new results to share.

Share this post


Link to post
Share on other sites
khodges747

I modded the db and nothing changed.

 

First I deleted all entries that had both Comedy or comedy and were Virtual entries. Then I verified all remaining comedy entries for lowercase c. I found none (but the filter isn't case sensitive, so I could have missed something). I then did the same routine for Western and western.

 

I saved the db, restarted MB Server and did a clean database followed by a new scan.

 

Nothing is different in Theater.

 

I reopened the db to check if the mods were still there, and the deleted entries have not been added again, so I don't know where the lowercase genres are hidden. I must be missing an entry somewhere. 

 

If I could do a case-sensitive filter...anybody know how to do that?

Share this post


Link to post
Share on other sites
Happy2Play

Did you delete the record I showed above in screenshot?

 

The Server Configuration Backup can restore users watched status if needed.

  • Like 1

Share this post


Link to post
Share on other sites
khodges747

To be honest, I didn't understand exactly what you had done. But on reading more closely and doing exactly the same I fixed the problem.

 

Thank you for your help!!

  • Like 1

Share this post


Link to post
Share on other sites
Happy2Play

Now if that comes back then there is a genre somewhere in your collection that contains a lower case entry.

Share this post


Link to post
Share on other sites
khodges747

Well, that didn't last long. After the 1st library scan the lowercase genres were back.

 

So I went back into the db and deleted the items you specified again, then filtered the genre for comedy. There are 1763 lines to verify. I've done it twice now and I find not one entry with a lowercase c. I can't look at it any more - I'll go blind or crazy.

 

For western, there are far fewer lines and I found 2 lower case entries, which I changed to uppercase. After the rescan of the library the lowercase genre was back again.

 

WTF?

Share this post


Link to post
Share on other sites
Happy2Play

That is because the library scan sees a mismatch between metadata and database and is rewriting the lowercase entries where ever they are back to the database.

Edited by Happy2Play

Share this post


Link to post
Share on other sites
Happy2Play

Crazy question but do you have any media with embedded metadata?

 

Well I guess it shouldn't matter since that info would be written to nfo metadata.

Edited by Happy2Play

Share this post


Link to post
Share on other sites
khodges747

No embedded metadata.

 

I finally fixed it by modifying the entries in the db that define the genres. It turns out that if you simply change the lowercase c of comedy to uppercase, both in entry for the address of the metadata and for its name, you end up with a genre called Comedy instead of comedy.

 

I did it for both genres and it seems to be holding, including after library scans.

 

Thanks for all your help.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...