Cannot search for any Media Files

Plex Media Server
1

Server Version#:1.41.5.9522
Player Version#:
<If providing server logs please do NOT turn on verbose logging, only debug logging should be enabled>

Hello!

My search field is brocken. When i look for any content, i get always an error.

These are the logs:
[Req#491a2] SQLITE3:0x1, 1, no such table: fts4_metadata_titles_icu in “select 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 ‘Gladiat*’ 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”

Got exception from request handler: sqlite3_statement_backend::prepare: no such table: fts4_metadata_titles_icu for SQL: select 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 ‘Gladiat*’ 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

Does anyone know what to do or can help?

Thanks.

2

The database is in bad shape (damaged)

Did you have an abrupt power off or sudden power interruption (even a few seconds) ?

3

Yes, this can be possible.
I had a black out in my house, a few days ago.

Can i fix this?

With database repair, or rebuild with plex sqlite, it says database is ok, but the search still does not have any function.

When it’s possible, I don’t want to set up a new database, because then I lost all my watched status and work I put in.

4

I do not know Shield server’s internal file layout.

That as caveat,

Where you see the databases, do you have database backup files?

If you see backups of the main & blobs DB, you can roll back the DB to one of the backs BEFORE the power failure.

Key steps:

  1. Stop PMS & stay in the shell
  2. rename the current main DB & blobs DB to a “-save” name pair
  3. If you have WAL & SHM files, delete them
  4. COPY the backup main and blobs DBs to be the corresponding
    – com.plexapp.plugins.library.db
    – com.plexapp.plugs.blobs.db
  5. I think permissions don’t matter but please do check ownership & permissions on the DB files so there won’t be any issues when it starts
  6. Start PMS
  7. Check out the DBs.

(this sequence is what my DBRepair tool does. Unfortunately it doesn’t support the Nvidia Shield. (maybe something I can consider adding)

5

Thanks for your help.

My problem is, i have no backup before the power failure. First i thought it was a temporary problem, but after a few time I checked that it was a big problem with the database. So i checked the automtic backups, but they were all brocken allready. I have only a manuel backup a few months ago and there will be to many information lost.

6

Not sure if this would work but I would try copying the DB files to a computer and carrying out a repair?

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

7

After the repair i get “database is ok” but search is sitll broken

8

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