ebr 14910 Posted March 13, 2017 Share Posted March 13, 2017 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 More sharing options...
khodges747 55 Posted March 13, 2017 Author Share Posted March 13, 2017 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 More sharing options...
khodges747 55 Posted March 13, 2017 Author Share Posted March 13, 2017 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 More sharing options...
Happy2Play 8281 Posted March 13, 2017 Share Posted March 13, 2017 Did you delete the record I showed above in screenshot? The Server Configuration Backup can restore users watched status if needed. 1 Link to comment Share on other sites More sharing options...
khodges747 55 Posted March 13, 2017 Author Share Posted March 13, 2017 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!! 1 Link to comment Share on other sites More sharing options...
Happy2Play 8281 Posted March 13, 2017 Share Posted March 13, 2017 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 More sharing options...
khodges747 55 Posted March 13, 2017 Author Share Posted March 13, 2017 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 More sharing options...
Happy2Play 8281 Posted March 13, 2017 Share Posted March 13, 2017 (edited) 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 March 13, 2017 by Happy2Play Link to comment Share on other sites More sharing options...
Happy2Play 8281 Posted March 13, 2017 Share Posted March 13, 2017 (edited) 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 March 13, 2017 by Happy2Play Link to comment Share on other sites More sharing options...
khodges747 55 Posted March 14, 2017 Author Share Posted March 14, 2017 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 More sharing options...
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