Server Version#: 1.40.4.8679-424562606
Player Version#: all - Web / Phone / TV / doesn’t matter
When attempting to search the Log shows these errors
[Req#dc0a9] SQLITE3:0x2, 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 ‘Batman*’ 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 100”
and
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 ‘Bast*’ 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 100
I have attempted to fix the database by following the repair directions at -
https://support.plex.tv/articles/repair-a-corrupted-database/
I also downloaded PlexDBRepair from GitHub - ChuckPa/PlexDBRepair: Database repair utility for Plex Media Server databases and ran all the repairs available there.
All show successful and when checking for errors in the database it says none, but search is still broken and the console still shows the errors.
Yes I’m aware I can create a fresh database and use TRAKT to sync my watched info back but that is not an option because it does not sync or restore my family members accounts, who have watched history dating back to when I setup my first server in 2011.
Is there something I’m missing. I even followed the directions on exporting watched status
and import into a fresh data base listed at https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/ which seems to export the data but on import I just received errors.
I’m looking for either 1 - how to repair the DB so that search will work again with out losing watched status or 2 - how to import watched status for all users into a fresh database.
