# PMS Bug - Custom Collection - Custom Sort

**URL:** <https://forums.plex.tv/t/pms-bug-custom-collection-custom-sort/685014>\
**Category:** Plex Media Server\
**Tags:** server-docker\
**Created:** [January 31, 2021, 3:10am UTC](https://forums.plex.tv/t/pms-bug-custom-collection-custom-sort/685014 "2021-01-31T03:10:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![angrycuban](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/angrycuban/32/140618_2.png) [@angrycuban](https://forums.plex.tv/u/angrycuban)\
**Post date:** [January 31, 2021, 3:10am UTC](https://forums.plex.tv/t/pms-bug-custom-collection-custom-sort/685014/1 "2021-01-31T03:10:03Z")

</div>

Server Version#: 1.21.2.3943  
Player Version#: N/A

I was trying to create the MCU collection on my server tonight, it was about 32 movies. The collection gets created fine but when I go edit it to set it to `Custom Sort` it immediately breaks.

This is what I get:  
 ![image](https://global.discourse-cdn.com/plex/original/3X/2/f/2fb66388fe3105e67d6b1f82a45eef12eb8c8d03.jpeg)

This is the error I get on the browser console:

 ![https://sharex.angrycuban.xyz/XExe1/dEyoPAhE29.png/raw](https://global.discourse-cdn.com/plex/original/3X/b/e/be5ad0f432a887f4644eae26d3d65fc9589e8687.png)

This is the relevant entry on the PMS Logs:

```auto
SQLITE3:(nil), 1, no such column: taggings.index in 
"select distinct metadata_items.id from metadata_items 
left join media_items on media_items.metadata_item_id=metadata_items.id 
left join media_parts on media_parts.media_ite

```

```auto
Soci Exception handled: sqlite3_statement_backend::prepare: 
no such column: taggings.index for SQL: select distinct metadata_items.id 
from metadata_items left join media_items on media_items.metadata_item_id=metadata_items.id left
join media_parts on media_parts.media_item_id=media_items.id where metadata_items.library_section_id in (1) and (metadata_items.metadata_type=1
and metadata_items.id in (select taggings.metadata_item_id
from taggings join tags on tags.id=taggings.tag_id 
where tags.id='92809' and tags.tag_type=2)) order 
by taggings.`index` IS NULL,taggings.`index` asc, 
metadata_items.title_sort collate natural sort asc, 
metadata_items.title_sort collate naturalsort asc, metadata_items.originally_available_at asc, 
metadata_items.id asc

```

---

<div class="post-metadata">

**Author:** ![angrycuban](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/angrycuban/32/140618_2.png) [@angrycuban](https://forums.plex.tv/u/angrycuban)\
**Post date:** [February 2, 2021, 9:36pm UTC](https://forums.plex.tv/t/pms-bug-custom-collection-custom-sort/685014/2 "2021-02-02T21:36:40Z")

</div>

Bump!

---

<div class="post-metadata">

**Author:** ![polaliralo](https://avatars.discourse-cdn.com/v4/letter/p/c5a1d2/32.png) [@polaliralo](https://forums.plex.tv/u/polaliralo)\
**Post date:** [February 13, 2021, 3:30pm UTC](https://forums.plex.tv/t/pms-bug-custom-collection-custom-sort/685014/3 "2021-02-13T15:30:44Z")

</div>

Server Version#: 1.21.3.4021-5a0a3e4b2  
Player Version#: 1.27.2.1599-7689068b

I get the same Error (PMS Log):

`Feb 12, 2021 23:22:15.051 [0x7fbe23fff700] ERROR - SQLITE3:(nil), 1, no such column: taggings.index in "select distinct metadata_items.id from metadata_items left join media_items on media_items.metadata_item_id=metadata_items.id left join media_parts on media_parts.media_ite Feb 12, 2021 23:22:15.051 [0x7fbe23fff700] ERROR - Soci Exception handled: sqlite3_statement_backend::prepare: no such column: taggings.index for SQL: select distinct metadata_items.id from metadata_items left join media_items on media_items.metadata_item_id=metadata_items.id left join media_parts on media_parts.media_item_id=media_items.id where metadata_items.library_section_id in (5) and (metadata_items.metadata_type=1 and metadata_items.id in (select taggings.metadata_item_id from taggings join tags on tags.id=taggings.tag_id where tags.id='59852' and tags.tag_type=2)) order by taggings.index IS NULL,taggings.index asc, metadata_items.title_sort collate naturalsort asc, metadata_items.title_sort collate naturalsort asc, metadata_items.originally_available_at asc, metadata_items.id asc `

Work-a-round: switch back to  
Sammlung sortieren: Veröffentlichungsdatum

Longer discussion: [Feature Suggestions Custom Collection Sorting](https://forums.plex.tv/t/custom-collection-sorting-machete-order/236226)

---

<div class="post-metadata">

**Author:** ![angrycuban](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/angrycuban/32/140618_2.png) [@angrycuban](https://forums.plex.tv/u/angrycuban)\
**Post date:** [February 13, 2021, 6:50pm UTC](https://forums.plex.tv/t/pms-bug-custom-collection-custom-sort/685014/4 "2021-02-13T18:50:15Z")

</div>

Yeah would be nice if the devs would acknowledge the bug or at least remove the broken functionality

---

<div class="post-metadata">

**Author:** ![angrycuban](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/angrycuban/32/140618_2.png) [@angrycuban](https://forums.plex.tv/u/angrycuban)\
**Post date:** [March 30, 2021, 3:37pm UTC](https://forums.plex.tv/t/pms-bug-custom-collection-custom-sort/685014/5 "2021-03-30T15:37:32Z")

</div>

They removed this sort ability in some version since I made this post.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [June 28, 2021, 3:38pm UTC](https://forums.plex.tv/t/pms-bug-custom-collection-custom-sort/685014/6 "2021-06-28T15:38:19Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
