GoHuskies 0 Posted November 25, 2017 Posted November 25, 2017 I have two genres listed for comedy - "Comedy" and "comedy", and they contain the same movies. I've checked the genres for several of the movies in the "comedy" genre and in every case the genre is shown as "Comedy" with a capital "C". Any suggestions for how to eliminate the extraneous "comedy" genre? Screen shot is attached. Thanks!
Luke 39009 Posted November 25, 2017 Posted November 25, 2017 Hi, this can be tricky but there's got to be a movie with the lowercase value
Happy2Play 9230 Posted November 25, 2017 Posted November 25, 2017 Haven't seen this reported in awhile. If you have no media with a lowercase genre it then becomes a database issue and you either need to rebuild your database or use a database tool to edit the current database.
PenkethBoy 2066 Posted November 26, 2017 Posted November 26, 2017 and check the metadata that may be contained in the video file
GoHuskies 0 Posted November 26, 2017 Author Posted November 26, 2017 I've searched the file contents for everything in my movies folder and come up empty. Every instance of "Comedy" (for the genre tags) in the movie.xml and .nfo files is upper-case. Two questions - where is Emby actually pulling the genre info? PenkethBoy mentioned metadata for the video file, but I thought it was just pulling from the .nfo file (or maybe the movie.xml file). Second, how would I rebuild the database, as Happy2Play mentioned? Thanks!
nomatches4mikey 8 Posted December 2, 2017 Posted December 2, 2017 I had this show up after using the Genre Cleaner, it may be related to how it changes the genre data.
GoHuskies 0 Posted January 13, 2018 Author Posted January 13, 2018 Hi, trying again to get rid of this duplicate "comedy" genre. I'm certain it's not due to a lowercase "comedy" genre tag in an nfo file, here's why - I moved all my movie folders to another location except for one comedy, re-scanned my library and confirmed the "comedy" genre (the duplicate) was still showing. I then moved that movie folder to another location, copied back a different comedy, re-scanned my library and still see the duplicate "comedy" genre. I looked at the genres for both test movies and both show uppercase "Comedy", not lowercase "comedy". Any ideas for what to try next? Thanks!
PenkethBoy 2066 Posted January 13, 2018 Posted January 13, 2018 Emby does not delete genres even when no existing movie etc uses it - you need to delete it directly from the DB - i did this recently when cleaning up a few other loose ends - had about 25 unused genre entries as for where the lower case came from - have you checked (as i suggested in November) all you media files for metadata e.g. mp3tag reads MP4 and MKV files besides mp3 - emby will pull data from the files themselves and genre is one of the few currently supported
Luke 39009 Posted January 13, 2018 Posted January 13, 2018 Emby does not delete genres even when no existing movie etc uses it - you need to delete it directly from the DB - i did this recently when cleaning up a few other loose ends - had about 25 unused genre entries This isn't true. You don't need to do this.
GoHuskies 0 Posted January 13, 2018 Author Posted January 13, 2018 Luke, can you give me an idea of what to try next? Is Emby looking for genre data in places other than just the .nfo files? Thanks!
GoHuskies 0 Posted January 18, 2018 Author Posted January 18, 2018 This issue has been resolved. As PenkethBoy suggested, I removed a record in library.db and that eliminated the duplicate genre (lowercase "comedy"). For anyone having the same issue, here are the details of what I did: Before editing the library.db file, I saved a copy, just in case. I used a database application (DbVisualizer, since I use it at work and am familiar with it) to open the library.db file. It's located in C:\Users\[username]\AppData\Roaming\Emby-Server\data\library.db. Note - Emby Server has to be stopped in order to edit library.db. I queried the TypedBaseItems table to find the incorrect record. In my case, there was a record of type 'MediaBrowser.Controller.Entities.Genre' with a Name of 'comedy' (note the lowercase; the valid records had a Name of 'Comedy', uppercase). The Path for this record was "C:\Users\HTPC\AppData\Roaming\Emby-Server\metadata\Genre\comedy", which no longer existed on my system. I then deleted this invalid record. I restarted Emby Server and scanned my library. Once that was done the incorrect genre was gone. Hope this helps.
PenkethBoy 2066 Posted January 18, 2018 Posted January 18, 2018 great that it worked for you those type of "orphaned" entries are what i removed from my db from a bit of testing the newer version (.60) of the server is better at keeping things in check i suspect the entries we have had to delete were created with an older version of the server which did not have the new checks in place
Luke 39009 Posted January 18, 2018 Posted January 18, 2018 i suspect the entries we have had to delete were created with an older version of the server which did not have the new checks in place I think this is correct, yes.
dcol 170 Posted October 28, 2018 Posted October 28, 2018 I have this problem also, but I do not have a db editor, nor should I need one.
Happy2Play 9230 Posted October 28, 2018 Posted October 28, 2018 I have this problem also, but I do not have a db editor, nor should I need one. So are you saying you see this on a NEW install? How old is your server installation?
dcol 170 Posted October 29, 2018 Posted October 29, 2018 So are you saying you see this on a NEW install? How old is your server installation?Yes. 2 weeks
Happy2Play 9230 Posted October 29, 2018 Posted October 29, 2018 And did you find the metadata that was causing the issue?
Happy2Play 9230 Posted October 29, 2018 Posted October 29, 2018 @@dcol I can't even add media with lowercase genre to reproduce this issue. Only uppercase Genre is displayed on genre tab while lower case link in item exist. So you may need to provide move information of your issue. Windows v3.5.3.0
dcol 170 Posted October 29, 2018 Posted October 29, 2018 (edited) Here is an example of what I have in the Genre listing. Metadata was from the MovieDB, not me. Don't see a field for Genre in the Edit Metadata screen Edited October 29, 2018 by dcol
Luke 39009 Posted October 29, 2018 Posted October 29, 2018 did you explore the entire edit metadata screen?
dcol 170 Posted October 29, 2018 Posted October 29, 2018 Yes, It shows what genre categories are assigned to the movie. I looked all all the metadata under the 'Science fiction' section and there were no duplicates and none had 'Science fiction' they were all 'Science Fiction'. How do I get rid of this extra category? Or for that matter, how do I edit the genre categories to display only the ones I want.
dcol 170 Posted October 30, 2018 Posted October 30, 2018 (edited) Bump... How do I get rid of this duplicate? Do I really need to learn how to use a DB editor? If so, which one is recommended that's free. Edited October 30, 2018 by dcol
Happy2Play 9230 Posted October 30, 2018 Posted October 30, 2018 Don't know how to reproduce this. You currently have two options, do the manual edit or delete your entire database and start over. I use SQLiteDatabaseBrowserPortable.
Luke 39009 Posted October 30, 2018 Posted October 30, 2018 I don't believe this situation will happen anymore starting with the next release of the server, although it may not correct duplicates created by older versions. thanks.
Gilgamesh_48 1080 Posted October 30, 2018 Posted October 30, 2018 I use a plugin called "Genre Cleaner" to clean up my genres. With that I map things that, for me, are redundant like all the various "Audiobook" genres to just "AudioBooks." That may or may not be the solution for others but it does do what I need.
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