Jump to content

Two genres for the price of one


khodges747

Recommended Posts

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.

Link to comment
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.

Link to comment
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?

Link to comment
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
Link to comment
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
Link to comment
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.

Link to comment
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?

Link to comment
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
Link to comment
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
Link to comment
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.

Link to comment
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...