PMS Bug - Custom Collection - Custom Sort

[angrycuban]

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:

This is the error I get on the browser console:

This is the relevant entry on the PMS Logs:

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

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

[angrycuban]

Bump!

[polaliralo]

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

[angrycuban]

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

[angrycuban]

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