Recently Added Unavailable and error loading the dashboard

Plex Media Server Desktops & Laptops
1

Server Version#: plexmediaserver_1.15.3.835-5d4a5c895
Player Version#: latest Roku

A few days ago I noticed that Plex was no longer showing any new content in recently added, just what was there already as of march 25th.

I checked the DB for errors and it had errors so I followed the process to repair the database. Optimized a few times as well

I now get the “error loading the dashboard” error via the web page. Checked the DB again and it says ok, followed the repair instructions and still the same issues. On my Roku and Android Plex clients the recently added shows unavailable. On the Roku it alternates between showing the Movies recently added and TV as unavailable. On the Android app it has both as unavailable. Libraries show up fine.

I can play content. on both the Roku and Android.

I upgraded to the recent and tried downgrading the various version. Installed the most recent Plex server version
plexmediaserver_1.15.3.835-5d4a5c895

Attached are the recent logsPlex Media Server Logs_2019-03-28_20-49-30.zip (3.0 MB)

2

So I found a corrupt date/time entry in the database. How do I remove it?

id library_section_id parent_id metadata_type guid media_item_count title title_sort original_title studio rating rating_count tagline summary trivia quotes content_rating content_rating_age index absolute_index duration user_thumb_url user_art_url user_banner_url user_music_url user_fields tags_genre tags_collection tags_director tags_writer tags_star originally_available_at available_at expires_at refreshed_at year added_at created_at updated_at deleted_at tags_country extra_data hash audience_rating changed_at resources_changed_at
82306 4 82303 4 com.plexapp.agents.thetvdb://87501/2/3?lang=en 1 Drummer! Drummer! 9.19999980926514 After noticing how badly she shoq 8 H 204 ; -1006238968 50383555
3

Since no one had an answer I figured it out.

I was able t o use sqlitebrowser in Ubuntu desktop to edit the date fields and set them to NULL. after doing so I was able to restart plex and see my dashboard again. I also used SQLiteStudio-3.2.1 on windows to edit the backup plex db. Had to ftp the db to my windows system edit then replace the odl db with the fixed one as well as copy over the .db-whl and .db-wal file that SQLiteStudio-3.2.1 created after my edits. restarted the backup plex I have in docker and the dashboard returned to normal

4

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