Jump to content


Photo

Some items will not add to collections

collections

  • Please log in to reply
10 replies to this topic

#1 maximumentropy OFFLINE  

maximumentropy

    Advanced Member

  • Members
  • 92 posts
  • Local time: 05:11 AM

Posted 26 July 2019 - 12:19 PM

Server version:  4.2.0.40

Logs:  Available upon request

 

I have some items that will not add to any collections.  I locate the item (movie or TV show) in the library or by searching, click the checkbox in the web interface, Choose "Add to collection", then either choose an existing collection or type a new collection name, then click Ok.  For affected media items, it is not added to the collection.  If a new collection was being created, it is created without any new media items in it.

 

For unaffected media items, the item is added without issue.

 

I can't figure out any rhyme or reason to which items are affected.  The only thing they seem to have in common is that they were all previously in a "To Watch" collection and then vanished from there some time ago (maybe 6-12 months).

 

I saw that some collection fixes were being planned for the latest 4.2.0.40 release, so I waited until now to report it.  After upgrading this morning, I'm still seeing this problem.  As far as I know, none of the affected items are "multiple version" media items.

 

Thanks!

 



#2 Luke OFFLINE  

Luke

    System Architect

  • Administrators
  • 140578 posts
  • Local time: 05:11 AM

Posted 26 July 2019 - 12:23 PM

Hi there, please discuss an example. Thanks.



#3 maximumentropy OFFLINE  

maximumentropy

    Advanced Member

  • Members
  • 92 posts
  • Local time: 05:11 AM

Posted 26 July 2019 - 12:52 PM

1.  Here I locate and select a movie which is affected:

 

5d3b2e2403bff_1.jpg

 

 

2. Here I enter the name of a new collection:

 

5d3b2e468f6f7_2.jpg

 

 

3:  After clicking Ok I see the item in the new collection (this step doesn't happen if adding to an existing collection):

 

5d3b2e999cb52_3.jpg

 

 

 

4. I click the browser refresh button and see that the collection is actually empty despite the previous display:

 

5d3b2ecfbb0bf_4.jpg

 

 

5. Navigating to my Collections list, the newly added "Example Collection" is entirely missing since it was a new collection and didn't contain other existing items:

 

5d3b2f95612f0_5.jpg



#4 blade005 OFFLINE  

blade005

    Advanced Member

  • Alpha Testers
  • 725 posts
  • Local time: 04:11 AM

Posted 26 July 2019 - 01:31 PM

Server version:  4.2.0.40

Logs:  Available upon request

 

I have some items that will not add to any collections.  I locate the item (movie or TV show) in the library or by searching, click the checkbox in the web interface, Choose "Add to collection", then either choose an existing collection or type a new collection name, then click Ok.  For affected media items, it is not added to the collection.  If a new collection was being created, it is created without any new media items in it.

 

For unaffected media items, the item is added without issue.

 

I can't figure out any rhyme or reason to which items are affected.  The only thing they seem to have in common is that they were all previously in a "To Watch" collection and then vanished from there some time ago (maybe 6-12 months).

 

I saw that some collection fixes were being planned for the latest 4.2.0.40 release, so I waited until now to report it.  After upgrading this morning, I'm still seeing this problem.  As far as I know, none of the affected items are "multiple version" media items.

 

Thanks!

 

I have not encountered this issue recently, but I have in the past.

 

Item would just not show in the Collection selected or a NEW one created. The odd thing was that the collection.xml file created had the correct path to the item. I tried removing the item from my collection, scanning the library to remove it and then adding it back in with the same result. If I remember correctly, the only way to get it to show in a collection was to either move it to another folder in my library that created a new path or to change the name of the file to alter the original path and name (i.e. append with 1080p) to the end of the media file. Once the original path, file name and/or both were changed then it would get added to a collection and display. Even then, if I tried to return the item to the original path and name it would no longer show in the Collection.

 

FYI. I recently performed a fresh install of Emby Server 4.1 and let it create a new library.db file. I was having issues with duplicate actors and thought it was a good time to rebuild the library since it was one that had migrated from early version 3 and then to 4. I backed up my Collection folder and moved it over to the new install. This was about a week ago and since then no issues with duplicate actors and after seeing your post I went back to a known item that I had to rename to get it to show in a collection. I was able to rename it to the original filename and Emby Server registered the change and I was able to add it back to the collection with success. Emby Server updated to 4.2.0.40 today and Collections still seem to be displaying as expected.


Edited by blade005, 26 July 2019 - 03:57 PM.


#5 PenkethBoy OFFLINE  

PenkethBoy

    Advanced Member

  • Members
  • 3428 posts
  • Local time: 10:11 AM
  • LocationWarrington,UK

Posted 26 July 2019 - 03:50 PM

Yes i see this as well

 

My suspicion is that its database related - as the ones i have checked that wont add to a collection at some point were Multi version movies - this may not cover all reasons why as there could be more than one cause

 

it appears the database is not cleaned properly when a movie goes from being multi version back to single version - and this somehow prevents collections working



#6 Luke OFFLINE  

Luke

    System Architect

  • Administrators
  • 140578 posts
  • Local time: 05:11 AM

Posted 26 July 2019 - 03:52 PM

it appears the database is not cleaned properly when a movie goes from being multi version back to single version - and this somehow prevents collections working

 

Is this repeatable?



#7 Happy2Play OFFLINE  

Happy2Play

    Trial and Error

  • Moderators
  • 16268 posts
  • Local time: 02:11 AM
  • LocationWashington State

Posted 30 July 2019 - 08:23 PM

Performed the same steps in post 4 and was not able to reproduce.  But do see a database cleanup issue (Cars set) was removed (additional test items with periods in name).

 

5d40d8d481f6c_collection.jpg

 

 

5d40d8e735090_db.jpg

 

Removed the three Cars Movies and AdditionalParts remained in database.

 

5d40d922c1fcc_db2.jpg

 

Once I figured out how to remove those two entries as they are linked to other tables, the collection groups properly.  So overall the issue I just tested is a database cleanup issue sort of specific to a specific OS.  But I know there are endless scenarios.  I would assume a new installation would not see these issue.


Edited by Happy2Play, 30 July 2019 - 08:24 PM.


#8 PenkethBoy OFFLINE  

PenkethBoy

    Advanced Member

  • Members
  • 3428 posts
  • Local time: 10:11 AM
  • LocationWarrington,UK

Posted 30 July 2019 - 08:37 PM

Happy - what did you do to get over the linked table issue you mentioned?

 

I assume this was when you tried to manually delete the left over records?

 

This is not anything to do with an old db - a new install does not fix it



#9 Luke OFFLINE  

Luke

    System Architect

  • Administrators
  • 140578 posts
  • Local time: 05:11 AM

Posted 30 July 2019 - 09:06 PM

Period in the title, the filename, or both?

#10 Happy2Play OFFLINE  

Happy2Play

    Trial and Error

  • Moderators
  • 16268 posts
  • Local time: 02:11 AM
  • LocationWashington State

Posted 30 July 2019 - 09:29 PM

Happy - what did you do to get over the linked table issue you mentioned?

 

I assume this was when you tried to manually delete the left over records?

 

This is not anything to do with an old db - a new install does not fix it

 

First looked at the MediaItems to see the ID then deleted that ID from ItemLinks and ListItems, then MediaItems for the additionalparts items. 



#11 Happy2Play OFFLINE  

Happy2Play

    Trial and Error

  • Moderators
  • 16268 posts
  • Local time: 02:11 AM
  • LocationWashington State

Posted 30 July 2019 - 09:30 PM

Period in the title, the filename, or both?

 

Just in the filename.

 

Those were test files I was testing the beta.  I didn't see a issue when I did a new database or after the manual database edit.


Edited by Happy2Play, 30 July 2019 - 09:31 PM.






Also tagged with one or more of these keywords: collections

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users