Jump to content


Photo

How to remove duplicate Movie Genre

genre duplicate

  • Please log in to reply
34 replies to this topic

#21 dcol OFFLINE  

dcol

    Advanced Member

  • Members
  • 1076 posts
  • Local time: 06:57 PM
  • LocationTucson, Arizona

Posted 29 October 2018 - 01:48 PM

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.



#22 dcol OFFLINE  

dcol

    Advanced Member

  • Members
  • 1076 posts
  • Local time: 06:57 PM
  • LocationTucson, Arizona

Posted 30 October 2018 - 10:54 AM

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 by dcol, 30 October 2018 - 10:56 AM.


#23 Happy2Play OFFLINE  

Happy2Play

    Trial and Error

  • Moderators
  • 16076 posts
  • Local time: 05:57 PM
  • LocationWashington State

Posted 30 October 2018 - 04:32 PM

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.



#24 Luke OFFLINE  

Luke

    System Architect

  • Administrators
  • 139848 posts
  • Local time: 08:57 PM

Posted 30 October 2018 - 05:07 PM

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.



#25 Gilgamesh_48 OFFLINE  

Gilgamesh_48

    Advanced Member

  • Members
  • 744 posts
  • Local time: 08:57 PM
  • LocationTennessee

Posted 30 October 2018 - 07:13 PM

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.



#26 dcol OFFLINE  

dcol

    Advanced Member

  • Members
  • 1076 posts
  • Local time: 06:57 PM
  • LocationTucson, Arizona

Posted 30 October 2018 - 07:57 PM

Thanks, I will look at these options tmw



#27 dcol OFFLINE  

dcol

    Advanced Member

  • Members
  • 1076 posts
  • Local time: 06:57 PM
  • LocationTucson, Arizona

Posted 01 November 2018 - 10:36 AM

Genre Cleaner did not remove the duplicate Genres. They were in the Genre Cleaner settings, and I deleted it from there. Now it is gone from the Genre Cleaner list, but still remains in the actual Genre page. Tried restarting the server, no change. Guess I need to repair the DB after all.



#28 dcol OFFLINE  

dcol

    Advanced Member

  • Members
  • 1076 posts
  • Local time: 06:57 PM
  • LocationTucson, Arizona

Posted 01 November 2018 - 10:53 AM

So I installed SQLiteDatabaseBrowserPortable and I opened Library.db

Can't find where the Genres are located. The Item ID's are not unreadable. Not even sure if library.db is the correct place to look.

What table would I find the Genre's in and then what steps do I take to apply the change?

 

If I just delete the Library.db, will Emby recreate it?



#29 dcol OFFLINE  

dcol

    Advanced Member

  • Members
  • 1076 posts
  • Local time: 06:57 PM
  • LocationTucson, Arizona

Posted 01 November 2018 - 11:22 AM

I stopped Emby server, renamed the library.db to library.old, restarted the server and re-scanned the library.

Not only did that rebuild the library and fix the duplicates, but the library.db went from 450MB to 19MB and sped up Emby.

Shouldn't there be a way to schedule a library.db cleaning? Or is there a plugin for that?



#30 PenkethBoy OFFLINE  

PenkethBoy

    Advanced Member

  • Members
  • 3409 posts
  • Local time: 01:57 AM
  • LocationWarrington,UK

Posted 01 November 2018 - 11:34 AM

What version of the Emby server are you using?

 

As you say the ID are not readable i guess you are on the Stable Server

 

If you delete the library.db it will be recreated on startup (although you may lose some of your metadata customisation) - although this may not solve your problem as the lowercase genre may be embedded in a video file and/or in an nfo (if you use them) and the library scan may pick it up again

 

Although the newer versions of the Stable server have changes in place to prevent this problem now - as its a long time since i have seen a lowercase genre being picked up. 

 

[edit]

 

Good you solved it :)


Edited by PenkethBoy, 01 November 2018 - 11:34 AM.


#31 Happy2Play OFFLINE  

Happy2Play

    Trial and Error

  • Moderators
  • 16076 posts
  • Local time: 05:57 PM
  • LocationWashington State

Posted 01 November 2018 - 12:48 PM

I stopped Emby server, renamed the library.db to library.old, restarted the server and re-scanned the library.

Not only did that rebuild the library and fix the duplicates, but the library.db went from 450MB to 19MB and sped up Emby.

Shouldn't there be a way to schedule a library.db cleaning? Or is there a plugin for that?

 

Of course a new database will be smaller and will grow over the next day or so.  Did you restore any userdata, since you deleted it also?  


Edited by Happy2Play, 01 November 2018 - 12:49 PM.


#32 Gilgamesh_48 OFFLINE  

Gilgamesh_48

    Advanced Member

  • Members
  • 744 posts
  • Local time: 08:57 PM
  • LocationTennessee

Posted 01 November 2018 - 12:56 PM

Genre Cleaner did not remove the duplicate Genres. They were in the Genre Cleaner settings, and I deleted it from there. Now it is gone from the Genre Cleaner list, but still remains in the actual Genre page. Tried restarting the server, no change. Guess I need to repair the DB after all.

Just want to say that the better way to handle this using Genre Cleaner would be not to delete the unwanted entry but rather to map the unwanted entry to the wanted one. This allows Emby to be as initially "wrong" as it wants to be but fixes it later.

 

Also I think that the delete only happens on the next full library refresh so that simply deleting a genre will have no effect at all until the library fully refreshes. After a full refresh the deleted genre may well be gone.


  • Happy2Play likes this

#33 dcol OFFLINE  

dcol

    Advanced Member

  • Members
  • 1076 posts
  • Local time: 06:57 PM
  • LocationTucson, Arizona

Posted 01 November 2018 - 01:02 PM

I did not restore the userdata. Really don't have any and made very few changes to the metadata except for some images.

Didn't know I could combine genres in the cleaner.

 

Rebuiding the DB did remove the duplicate Genres



#34 nomatches4mikey OFFLINE  

nomatches4mikey

    Member

  • Members
  • 17 posts
  • Local time: 01:57 AM

Posted 13 December 2018 - 10:05 PM

Finally got this resolved on my server.  I had a lot of older library entries with media.xml files.  I deleted all the xml files, then edited the library database to remove the genres starting with lower case (after shutting down Emby Server and making a backup, of course.)  Then restarted server and performed a full library scan.  Now the extra genres are gone.



#35 Luke OFFLINE  

Luke

    System Architect

  • Administrators
  • 139848 posts
  • Local time: 08:57 PM

Posted 13 December 2018 - 10:12 PM

Thanks for the feedback. Newer releases of Emby Server are better at preventing this from happening, though they won't necessarily clean up older existing duplicates for you.







Also tagged with one or more of these keywords: genre, duplicate

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users