Optimized Versions Error Database Error Retrieving Sync Data

Plex Media Server
,
1

Currently on Latest Plex Version: 1.32.5.7210

I am currently unable to do optimized version(s). I have reproduced the step(s) below several times.

  1. Open up any movie and edit it → Create a brand new collection
  2. Go to the collections list and observe my collection with 1 movie in it
  3. select the collection → … → Optimize
  4. Fill out optimize with various settings. Save
    5 Observe Error in Optimizer “Database Error Retrieving Sync Data”

Errors are logged in the console as follows that correlate to this action:[Req#572a1] SQLITE3:0x80000001, 1, no such column: tags.id in “select count(*) from (select distinct(metadata_items.id) from metadata_items left join metadata_items as parents on parents.id=metadata_items.parent_id left join metadata_items as grandparents on grandparents.id=parents.parent_id 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 (tags.id=216798 and metadata_items.metadata_type=1) order by metadata_items.originally_available_at asc, metadata_items.year IS NULL,metadata_items.year asc, metadata_items.title_sort collate icu_root asc, metadata_items.originally_available_at asc, metadata_items.id asc)”
[Req#5747a] Versions: failed to get items: sqlite3_statement_backend::prepare: no such column: tags.id for SQL: select metadata_items.id as ‘metadata_items_id’, metadata_items.library_section_id as ‘metadata_items_library_section_id’, metadata_items.parent_id as ‘metadata_items_parent_id’, metadata_items.metadata_type as ‘metadata_items_metadata_type’, metadata_items.guid as ‘metadata_items_guid’, metadata_items.hash as ‘metadata_items_hash’, metadata_items.media_item_count as ‘metadata_items_media_item_count’, metadata_items.title as ‘metadata_items_title’, metadata_items.title_sort as ‘metadata_items_title_sort’, metadata_items.original_title as ‘metadata_items_original_title’, metadata_items.studio as ‘metadata_items_studio’, metadata_items.rating as ‘metadata_items_rating’, metadata_items.audience_rating as ‘metadata_items_audience_rating’, metadata_items.rating_count as ‘metadata_items_rating_count’, metadata_items.tagline as ‘metadata_items_tagline’, metadata_items.edition_title as ‘metadata_items_edition_title’, metadata_items.summary as ‘metadata_items_summary’, metadata_items.content_rating as ‘metadata_items_content_rating’, metadata_items.content_rating_age as ‘metadata_items_content_rating_age’, metadata_items.‘index’ as ‘metadata_items_index’, metadata_items.absolute_index as ‘metadata_items_absolute_index’, metadata_items.duration as ‘metadata_items_duration’, metadata_items.user_thumb_url as ‘metadata_items_user_thumb_url’, metadata_items.user_art_url as ‘metadata_items_user_art_url’, metadata_items.user_banner_url as ‘metadata_items_user_banner_url’, metadata_items.user_music_url as ‘metadata_items_user_music_url’, metadata_items.user_fields as ‘metadata_items_user_fields’, metadata_items.originally_available_at as ‘metadata_items_originally_available_at’, metadata_items.available_at as ‘metadata_items_available_at’, metadata_items.expires_at as ‘metadata_items_expires_at’, metadata_items.refreshed_at as ‘metadata_items_refreshed_at’, metadata_items.year as ‘metadata_items_year’, metadata_items.added_at as ‘metadata_items_added_at’, metadata_items.created_at as ‘metadata_items_created_at’, metadata_items.updated_at as ‘metadata_items_updated_at’, metadata_items.changed_at as ‘metadata_items_changed_at’, metadata_items.resources_changed_at as ‘metadata_items_resources_changed_at’, metadata_items.tags_genre as ‘metadata_items_tags_genre’, metadata_items.tags_collection as ‘metadata_items_tags_collection’, metadata_items.tags_director as ‘metadata_items_tags_director’, metadata_items.tags_writer as ‘metadata_items_tags_writer’, metadata_items.tags_star as ‘metadata_items_tags_star’, metadata_items.deleted_at as ‘metadata_items_deleted_at’, metadata_items.tags_country as ‘metadata_items_tags_country’, metadata_items.extra_data as ‘metadata_items_extra_data’,grandparents.id as metadata_items_grandparents_id, grandparents.title as metadata_items_grandparents_title, grandparents.user_thumb_url as metadata_items_grandparents_user_thumb_url, grandparents.user_art_url as metadata_items_grandparents_user_art_url, grandparents.user_music_url as metadata_items_grandparents_user_music_url, grandparents.content_rating as metadata_items_grandparents_content_rating,grandparents.updated_at as metadata_items_grandparents_updated_at, grandparents.guid as metadata_items_grandparents_guid, grandparents.extra_data as metadata_items_grandparents_extra_data, grandparents.title_sort as metadata_items_grandparents_title_sort, parents.user_thumb_url as metadata_items_parents_user_thumb_url,parents.user_art_url as metadata_items_parents_user_art_url,parents.user_music_url as metadata_items_parents_user_music_url,parents.added_at as metadata_items_parents_added_at,parents.updated_at as metadata_items_parents_updated_at,parents.index as metadata_items_parents_index, parents.guid as metadata_items_parents_guid, parents.title as metadata_items_parents_title, parents.studio as metadata_items_parents_studio, parents.title_sort as metadata_items_parents_title_sort, parents.year as metadata_items_parents_year from metadata_items left join metadata_items as parents on parents.id=metadata_items.parent_id left join metadata_items as grandparents on grandparents.id=parents.parent_id where metadata_items.id in (select distinct(metadata_items.id) from metadata_items left join metadata_items as parents on parents.id=metadata_items.parent_id left join metadata_items as grandparents on grandparents.id=parents.parent_id 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 (tags.id=216798 and metadata_items.metadata_type=1) order by metadata_items.originally_available_at asc, metadata_items.year IS NULL,metadata_items.year asc, metadata_items.title_sort collate icu_root asc, metadata_items.originally_available_at asc, metadata_items.id asc) limit 0,20

I have tried the above multiple times with multiple (new) collection settings, transcoder settings, etc. It just wont work. I CAN however select a specific movie and have that transcode its only when i try to do a collection that this error comes up. Previously i have done this many time(s) previously without issue, so I can say for certain it has worked at some point within the past 6 months for me.

I have tried:

  • Restarting Plex
  • Restarting my Machine
  • Using the “optimize db” and “cleanup bundles” troubleshooting buttons
  • The third party tool: https://github.com/ChuckPa/PlexDBRepair
    None of the above have altered this behavior thus far, it throws the same error every time.

Any thoughts/suggestions on what i may be able to try next?

2

There is no “optimize” option for collections. That is not a supported feature, which is why you are getting an error. Where are you seeing this?

image
image722×693 47.1 KB

3

HMM… Maybe this is a GUI bug then? You can definitely “select” the collection from the list and the selection UI definitely has optimize (see screenshot). I did try opening the collection and do see optimize is not present there - so what you are saying makes sense.

plex screenshot
plex screenshot1286×642 88.7 KB

I swear many times I have set it up to auto create optimized versions based on collection membership. Maybe that’s a “smart collection” whose membership is based on a collection? or a Playlist? I used to add movies to a collection and see them optimizing right away… Now im just second guessing myself as to how I set it up…