Server deleted my tags

[Smitty018210 143]

5 minutes ago, Luke said:

Right I was just curious if you know for certain that it's from a theme song or if you just think that it is.

@luke

I am going to copy all of them into a different folder and try and add them as a music library.

If I do this will emby allow me to see the tags?

[Happy2Play 9780]

Just now, Smitty018210 said:

@luke

I am going to copy all of them into a different folder and try and add them as a music library.

If I do this will emby allow me to see the tags?

Just blanket search and select all and drop into m3ptag to see if you see the tag on any item

[Smitty018210 143]

18 minutes ago, Happy2Play said:

Just blanket search and select all and drop into m3ptag to see if you see the tag on any item

Yeah I already tired that. They don't show up there either.

I doubted that the issue was from the locally saved trailers. So that was the first thing I tried before ending up here looking for help.

Edited March 5, 2024 by Smitty018210

[MBSki 1114]

1 hour ago, Happy2Play said:

Example but "Removing item from database"

2024-03-04 09:23:35.950 Debug BaseItem: Removed item 1954 Audio C:\Users\Media\Desktop\Videos\Music - emby metadata\Blake Shelton\The Dreamer (2003)\Blake Shelton - 01 - Heavy Liftin'.flac
2024-03-04 09:23:35.950 Info App: Removing item from database, Type: Audio, Name: Heavy Liftin', Path: C:\Users\Media\Desktop\Videos\Music - emby metadata\Blake Shelton\The Dreamer (2003)\Blake Shelton - 01 - Heavy Liftin'.flac, Id: 1954

 

If a tag is deleted would it show the actual tag name? I seem to have a ton of "Removing Item from database", but there is no reference to the actual tag that was deleted.

[Happy2Play 9780]

Just now, MBSki said:

If a tag is deleted would it show the actual tag name? I seem to have a ton of "Removing Item from database", but there is no reference to the actual tag that was deleted.

Doesn't look like it does as deleting a tag from a item and scanning the tag disapears but don't see anything in the log.

[MBSki 1114]

4 minutes ago, Happy2Play said:

Doesn't look like it does as deleting a tag from a item and scanning the tag disapears but don't see anything in the log.

Ok, thanks. I'm not sure what info I can provide then @Luke. Tags have definitely been deleted though and I'd really like to know why and which tags were deleted.

[Happy2Play 9780]

7 minutes ago, MBSki said:

Ok, thanks. I'm not sure what info I can provide then @Luke. Tags have definitely been deleted though and I'd really like to know why and which tags were deleted.

I would guess they were removed from the item they were attached to.

[MBSki 1114]

1 minute ago, Happy2Play said:

I would guess they were removed from the item they were attached to.

Yes, they were, but I don't know which items that happened to.

[Smitty018210 143]

@Happy2Play@LukeSo Happy suggested that I use Mp3tag to see if I could find those where the phantom tags were coming from, but I had already tried that before come here to the forums.

However I decided to revisit Mp3tag and try something different. I looked around the program a bit and found an option to delete all tags from the mp3.

So I decided to try that see if that would fix this phantom tag issue.

I took all my themes and loaded them into the program and told it to delete all tags.

After which I ran a fresh library scan and they are still there?!? Even with all the tags deleted those phantom tags are still there.

Luke are them coming from my locally saved trailers? What else could be causing this?

[Happy2Play 9780]

11 minutes ago, Smitty018210 said:

Luke are them coming from my locally saved trailers?

shouldn't be as I have tons of local trailers and never had tags on my primary systems.  Only play with tags on test systems though.

But minus finding the tag name in database mediaitems name column with type 34, and getting the itemid and going to the itemlinks2 table and putting that id in linkedid to get the item it is linked to (itemid), then going back to mediaitems table and ensuring you clear the type and name filter and enter the itemid from linkedid table to see what is attached to that tag.

Edited March 5, 2024 by Happy2Play

[Smitty018210 143]

@Happy2PlayI don't have time to do it tonight, but what I am going to do is remove all the movie from my library and then add 10 movies at a time back in. That way when those tags pop up again I will at least I've narrow it down to those 10 movies I just added.

I'll let you guys know what I find. Thanks for the help Happy.

[Smitty018210 143]

@Happy2Play@Luke

Well, that was not fun.....

After uninstalling my server and reinstalling it, I added my movies back 10 at a time narrowing down were all the phantom tags where coming from.

Turns out it was BOTH Trailers and theme files at fault.

For what ever reason some theme.mp3 and Trailer.MOV files apparently had hidden tags in them.

Once I deleted those files. Poof not more phantom tags.

 

[Happy2Play 9780]

2 minutes ago, Smitty018210 said:

@Happy2Play@Luke

Well, that was not fun.....

After uninstalling my server and reinstalling it, I added my movies back 10 at a time narrowing down were all the phantom tags where coming from.

Turns out it was BOTH Trailers and theme files at fault.

For what ever reason some theme.mp3 and Trailer.MOV files apparently had hidden tags in them.

Once I deleted those files. Poof not more phantom tags.

 

Thanks for testing.  But would have been nice to have a copy of that media to test with.  So if anyone knows or offending theme.mp3 or trailer can you post a copy.

[Smitty018210 143]

14 minutes ago, Happy2Play said:

Thanks for testing.  But would have been nice to have a copy of that media to test with.  So if anyone knows or offending theme.mp3 or trailer can you post a copy.

Sorry no, they were permanently deleted.

[MBSki 1114]

53 minutes ago, Happy2Play said:

Thanks for testing.  But would have been nice to have a copy of that media to test with.  So if anyone knows or offending theme.mp3 or trailer can you post a copy.

If the issue is with theme songs, could the solution be to delete all the theme songs via the plug-in and re-download?

[Happy2Play 9780]

1 minute ago, MBSki said:

If the issue is with theme songs, could the solution be to delete all the theme songs via the plug-in and re-download?

Only if the info is not reread from offending themes as they are all coming from the plugin correct.

[MBSki 1114]

1 minute ago, Happy2Play said:

Only if the info is not reread from offending themes as they are all coming from the plugin correct.

Yes, good point. I suppose the hole would be that the offending tags are in outdated theme.mp3 files, but there's no guarantee. I suppose I can try and see if any of the tags disappear. What other solution is there to get rid of the tags? I have more than 3,000 movies and I'm not going to remove and re-add them.

[Happy2Play 9780]

Matter of finding that needle in the haystack.  If you do find it make sure you post a copy of it.

But as mentioned blanket search theme.mp3 and drop into mp3tag to see if you see the offending theme assuming that is the issue.

Edited March 5, 2024 by Happy2Play

[MBSki 1114]

59 minutes ago, Happy2Play said:

Matter of finding that needle in the haystack.  If you do find it make sure you post a copy of it.

But as mentioned blanket search theme.mp3 and drop into mp3tag to see if you see the offending theme assuming that is the issue.

I dumped my entire movie folder into mp3tag. Then I searched for the mysterious tags. This might have one of the offending tags (Bandes originales de films). Can you take a look?

[Happy2Play 9780]

39 minutes ago, MBSki said:

I dumped my entire movie folder into mp3tag. Then I searched for the mysterious tags. This might have one of the offending tags (Bandes originales de films). Can you take a look?

Yes I added that Theme to The Good Dinosaur and tag was created.

 

Made a copy of library.db

Used the tagid from url but could have looked it up via name column in mediaitems

http://localhost:8091/web/index.html#!/list/list.html?tagId=18257&serverId=xxxxxxxx9157745edbd86c96723848014&parentId=3

input tagid into itemlinks2 linkedid to get the item that is linked to the tag.

Back to mediaitems table to look for that id

@Luketheme.mp3 tags being used.  In this case it looks like the Grouping tag.  But now there is a test candidate at least in this specific example.

 

Edited March 5, 2024 by Happy2Play

[MBSki 1114]

Excellent. that's a start. Might want to check this one too. It appears this offending tag (PMEDIA) is showing up in quite a few different extended tags.

[Smitty018210 143]

@Happy2PlayOk, while I was waiting for my server to run a scan and put back the collections menu, thanks again Happy, I dug through one of my old hard drives to see if I had a backup for one of my movie files that had a trailer that was causing the phantom tags.

I found one.

 

 

Edited March 5, 2024 by Smitty018210

[Happy2Play 9780]

5 minutes ago, Smitty018210 said:

@Happy2PlayOk, while I was waiting for my server to run a scan and put back the collections menu, thanks again Happy, I dug through one of my old hard drives to see if I had a backup for one of my movie files that had a trailer that was causing the phantom tags.

I found one.

 

 

 

trailer.mov 12.3 MB · 0 downloads

Have not applied it to a item yet but the tag would be "Movie Trailer" correct ie the Grouping tag.

C:\Users\Media\Desktop\TEST\system>ffprobe -i "C:\Users\Media\Downloads\trailer.mov"
ffprobe version 5.1-emby_2023_06_25 Copyright (c) 2007-2022 the FFmpeg developers and softworkz for Emby LLC
  built with gcc 12.2.0 (Rev10, Built by MSYS2 project)
Input #0, mov,mp4,m4a,3gp,3g2,mj2, from 'C:\Users\Media\Downloads\trailer.mov':
  Metadata:
    major_brand     : M4V
    minor_version   : 1
    compatible_brands: M4V M4A mp42isom
    creation_time   : 2006-01-14T00:27:57.000000Z
    copyright       :
    copyright-eng   :
    title           : Click
    artist          : Sony Pictures
    composer        : Sony Pictures
    album           : Click
    grouping        : Movie Trailer
    genre           : Movie Trailer
    date            : 2006
    comment         : In theaters 2006
  Duration: 00:02:30.19, start: 0.000000, bitrate: 687 kb/s
  Stream #0:0[0x1](eng): Audio: aac (LC) (mp4a / 0x6134706D), 44100 Hz, stereo, fltp, 128 kb/s (default)
    Metadata:
      creation_time   : 2006-01-14T00:27:57.000000Z
      handler_name    : Apple Sound Media Handler
      vendor_id       : [0][0][0][0]
  Stream #0:1[0x2](eng): Video: h264 (Constrained Baseline) (avc1 / 0x31637661), yuv420p(tv, smpte170m/smpte170m/bt709, progressive), 320x172, 555 kb/s, Level 13, 23.98 fps, 23.98 tbr, 2997 tbn (default)
    Metadata:
      creation_time   : 2006-01-14T00:27:57.000000Z
      handler_name    : Apple Video Media Handler
      vendor_id       : [0][0][0][0]

C:\Users\Media\Desktop\TEST\system>

 

[Smitty018210 143]

1 minute ago, Happy2Play said:

Have not applied it to a item yet but the tag would be "Movie Trailer" correct ie the Grouping tag.

C:\Users\Media\Desktop\TEST\system>ffprobe -i "C:\Users\Media\Downloads\trailer.mov"
ffprobe version 5.1-emby_2023_06_25 Copyright (c) 2007-2022 the FFmpeg developers and softworkz for Emby LLC
  built with gcc 12.2.0 (Rev10, Built by MSYS2 project)
Input #0, mov,mp4,m4a,3gp,3g2,mj2, from 'C:\Users\Media\Downloads\trailer.mov':
  Metadata:
    major_brand     : M4V
    minor_version   : 1
    compatible_brands: M4V M4A mp42isom
    creation_time   : 2006-01-14T00:27:57.000000Z
    copyright       :
    copyright-eng   :
    title           : Click
    artist          : Sony Pictures
    composer        : Sony Pictures
    album           : Click
    grouping        : Movie Trailer
    genre           : Movie Trailer
    date            : 2006
    comment         : In theaters 2006
  Duration: 00:02:30.19, start: 0.000000, bitrate: 687 kb/s
  Stream #0:0[0x1](eng): Audio: aac (LC) (mp4a / 0x6134706D), 44100 Hz, stereo, fltp, 128 kb/s (default)
    Metadata:
      creation_time   : 2006-01-14T00:27:57.000000Z
      handler_name    : Apple Sound Media Handler
      vendor_id       : [0][0][0][0]
  Stream #0:1[0x2](eng): Video: h264 (Constrained Baseline) (avc1 / 0x31637661), yuv420p(tv, smpte170m/smpte170m/bt709, progressive), 320x172, 555 kb/s, Level 13, 23.98 fps, 23.98 tbr, 2997 tbn (default)
    Metadata:
      creation_time   : 2006-01-14T00:27:57.000000Z
      handler_name    : Apple Video Media Handler
      vendor_id       : [0][0][0][0]

C:\Users\Media\Desktop\TEST\system>

 

Yes, "Movie Trailer" was the tag that was coming up for the phantom tags relating to the trailers.

[Happy2Play 9780]

11 minutes ago, MBSki said:

Excellent. that's a start. Might want to check this one too. It appears this offending tag (PMEDIA) is showing up in quite a few different extended tags.

@Lukewould have to confirm what tag is being capture here but will guess Grouping.

C:\Users\Media\Desktop\TEST\system>ffprobe -i "C:\Users\Media\Downloads\theme2.mp3"
ffprobe version 5.1-emby_2023_06_25 Copyright (c) 2007-2022 the FFmpeg developers and softworkz for Emby LLC
  built with gcc 12.2.0 (Rev10, Built by MSYS2 project)
Input #0, mp3, from 'C:\Users\Media\Downloads\theme2.mp3':
  Metadata:
    title           : The Lost City of D
    artist          : Pinar Toprak
    track           : 1/28
    album           : The Lost City: Music from the Motion Picture
    disc            : 1/1
    genre           : Films/Games
    TLEN            : 152000
    MusicBrainz Release Group Id: 57054d5d-3b45-44b6-aa45-db0f8b0adbf9
    TORY            : 2022
    MusicBrainz Release Track Id: 5a6b19f4-9d9c-4572-a725-8c27b9ca57f4
    copyright       : PMEDIA
    encoded_by      : PMEDIA
    grouping        : PMEDIA
    TIT3            : PMEDIA
    performer       : PMEDIA
    comment         : PMEDIA
    composer        : Pinar Toprak
    album_artist    : Pinar Toprak
    TSRC            : USKLP2200276
    SCRIPT          : Latn
    TMED            : Digital Media
    TSO2            : Toprak, Pinar
    artist-sort     : Toprak, Pinar
    publisher       : Paramount Music
    Credits         : PMEDIA
    Provider        : PMEDIA
    Uploader        : PMEDIA
    ITUNESADVISORY  : 0
    originalyear    : 2022
    ARTISTS         : Pinar Toprak
    BARCODE         : 859760670950
    RELEASECOUNTRY  : PMEDIA
    ID3v1 Comment   : PMEDIA
    MusicBrainz Album Status: official
    MusicBrainz Album Release Country: GB
    MusicBrainz Album Type: album/soundtrack
    MusicBrainz Album Id: dec8f837-73be-4238-9c42-cd7dc139abe0
    MusicBrainz Artist Id: 13ce7457-3916-4ce1-aedb-cf4f5d4275e0
    MusicBrainz Album Artist Id: 13ce7457-3916-4ce1-aedb-cf4f5d4275e0
    date            : 2022-03-25
    encoder         : Lavf59.17.100
  Duration: 00:02:32.11, start: 0.025056, bitrate: 160 kb/s
  Stream #0:0: Audio: mp3, 44100 Hz, stereo, fltp, 128 kb/s, Start-Time 0.025s
    Metadata:
      encoder         : Lavc59.21
  Stream #0:1: Video: png, rgb24(pc), 500x500 [SAR 1:1 DAR 1:1], 90k tbr, 90k tbn, Start-Time 0.025s (attached pic)
    Metadata:
      comment         : Cover (front)