EduardoSantos 40 Posted September 25, 2017 Share Posted September 25, 2017 Hi, I have a duplicate genre on a music library. I have already checked all MP3 tags, deleted NFOs and XMLs on the artist\albun folders. On the tags there is only the "Balada Americana" with the uppercase "A". Moving the artist\abum folders out of the library causes both genres not to be displayed but when I return them back, Emby recreates the duplicate genre. I am running Emby Server version 3.2.32.0 on a Windows 10 box. How can I proceed to get rid of the second genre? server-63641950839.txt Link to comment Share on other sites More sharing options...
Luke 37064 Posted September 25, 2017 Share Posted September 25, 2017 Hi, you don't delete the genre. What you do is update the tags in your audio files, and then the genre should go away with a library scan. Let us know if this helps. Thanks ! Link to comment Share on other sites More sharing options...
ginjaninja 533 Posted September 26, 2017 Share Posted September 26, 2017 from your log it looks like you have two types of tag.. one with small a - americana and one with large A - Americana. a utility like mp3tag can show 'extended tags' to find all these spurious tags... mp3tag's 'file-remove tags' can remove different tag versions so no chance of 'cross purposes' ultimately emby uses the output of ffprobe to populate genres..running ffprobe against your files will confirm exactly which one(s) is/are causing issue..but something like mp3tag will be needed to fix. Sent from my SM-G955F using Tapatalk Link to comment Share on other sites More sharing options...
EduardoSantos 40 Posted September 26, 2017 Author Share Posted September 26, 2017 (edited) Dear sirs, Thanks for your answer. I am currently using MP3Tag to tag all mp3 files. I have already triple-checked and there are no double tags: only the uppercase format is being used. For the sake of doubt, I removed all those existing files from the library and created a single new MP3 file tagged by MP3Tag. After removal of the existing MP3 files, Emby deleted both uppercase and lowercase genres. After insertion of the newly created MP3 file, Emby showed both upper and lowercase genres again. Also, though there are other double word genres with mixed upper and lowercase on my music library but Emby only shows two separate genres for this "Balada Americana"/"Balada americana". For all other double word genres, no matter they have mixed upper and lowercases, Emby will show only one instance. Please, help me solve this mystery. This is a premium installation and customer is asking for an answer.... Edited September 26, 2017 by EduardoSantos Link to comment Share on other sites More sharing options...
EduardoSantos 40 Posted September 26, 2017 Author Share Posted September 26, 2017 I also included below the results of the ffprobe command for that single newly created file: ffprobe -v error -show_format -show_streams "C:\Users\Public\Music\Artista Eduardo\Album Eduardo\01 Musica Eduardo.mp3" [STREAM] index=0 codec_name=mp3 codec_long_name=MP3 (MPEG audio layer 3) profile=unknown codec_type=audio codec_time_base=1/44100 codec_tag_string=[0][0][0][0] codec_tag=0x0000 sample_fmt=s16p sample_rate=44100 channels=2 channel_layout=stereo bits_per_sample=0 id=N/A r_frame_rate=0/0 avg_frame_rate=0/0 time_base=1/14112000 start_pts=353600 start_time=0.025057 duration_ts=6228541440 duration=441.364898 bit_rate=320000 max_bit_rate=N/A bits_per_raw_sample=N/A nb_frames=N/A nb_read_frames=N/A nb_read_packets=N/A DISPOSITION:default=0 DISPOSITION:dub=0 DISPOSITION:original=0 DISPOSITION:comment=0 DISPOSITION:lyrics=0 DISPOSITION:karaoke=0 DISPOSITION:forced=0 DISPOSITION:hearing_impaired=0 DISPOSITION:visual_impaired=0 DISPOSITION:clean_effects=0 DISPOSITION:attached_pic=0 TAG:encoder=LAME3.99r [SIDE_DATA] side_data_type=Replay Gain side_data_size=16 [/SIDE_DATA] [/STREAM] [FORMAT] filename=C:\Users\Public\Music\Artista Eduardo\Album Eduardo\01 Musica Eduardo.mp3 nb_streams=1 nb_programs=0 format_name=mp3 format_long_name=MP2/3 (MPEG audio layer 2/3) start_time=0.025057 duration=441.364898 size=17658127 bit_rate=320064 probe_score=51 TAG:album=Album Eduardo TAG:artist=Artista Eduardo TAG:album_artist=Artista Eduardo TAG:composer=Compositor Eduardo TAG:genre=Balada Americana TAG:title=Musica Eduardo TAG:track=1 TAG:date=1984 [/FORMAT] Link to comment Share on other sites More sharing options...
PenkethBoy 2063 Posted September 26, 2017 Share Posted September 26, 2017 (edited) i had this a couple of months ago the way i fixed the issue was to correct the source of the upper and lower case tags(genres) in the media files - with mp3tag then go into the library.db directly and delete the duplicate entry with the lower case text when you remove a media file with incorrect tags the Emby clean up does not delete the genre entries from the database unfortunately - as you are seeing You will need "DB Browser for SQL Lite" to do the deletion of the record you do not want. Make a copy of your Library.DB first with Emby shutdown then open the the db in the browser. Go to "Browse Data" tab - pick the "TypedbaseItems" table then filter in the "Type" field with "MediaBrowser.Controller.Entities.Audio.MusicGenre" and look at the following fields Name, Sortname, Clean Name and you should be able to see which row has the lowercase A in your case. Delete the row and then save the file. Run up Emby and hopefully the duplicate entry should be gone. If you dont want to do the above then you could just delete the library.db (with Emby shut down) and it will get recreated without the error assuming you have corrected all the input files first after you rescan your media etc Edited September 26, 2017 by PenkethBoy Link to comment Share on other sites More sharing options...
Happy2Play 8281 Posted September 26, 2017 Share Posted September 26, 2017 i had this a couple of months ago the way i fixed the issue was to correct the source of the upper and lower case tags(genres) in the media files - with mp3tag then go into the library.db directly and delete the duplicate entry with the lower case text when you remove a media file with incorrect tags the Emby clean up does not delete the genre entries from the database unfortunately - as you are seeing You will need "DB Browser for SQL Lite" to do the deletion of the record you do not want. Make a copy of your Library.DB first with Emby shutdown then open the the db in the browser. Go to "Browse Data" tab - pick the "TypedbaseItems" table then filter in the "Type" field with "MediaBrowser.Controller.Entities.Audio.MusicGenre" and look at the following fields Name, Sortname, Clean Name and you should be able to see which row has the lowercase A in your case. Delete the row and then save the file. Run up Emby and hopefully the duplicate entry should be gone. If you dont want to do the above then you could just delete the library.db (with Emby shut down) and it will get recreated without the error assuming you have corrected all the input files first after you rescan your media etc Rename/bakup this db as your userdata is stored there also, it this is the route you take, Link to comment Share on other sites More sharing options...
Luke 37064 Posted September 26, 2017 Share Posted September 26, 2017 did you run a library scan after using mp3tag? Link to comment Share on other sites More sharing options...
EduardoSantos 40 Posted September 27, 2017 Author Share Posted September 27, 2017 Yes, @@Luke, I forced a library scan. In fact there was a library scan previous to adding the mp3 file wich caused both genres to disapear, then added the mp3 file and another scan wich made both genres come back. Link to comment Share on other sites More sharing options...
EduardoSantos 40 Posted September 27, 2017 Author Share Posted September 27, 2017 Rename/bakup this db as your userdata is stored there also, it this is the route you take, Thank you very much, @@Happy2Play, I will proceed just as you mentioned to tackle my customer problem but will keep the original db as @@Luke may find a way to solve the problem and improve Emby. Anyway I will post the results. Link to comment Share on other sites More sharing options...
EduardoSantos 40 Posted September 27, 2017 Author Share Posted September 27, 2017 i had this a couple of months ago the way i fixed the issue was to correct the source of the upper and lower case tags(genres) in the media files - with mp3tag then go into the library.db directly and delete the duplicate entry with the lower case text when you remove a media file with incorrect tags the Emby clean up does not delete the genre entries from the database unfortunately - as you are seeing You will need "DB Browser for SQL Lite" to do the deletion of the record you do not want. Make a copy of your Library.DB first with Emby shutdown then open the the db in the browser. Go to "Browse Data" tab - pick the "TypedbaseItems" table then filter in the "Type" field with "MediaBrowser.Controller.Entities.Audio.MusicGenre" and look at the following fields Name, Sortname, Clean Name and you should be able to see which row has the lowercase A in your case. Delete the row and then save the file. Run up Emby and hopefully the duplicate entry should be gone. If you dont want to do the above then you could just delete the library.db (with Emby shut down) and it will get recreated without the error assuming you have corrected all the input files first after you rescan your media etc It worked like a charm! Thank you very, very much! 1 Link to comment Share on other sites More sharing options...
PenkethBoy 2063 Posted September 27, 2017 Share Posted September 27, 2017 I assume you mean the sql root or did you go the nuclear option? Link to comment Share on other sites More sharing options...
EduardoSantos 40 Posted September 28, 2017 Author Share Posted September 28, 2017 Installed DB Browser for SQL Lite and then edited the table according to the above directions. Link to comment Share on other sites More sharing options...
Happy2Play 8281 Posted September 28, 2017 Share Posted September 28, 2017 Installed DB Browser for SQL Lite and then edited the table according to the above directions. By chance have you Refreshed your Music library to see if it comes back? Link to comment Share on other sites More sharing options...
EduardoSantos 40 Posted September 28, 2017 Author Share Posted September 28, 2017 Yes, First with the sole mp3 created for testing purposes.Then I brought all the content back and did various library scans.I also detected a second genre with the sabe problem and solved it by using the same method. Zero problems now. (I kept he defective db for the sake of debug in case @@Luke asked for it) Thanks everybody 1 Link to comment Share on other sites More sharing options...
Luke 37064 Posted September 28, 2017 Share Posted September 28, 2017 Just editing your audio tags should be sufficient. 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