Home Screen No Longer Showing Local Libraries After Latest Update

Server Version#: 1.21.1.3830
Player Version#: 4.49.2

Installed the latest update tonight and after the service restarted, the libraries on the Home screen showed up as disconnected so I reset the home screen customizations as I have in the past.

The wizard shows my local libraries just fine (in addition to the online “On Plex” stuff), I left everything checked and continued but the Home screen now only shows the online libraries.

When I try just selecting my local libraries, I get a “Something went wrong” message.

I’ve tried dumping and restoring the database and even tried restoring an older library but there’s no change.

I’ll add that the local libraries do show on the sidebar and I can access my content there just fine.

The only entries in the server log I see that might be relevant are:

Dec 18, 2020 09:27:34.419 [0x7f8ca2bd5700] 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
Dec 18, 2020 09:27:34.420 [0x7f8ca2bd5700] 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

1 Like

I have the exact same issue too.

My library categories are all there, but they’re all scrambled now. I can’t put them back in order by changing their names, and it seems that movie categories are locked above tv categories and there’s no way to intermingle them from what I can see. I really don’t like this, am I missing something?

Sounds like you just need to reorder your libraries. Not sure where you’re trying to do this, but there are articles on this on the support site.

https://support.plex.tv/articles/customizing-the-mobile-apps-2/
https://support.plex.tv/articles/customizing-the-apps/
https://support.plex.tv/articles/customizing-plex-web/

Hope this helps!

Mine has also been broken across all players. I can go to individual libraries and play stuff, but the Home Screen, Recommended, Deck etc are all broken with the error above, so same problem as described by @dimensionzero

This looks like an upgrade bug in the server to me.

Used Time Machine to downgrade to 1.21.0.3616 and my Home screen is functional again across all players.

I tried rolling back to older versions on the repo, but could only go back to 1.21.1.3766. (which didn’t fix the problem)

But the version @voiceinsideyou mentions works perfectly. (Thanks, BTW!)
I found a list of old download links here for anyone else that needs to downgrade https://github.com/axlecrusher/plex_download_urls

I guess we’ll wait and see what the next version holds

1 Like

On your device players – Settings - Reset Customizations (the home screen).
Repin that which you want there.

Sometimes, app updates will cause the home screen customizations to get lost (incompatibilities I guess)

Hi @ChuckPa, I tried this numerous times already. All that ends up happening is I get all the “On Plex” stuff. None of my local libraries.

I know I’ve had to do this before for other upgrades, but this time it did not help at all.

Yeah, this also doesn’t seem specific to the home screen customisations because the ‘Recommended’ tabs for an individual local library were also not loading.

Are you both 100% certain the server is singing into the account after the upgrade?

It sounds like it’s not.

it wouldn’t be the first time a server needed reclaiming.

I say this because if you open the bundled Plex/web app (http://ip.addr.of.host:32400/web) and do not get your server – it’s not running or not on the account you think it is.

If you use the hosted (app.plex.tv) - then your server isn’t attached / awake on the account.

I’m only accessing my server via app.plex.tv so I should be…

Yes I even tried private/incognito wndows in browser, after signing in (to remove local storage or cookie weirdness) as well as signing out and in the Plex Android app and Plex Media Player and Plex PS4 app.

All have a similar issue.

Help me out here?

  1. I updated to current beta release
  2. Opened via app.plex.tv
  3. Examine existing pinned library sections

What am I missing?

This section is ready to be pinned – as it should be.

Seems for whatever reason yours doesn’t have the issue? I’m not sure how to reproduce it. This seems similar Server update causing empty libraries on androind

Forgot to turn auto-update off so my server updated to the new version, broken again, but can take some screenshots.

image

On every non-web platform

  • Home doesn’t show local libraries. Some players show “Something went wrong” rather than my Deck/Continue Watching etc
  • Going to individual local collection works on “Library” and “Collections” tab
  • Recommendations shows “Add Content to this library” as if it is empty.

I also tested 1.21.0.3711 - this version seems fine also.

Given the changelog in 1.21.1.3759 mentions hubs as a new feature, and the error message above mentions “no such table: hub_templates” - is it plausible that there is some issue performing this server upgrade on the sqlite DB to support the new feature in 1.21.1?

OK, after scratching my head a bit further I got it.

Noticed some ERROR logs during startup complaining about DB corruption even on the old version. I am guessing that if there are such logs at startup then Plex doesn’t apply any database migrations required to support new features.

So I suppose the new DB table needed for the home screen not being created broke it and other recommended screens.

Anyway, followed https://support.plex.tv/articles/201100678-repair-a-corrupt-database/, repaired my DB and then retried the upgrade; now my server seems fine.

Would really be great if Plex had a way of warning you of a corrupt DB by a notification/something at startup so you could fix it as soon as possible (or rollback to a backup) :-/ In this case it must have broadly kept working for some indeterminate period of time until this server update needed a new table, meaning now I’m not sure even when the corruption was introduced or what data I have lost. :-/

Suggest you look at your logs for the same thing @dimensionzero and see if you need to repair?

Unfortunately for me, I did try the repair initially and there was no change. Which is not to say that this isn’t a database problem… I’ve had an issue with my database for a very long time where my search does not work at all. It never returns any results for my local files. Not sure what the fix is for that, and maybe something there is affecting things.

Either way, the older version of Plex is currently solving this issue, hopefully it doesn’t come back to bite me in the next update!

Do you have ERROR logs at startup at the top of the media server log file complaining about corruption, even after trying to repair?

If you do, I imagine you might be stuck for all future upgrades if my theory is correct that ones DB cannot be migrated when corruption is detected.

I tried to repair the database with the guide but the error still exists:

SQLITE3:0x7c27a0c3, 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

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

I use Server Version: 1.21.1.3830 (windows server)

The startpage shows only plex related content and all recommendations of each library shows an error page.

This happens on clients and web interfaces.

UPDATE:
I used this hub_template create table statement from a fresh installation and applied it to the existing one. So far Plex is running as it should.

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))

dont know if there any sideeffects

1 Like

I have the same errors, can you tell me exactly what you did please to use this hub_template create table?

Have you tried to use the official Plex guide to repair your database first?

Not sure how technical you are, but Xeon2003’s suggestion is probably not a good idea if you haven’t at least tried the repair first. The failure to create the table automatically during upgrades probably means the database changes made for new versions are not being applied at all so if the corruption isn’t resolved, I imagine future upgrades are likely to have a high chance of being broken too.