Search Not Finding Any Local Media

Plex Media Server NAS & Devices
1

Server Version#: 1.31.3.6868

Howdy all,
As the title says, searching my Plex server does not turn up any local media.
Imgur
This issue is present across all of my libraries. The server is selected in search, and Library visibility is set to ‘Include in home screen and global search’.
Imgur
Imgur
Things I have tried:

  • Optimizing the database
  • Refreshing metadata
  • Scanning library files
  • Analyzing library files
  • Setting library visibility to ‘exclude’ and back.
  • Deselecting and reselecting the server in the search options
  • Cleaning bundles
  • Emptying trash

There appear to be no problems in the log either
Plex Media Server.log (103.5 KB)

Any ideas? (full screencaps here: Plex search broken - Album on Imgur)

2

From the logs:

Apr 07, 2023 12:13:14.986 [0x1497d05e0b38] DEBUG - Request: [192.168.86.29:49917 (Subnet)] GET /hubs/search?query=Aliens&limit=30&includeCollections=1&includeExternalMedia=1 (3 live) #129 TLS GZIP Signed-in Token (27ace27) (Chrome)
Apr 07, 2023 12:13:14.990 [0x1497d05e0b38] ERROR - [Req#129] SQLITE3:0x80000001, 1, no such table: fts4_metadata_titles_icu in "select distinct metadata_items.id from metadata_items  join fts4_metadata_titles_icu on metadata_items.id=fts4_metadata_titles_icu.rowid  join metadata_item_accounts on metadata_item_accounts.metadata_item_id=metadata_items.id  where fts4_metadata_titles_icu.title match 'Aliens*'  and metadata_items.metadata_type=15 and metadata_item_accounts.account_id=1  order by  metadata_items.`index` desc, metadata_items.title_sort collate icu_root asc limit 30"
Apr 07, 2023 12:13:17.884 [0x1497d05e0b38] ERROR - Got exception from request handler: sqlite3_statement_backend::prepare: no such table: fts4_metadata_titles_icu for SQL: select distinct metadata_items.id from metadata_items  join fts4_metadata_titles_icu on metadata_items.id=fts4_metadata_titles_icu.rowid  join metadata_item_accounts on metadata_item_accounts.metadata_item_id=metadata_items.id  where fts4_metadata_titles_icu.title match 'Aliens*'  and metadata_items.metadata_type=15 and metadata_item_accounts.account_id=1  order by  metadata_items.`index` desc, metadata_items.title_sort collate icu_root asc limit 30
Apr 07, 2023 12:13:17.885 [0x1497d6ecdb38] DEBUG - Completed: [192.168.86.29:49917] 500 GET /hubs/search?query=Aliens&limit=30&includeCollections=1&includeExternalMedia=1 (3 live) #130 TLS GZIP 3ms 537 bytes (pipelined: 2)

Looks like database corruption. I’d either try restoring a backup or repairing the current database.

3

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