Apple latest Catalina update makes Plex feel bad.... "Something went wrong..."

Plex Media Server Desktops & Laptops
1

Server Version#: 1.28.1.6041
Player Version#: built-in web viewer, and iPad client

Apple pushed a new Catalina version 10.15.7.
Server Version#: 1.28.1.6041

Result: libraries were working, now aren’t working

Logs show a few errors consistently relating to sqlite queries:

Aug 11, 2022 21:16:16.356 [0x7000054fb000] ERROR - [Req#27a] Unknown metadata type: folder
Aug 11, 2022 21:16:16.367 [0x700004ccb000] ERROR - [Req#282] Unknown metadata type: folder
Aug 11, 2022 21:16:16.422 [0x7000054fb000] ERROR - [Req#27a] SQLITE3:(nil), 1, no such column: metadata_items.edition_title in "select distinct media_items.id as ‘media_items_id’, media_items.library_section_id as ‘media_items_library_section_id’, media_items.section_location_id as 'medi
Aug 11, 2022 21:16:16.423 [0x7000054fb000] ERROR - Got exception from request handler: sqlite3_statement_backend::prepare: no such column: metadata_items.edition_title for SQL: select distinct media_items.id as ‘media_items_id’, media_items.library_section_id as ‘media_items_library_section_id’, media_items.section_location_id as ‘media_items_section_location_id’, media_items.metadata_item_id as ‘media_items_metadata_item_id’, media_items.type_id as ‘media_items_type_id’, media_items.width as 'media_items_width

…
If you want the full query please let me know.

Dead in the water for now

cherrio
michael

2

makes me think you have database corruption

https://support.plex.tv/articles/repair-a-corrupted-database/

3

@dbirch - I first tried just removing the Server app itself, which per the article should have contained the SQLlite db, but that didn’t fix anything. I then found on Mac the ~/Library/Application Support/Plex Media Server folder and removed it, starting from scratch. That seems to have been the trick.

Maybe worth mentioning this in the Plex support article if anyone here can edit those pages.

4

Plex does that on purpose, to allow removing the app for upgrades ect, while leaving your data intact.

5

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