TV Library Smart Collections fail to load correctly

General Discussions Plex Features
, ,
1

PMS Version 1.22.3.4392
PlexWeb Version 4.56.3

I just got done creating a bunch of Smart Collections. They seem to work perfectly for my admin account but the TV Collections are empty on my test user account.

Movie Smart Collections do seem to load correctly for my test user.

What my admin account sees
Imgur

What my test user account sees
Imgur

User account also has access to the “Edit Filters” menu
Stuff loads here, but not in the actual collection.
Imgur

Plex console logs

[Transcode] SQLITE3:(nil), 1, no such column: grandchildren.originally_available_at in "select distinct(metadata_items.id) from metadata_items join metadata_items as parents on parents.id=metadata_items.parent_id join metadata_items as

and

Soci Exception handled: sqlite3_statement_backend::prepare: no such column: grandchildren.originally_available_at for SQL: select distinct(metadata_items.id) from metadata_items join metadata_items as parents on parents.id=metadata_items.parent_id join metadata_items as grandparents on grandparents.id=parents.parent_id join media_items on media_items.metadata_item_id=metadata_items.id join media_parts on media_parts.media_item_id=media_items.id where metadata_items.library_section_id in (1) and (grandchildren.originally_available_at<"2021-04-23 21:12:59" and grandchildren.originally_available_at>"2021-04-21 21:12:59" and (metadata_items.metadata_type=2 or metadata_items.metadata_type=10)) order by metadata_items.audience_rating desc, grandparents.title_sort collate icu_root asc, parents.`index` IS NULL,parents.`index` asc, metadata_items.`index` IS NULL,metadata_items.`index` asc, metadata_items.originally_available_at IS NULL,metadata_items.originally_available_at asc, metadata_items.title_sort collate icu_root asc, metadata_items.id asc limit 50
4 Likes
2

I am experiencing the exact same issue. I posted about it on Reddit and there seems to be more people affected by this bug.

3

Same thing for me as well -

Create a Smart Collection in a TV library, and the server admin can see it just fine. But any shared users can not the content of the Smart Collection

1 Like
4

I’m also having this issue. I guess this explains why the Smart TV Collection I added to my Home Screen doesn’t work for anybody but me and fails to load for everybody else.

5

Maybe someone from plex will notice this thread eventually

6

Keep it on the first page of the forum for: just the right amount of time - and the chances are pretty good.

1 Like
7

You have good point, I should probably try keeping it on the first page

8

I have created two Smart Collections:
“Otto Preminger” in Movies
and
“Keeley Hawes” in TV Shows.

I have asked Friends to have a look - I don’t have time or the inclination to create a test account, but we’ll see what happens abroad. Some will be on Rokus and some will be on ‘something else’…lol

9

I’ve tested with multiple difference servers with several different clients and they’re just always empty.

10

Same here, however i have mixed results. Some do and some don’t work for my test user.
They can see them all, but seemingly only half display tv shows. The ones that contain no tv shows can be played by clicking play on the collection poster or editing the filters gives the entire list.

They only as far as i can tell differ by different genres as a filter (action doesn’t work, fantasy does for example). I also note that the smart collections that do work the tv shows within them can only be viewed in 1 horizontal row. As opposed to a manual collection that can be seen in a normal grid layout.

And i can only get manual collections to appear on the test users TV Library Recommendation tabs rows (so not even the smart collections that are browsable appear).

It all functions and appears fine as my ADMIN account.
PMS Version 1.22.3.4392
PlexWeb Version 4.56.4

11

See the exact same thing -

I’ve not bee able to get any shared user, no matter the client, to be able to see the content of any TV Library Smart Collection

12

Ok, just finished checking JuiceWSA Smart Collections.

Otto Preminger Collection is just fine. In the Web App and on The WebOS app and Plex for Mac. With Continue watching functioning

Keeley Hawes, all I get is Mrs Wilson if I click on The Smart collection poster using the Web app in Edge Browser followed by a playlist of Episodes from each show NO posters. LG WebOS app, NOTHING, Plex for Mac a Playlist of episodes NO Posters. Does appear in Continue Watching, Kippy Ki on that one.

Screen Shot 2021-04-27 at 12.56.43 pm
Screen Shot 2021-04-27 at 12.56.43 pm869×576 75 KB

Screen Shot 2021-04-27 at 1.04.29 pm
Screen Shot 2021-04-27 at 1.04.29 pm723×691 138 KB

So the Keeley Hawes Smart Collection is all fracked up, way down at the bottom of Earth :upside_down_face: :worried:

iPadOS nothing works with Keeley Hawes but Otto Preminger works fine. So a mixed Bag…

13

Well, at least you got to see that fine Collection Poster… thx for checking it out.

1 Like
14

You are see what everyone else is -
Movie Smart Collections work fine for shared users

The issue is, as everyone has motioned, with TV Smart Collections and shared users

15

I have sent an email to Ruth Wilson, Alias Alice Morgan. She will sort this out quick Smart… Lol :wink:

OIP.1t-0M2TQqwm3ZU5eeUuCdAHaE8

1 Like
16

Ok, good correlation. Yet TV shows Smart Collections only show like a playlist for shared Users.

17

It’s just a shame

we go to the trouble of creating Collections of American Classic TV, and the shared user can not see it

shot_210426_202348
shot_210426_202348815×613 73.4 KB

1 Like
18

RUH-ROH Raggy!!!

19

Yes, it is.

… with 149 Collections holding every one of 6500+ Movies/645 Shows-12,500+ Episodes, I imagine I could make good use of Smart Collections - but not if I’m the only one that can see what’s in them:

image
image943×530 193 KB

1 Like
20

Unfortunate that it wasn’t fixed in the latest beta release.

My mother-in-law is still unable to find her favorite HGTV shows because my collection appears empty to her.