Home Screen No Longer Showing Local Libraries After Latest Update

Plex Media Server
,
22

yep i’ve done that, twice.

Feb 05, 2021 17:52:06.636 [0x7f365ba2a700] Debug — Auth: authenticated user 1 as frustin
Feb 05, 2021 17:52:06.636 [0x7f3616e6b700] Debug — Request: [192.168.178.26:55120 (Subnet)] GET /:/timeline?ratingKey=12646&key=%2Flibrary%2Fmetadata%2F12646&playbackTime=0&playQueueItemID=12587&state=paused&hasMDE=1&time=581000&duration=7353000 (13 live) TLS GZIP Signed-in Token (frustin)
Feb 05, 2021 17:52:06.637 [0x7f3616e6b700] Debug — Client [et0odke9yezqx6u9h9w2rn5d] reporting timeline state paused, progress of 581000/7353000ms for guid=, playbackTime=0ms ratingKey=12646 url=, key=/library/metadata/12646, containerKey=, metadataId=12646, source=
Feb 05, 2021 17:52:06.638 [0x7f3616e6b700] Debug — Play progress on 12646 'Magnum Force' - got played 581000 ms by account 1!
Feb 05, 2021 17:52:06.638 [0x7f3616e6b700] Debug — [Now] User is frustin (ID: 1)
Feb 05, 2021 17:52:06.638 [0x7f3616e6b700] Debug — [Now] Device is Chrome (Chrome).
Feb 05, 2021 17:52:06.638 [0x7f3616e6b700] Debug — [Now] Profile is Web
Feb 05, 2021 17:52:06.638 [0x7f3616e6b700] Debug — [Now] Updated play state for /library/metadata/12646.
Feb 05, 2021 17:52:06.638 [0x7f3616e6b700] Debug — Statistics: (2d3wgg16zidkil4bf3hkuemv) Reporting active playback in state 1 of type 1 (scrobble: 0) for account 1
Feb 05, 2021 17:52:06.640 [0x7f365ba2a700] Debug — Completed: [192.168.178.26:55120] 200 GET /:/timeline?ratingKey=12646&key=%2Flibrary%2Fmetadata%2F12646&playbackTime=0&playQueueItemID=12587&state=paused&hasMDE=1&time=581000&duration=7353000 (13 live) TLS GZIP 3ms 862 bytes (pipelined: 8)
Feb 05, 2021 17:52:07.109 [0x7f365bd18700] Debug — Auth: authenticated user 1 as frustin
Feb 05, 2021 17:52:07.109 [0x7f36156fb700] Debug — Request: [192.168.178.26:55120 (Subnet)] GET /hubs/sections/1?excludeFields=summary&count=17&includeEmpty=1&includeFeaturedTags=1&includeMeta=1&includeTypeFirst=1&includeStations=1&includeExternalMedia=1&includeExternalMetadata=1&includeRecentChannels=1&excludePlaylists=1 (13 live) TLS GZIP Signed-in Token (frustin)
Feb 05, 2021 17:52:07.110 [0x7f36156fb700] Error — SQLITE3:(nil), 1, no such table: hub_templates in "select hub_templates.id as 'hub_templates_id' , hub_templates.section as 'hub_templates_section', hub_templates.identifier as 'hub_templates_identifier', hub_templates.title as
Feb 05, 2021 17:52:07.110 [0x7f36156fb700] Error — Soci Exception handled: sqlite3_statement_backend::prepare: no such table: hub_templates for SQL: select hub_templates.id as 'hub_templates_id' , hub_templates.section as 'hub_templates_section', hub_templates.identifier as 'hub_templates_identifier', hub_templates.title as 'hub_templates_title', hub_templates.home_visibility as 'hub_templates_home_visibility', hub_templates.recommended_visibility as 'hub_templates_recommended_visibility', hub_templates.`order` as 'hub_templates_order', hub_templates.extra_data as 'hub_templates_extra_data' from hub_templates where hub_templates.section = ? order by `order`
Feb 05, 2021 17:52:07.110 [0x7f365ba2a700] Debug — Completed: [192.168.178.26:55120] 500 GET /hubs/sections/1?excludeFields=summary&count=17&includeEmpty=1&includeFeaturedTags=1&includeMeta=1&includeTypeFirst=1&includeStations=1&includeExternalMedia=1&includeExternalMetadata=1&includeRecentChannels=1&excludePlaylists=1 (13 live) TLS GZIP 0ms 484 bytes (pipelined: 9)
23

Figured it out, from the command line:

 sqlite3 com.plexapp.plugins.library.db "CREATE TABLE 'hub_templates' ('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'section' varchar(255), 'identifier' varchar(255), 'title' varchar(255), 'home_visibility' integer, 'recommended_visibility' integer, 'order' float, 'extra_data' varchar(255))"
1 Like
24

I just upgraded to 1.22.1.4275 (from 1.19-something) and suffer the same error. This is not the first time the database migrations has failed for me.

I got these errors during migration:

Apr 05, 2021 16:13:12.722 [0x7f9a5f7e2780] DEBUG - Vacuuming database.
Apr 05, 2021 16:13:13.497 [0x7f9a5f7e2780] ERROR - SQLITE3:(nil), 1555, abort at 6 in [INSERT INTO vacuum_db.'tags' SELECT*FROM"main".'tags']: UNIQUE constraint failed: tags.id
Apr 05, 2021 16:13:13.503 [0x7f9a5f7e2780] ERROR - SQLITE3:(nil), 19, statement aborts at 1: [VACUUM] UNIQUE constraint failed: tags.id
Apr 05, 2021 16:13:13.510 [0x7f9a5f7e2780] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadOne: UNIQUE constraint failed: tags.id
Apr 05, 2021 16:13:13.690 [0x7f9a5f7e2780] DEBUG - ChangestampAllocator: initialized to 10872519
Apr 05, 2021 16:13:13.690 [0x7f9a5f7e2780] DEBUG - Opening 2 database sessions to library (com.plexapp.plugins.library.blobs), SQLite 3.26.0, threadsafe=1
Apr 05, 2021 16:13:13.744 [0x7f9a5f7e2780] DEBUG - Running migrations. (EPG 0)
Apr 05, 2021 16:13:13.745 [0x7f9a5f7e2780] DEBUG - Running forward migration 20200615032400.
Apr 05, 2021 16:13:13.745 [0x7f9a5f7e2780] DEBUG - Captured session 0.
Apr 05, 2021 16:13:13.745 [0x7f9a5f7e2780] DEBUG - Captured session 1.
Apr 05, 2021 16:13:13.778 [0x7f9a5f7e2780] DEBUG - Analyzing database.
Apr 05, 2021 16:13:13.805 [0x7f9a5f7e2780] DEBUG - Vacuuming database.
Apr 05, 2021 16:13:20.037 [0x7f9a5f7e2780] INFO - SQLITE3:(nil), 17, statement aborts at 57: [select * from metadata_items limit 1] database schema has changed
Apr 05, 2021 16:13:20.039 [0x7f9a5f7e2780] DEBUG - Completed forward migration 20200615032400.
Apr 05, 2021 16:13:20.040 [0x7f9a5f7e2780] DEBUG - Running forward migration 20200701090000.
Apr 05, 2021 16:13:20.040 [0x7f9a5f7e2780] DEBUG - Captured session 0.
Apr 05, 2021 16:13:20.040 [0x7f9a5f7e2780] DEBUG - Captured session 1.
Apr 05, 2021 16:13:20.057 [0x7f9a5f7e2780] DEBUG - Completed forward migration 20200701090000.
Apr 05, 2021 16:13:20.057 [0x7f9a5f7e2780] DEBUG - Running forward migration 20200728130000.
Apr 05, 2021 16:13:20.057 [0x7f9a5f7e2780] DEBUG - Captured session 0.
Apr 05, 2021 16:13:20.057 [0x7f9a5f7e2780] DEBUG - Captured session 1.
Apr 05, 2021 16:13:20.059 [0x7f9a5f7e2780] DEBUG - Completed forward migration 20200728130000.
Apr 05, 2021 16:13:20.059 [0x7f9a5f7e2780] DEBUG - Running forward migration 20200731130000.
Apr 05, 2021 16:13:20.059 [0x7f9a5f7e2780] DEBUG - Captured session 0.
Apr 05, 2021 16:13:20.059 [0x7f9a5f7e2780] DEBUG - Captured session 1.
Apr 05, 2021 16:13:20.059 [0x7f9a5f7e2780] DEBUG - Completed forward migration 20200731130000.
Apr 05, 2021 16:13:20.059 [0x7f9a5f7e2780] DEBUG - Running forward migration 20200812130000.
Apr 05, 2021 16:13:20.060 [0x7f9a5f7e2780] DEBUG - Captured session 0.
Apr 05, 2021 16:13:20.060 [0x7f9a5f7e2780] DEBUG - Captured session 1.
Apr 05, 2021 16:13:20.060 [0x7f9a5f7e2780] DEBUG - Completed forward migration 20200812130000.
Apr 05, 2021 16:13:20.060 [0x7f9a5f7e2780] DEBUG - Running forward migration 20200921130000.
Apr 05, 2021 16:13:20.060 [0x7f9a5f7e2780] DEBUG - Captured session 0.
Apr 05, 2021 16:13:20.060 [0x7f9a5f7e2780] DEBUG - Captured session 1.
Apr 05, 2021 16:13:20.061 [0x7f9a5f7e2780] INFO - SQLITE3:(nil), 17, statement aborts at 57: [select * from metadata_items limit 1] database schema has changed
Apr 05, 2021 16:13:20.067 [0x7f9a5f7e2780] DEBUG - Completed forward migration 20200921130000.
Apr 05, 2021 16:13:20.067 [0x7f9a5f7e2780] DEBUG - Running forward migration 20201103130000.
Apr 05, 2021 16:13:20.068 [0x7f9a5f7e2780] DEBUG - Captured session 0.
Apr 05, 2021 16:13:20.068 [0x7f9a5f7e2780] DEBUG - Captured session 1.
Apr 05, 2021 16:13:20.068 [0x7f9a5f7e2780] DEBUG - Completed forward migration 20201103130000.
Apr 05, 2021 16:13:20.068 [0x7f9a5f7e2780] DEBUG - Running forward migration 20201119130000.
Apr 05, 2021 16:13:20.068 [0x7f9a5f7e2780] DEBUG - Captured session 0.
Apr 05, 2021 16:13:20.068 [0x7f9a5f7e2780] DEBUG - Captured session 1.
Apr 05, 2021 16:13:20.069 [0x7f9a5f7e2780] DEBUG - Completed forward migration 20201119130000.
Apr 05, 2021 16:13:20.069 [0x7f9a5f7e2780] DEBUG - Running forward migration 500000000000.
Apr 05, 2021 16:13:20.069 [0x7f9a5f7e2780] DEBUG - Captured session 0.
Apr 05, 2021 16:13:20.069 [0x7f9a5f7e2780] DEBUG - Captured session 1.
Apr 05, 2021 16:13:20.070 [0x7f9a5f7e2780] INFO - SQLITE3:(nil), 17, statement aborts at 57: [select * from metadata_items limit 1] database schema has changed
Apr 05, 2021 16:13:20.073 [0x7f9a5f7e2780] DEBUG - Completed forward migration 500000000000.
Apr 05, 2021 16:13:20.073 [0x7f9a5f7e2780] DEBUG - Running forward migration 500000000001.
Apr 05, 2021 16:13:20.073 [0x7f9a5f7e2780] DEBUG - Captured session 0.
Apr 05, 2021 16:13:20.073 [0x7f9a5f7e2780] DEBUG - Captured session 1.
Apr 05, 2021 16:13:20.083 [0x7f9a5f7e2780] DEBUG - Analyzing database.
Apr 05, 2021 16:13:20.087 [0x7f9a5f7e2780] DEBUG - Vacuuming database.
Apr 05, 2021 16:13:25.241 [0x7f9a5f7e2780] INFO - SQLITE3:(nil), 17, statement aborts at 57: [select * from metadata_items limit 1] database schema has changed
Apr 05, 2021 16:13:25.244 [0x7f9a5f7e2780] DEBUG - Completed forward migration 500000000001.

Only actual error seem to relate to some vacuuming operations, so I’m kind of wondering where the hub table migration went…

25

Seems like my database has issues, the logs show missing tables, so search doesnt return any results from my server
anybody have any ideas on what I can do to fix it? ive already tried database repair twice, no change

Apr 26, 2021 09:04:31.292 [0x7f811affd700] Debug — Request: [192.168.1.234:58004 (Subnet)] GET /hubs/search?includeCollections=1&includeExternalMedia=1&sectionId=&query=mortal (11 live) TLS GZIP Signed-in Token (revenghost)
Apr 26, 2021 09:04:31.295 [0x7f811affd700] Error — SQLITE3:(nil), 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
Apr 26, 2021 09:04:31.296 [0x7f811affd700] Error — Soci Exception handled: 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 ‘Mortal*’ 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 3
Apr 26, 2021 09:04:31.297 [0x7f8168af3700] Debug — Completed: [192.168.1.234:58004] 500 GET /hubs/search?includeCollections=1&includeExternalMedia=1&sectionId=&query=mortal (11 live) TLS GZIP 4ms 530 bytes (pipelined: 4)

26

Had the same issue. Upgraded from Version 1.8.x.
The create statement fixed it!

27

If you people stopped blaming users and made the thing work correctly we’d all be better off.

28

If anyone’s adventurous enough, I ended up renaming my database then restarting Plex to create a fresh new one.

Then I exported that and started comparing my tables between the new one to my existing one. I had a number of missing tables which I just took from the export to recreate.

I’m still getting Plex telling me there’s data corruption so I suspect I’m still missing something but it’s working fine. This also solved my issue where the search function had stopped working ages ago.

It’d be great if the Plex team could provide some sort of script that would scan the database and do a repair/recreate anything missing!

I’m not quite technical enough to do this on my own just yet…

29

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