TV Shows Recommended - "Something Went Wrong"

Plex Media Server Metadata & Adding Files
1

I’ve recently performed the ‘upgrade metadata’ in my TV Shows library from old to new TV Shows but now my ‘recommended’ TV shows do not work and instead I get a
‘something went wrong’ error. The library works and everything is searchable.

Running in docker :latest in linux.

2

This could be a sign of database corruption; your Plex Media Server logs would show for certain (search for “corrupt” or “malformed”). This support article describes how to check for and (potentially) correct corruption:

Failing that, you could potentially restore a database from when you made the agent change:

1 Like
3

Looks like a database error from the logs:

SQLITE3:0x80000001, 1, no such column: grandchildren.year 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 grandparents on gr
Soci Exception handled: sqlite3_statement_backend::prepare: no such column: grandchildren.year 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 (2) and (grandchildren.year=2021 and (metadata_items.metadata_type=2 or metadata_items.metadata_type=10)) order by metadata_items.id asc, 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

Plex Media Server Logs_2021-07-11_00-30-41.zip (6.6 MB)

It works fine on certain accounts; on my main account it is fine, but on home user accounts it is broken and produces that error.

4

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