# recently added shows… not showing **URL:** \ **Category:** General Discussions\ **Created:** [February 8, 2017, 2:35am UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117 "2017-02-08T02:35:59Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 8, 2017, 2:35am UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/1 "2017-02-08T02:35:59Z")
hey, guys— so, i’ve got some episodes added to plex (different shows, different libraries). not only are these not showing in the dashboard, but they’re not showing in the season folders, either. been happening with everything i’ve added the last two days. can’t think of anything i’ve done to change my set-up. thanks, oh, ninja’s— kv★ ---
**Author:** ![sa2000](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sa2000/32/6922_2.png) [@sa2000](https://forums.plex.tv/u/sa2000)\ **Post date:** [February 8, 2017, 2:44am UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/2 "2017-02-08T02:44:13Z")
The only thing i would suggest is to add a TV Show and then update the library and get the logs > **[Reporting issues with Plex Media Server | Plex Support](https://support.plex.tv/articles/201643703-reporting-issues-with-plex-media-server/)** > > How to Report an Issue If you believe you have found an issue in Plex Media Server, please report it... > **[Plex Media Server Log Files | Plex Support](https://support.plex.tv/articles/200250417-plex-media-server-log-files/)** > > Log files are an important tool that can be used to help investigate problems you may be having. It’s important... ---
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 8, 2017, 3:52am UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/3 "2017-02-08T03:52:03Z")
add a show, or an episode? ---
**Author:** ![sa2000](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sa2000/32/6922_2.png) [@sa2000](https://forums.plex.tv/u/sa2000)\ **Post date:** [February 8, 2017, 10:34am UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/4 "2017-02-08T10:34:32Z")
> @killthevideostar said: > add a show, > or an episode? If the show is already in place and correctly showing and the issue arises when you add an episode then do that - just test with adding an episode ---
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 8, 2017, 7:44pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/5 "2017-02-08T19:44:17Z")
thanks, @sa2000. attach to thread or private message you? ---
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 8, 2017, 8:54pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/6 "2017-02-08T20:54:03Z")
[i know it’s good not to mix issues, but search seems to be broken all of a sudden, too.] ---
**Author:** ![sa2000](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sa2000/32/6922_2.png) [@sa2000](https://forums.plex.tv/u/sa2000)\ **Post date:** [February 9, 2017, 12:08am UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/7 "2017-02-09T00:08:14Z")
> @killthevideostar said: > thanks, @sa2000. > > attach to thread or private message you? Support is through the forums - so please post here the logs and screenshots ---
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 10, 2017, 3:11am UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/8 "2017-02-10T03:11:28Z")
thanks, @sa2000. i know forums are support based, but i assume logs contain private info. either way, logs, attached: ---
**Author:** ![sa2000](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sa2000/32/6922_2.png) [@sa2000](https://forums.plex.tv/u/sa2000)\ **Post date:** [February 10, 2017, 8:28am UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/9 "2017-02-10T08:28:54Z")
> @killthevideostar said: > thanks, @sa2000. > > i know forums are support based, > but i assume logs contain private info. > > either way, logs, attached: The database is corrupt ```auto Feb 08, 2017 12:01:51.623 [0x7fff76269310] ERROR - SQLITE3:0x7fff5e2df260, 11, database corruption at line 59437 of [fc49f556e4] Feb 08, 2017 12:01:51.623 [0x7fff76269310] ERROR - SQLITE3:0x7fff5e2df260, 11, database corruption at line 59479 of [fc49f556e4] Feb 08, 2017 12:01:51.623 [0x7fff76269310] ERROR - SQLITE3:0x7fff5e2df260, 11, statement aborts at 14: [DELETE FROM 'main'.'fts4_metadata_titles_segdir' WHERE level = ?] database disk image is malformed Feb 08, 2017 12:01:51.623 [0x7fff76269310] ERROR - SQLITE3:0x7fff5e2df260, 11, statement aborts at 9: [insert into metadata_items (library_section_id,parent_id,metadata_type,guid,hash,media_item_count,title,title_sort,original_title,studio,rating,audience_rating,rating_count,tagline,summ Feb 08, 2017 12:01:51.623 [0x7fff76269310] ERROR - Exception inside transaction (inside=1) (../Library/MetadataItem.cpp:869): sqlite3_statement_backend::loadOne: database disk image is malformed Feb 08, 2017 12:01:51.623 [0x7fff76269310] ERROR - Exception inside transaction (inside=1) (../Library/Episode.cpp:187): sqlite3_statement_backend::loadOne: database disk image is malformed Feb 08, 2017 12:01:51.623 [0x7fff76269310] ERROR - Exception inside transaction (inside=1) (../Library/MetadataItem.cpp:2682): sqlite3_statement_backend::loadOne: database disk image is malformed Feb 08, 2017 12:01:51.623 [0x7fff76269310] ERROR - Exception assimilating media item in Colgate Comedy Hour/Season 01: sqlite3_statement_backend::loadOne: database disk image is malformed ``` The database file is `"/Users/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db"` See if it can be repaired [https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database](https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database) Other option is to look for a backup to restore from, see [https://support.plex.tv/hc/en-us/articles/202485658](https://support.plex.tv/hc/en-us/articles/202485658) You should also check the disk drive for any issues ---
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 10, 2017, 4:32pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/10 "2017-02-10T16:32:50Z")
sure enough, @sa2000: ``` sqlite3 ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db "PRAGMA integrity_check" ``` = ``` ***in database main*** Page 216027: btreeInitPage() returns error code 11 Error: database disk image is malformed ``` but, when i try to do ``` sqlite3 ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db .dump > dump.sql mv ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db.original sqlite3 ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db < dump.sql ``` i get a new .db that’s 0b. is there anything else i can do? ---
**Author:** ![sa2000](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sa2000/32/6922_2.png) [@sa2000](https://forums.plex.tv/u/sa2000)\ **Post date:** [February 10, 2017, 10:40pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/11 "2017-02-10T22:40:10Z")
@killthevideostar The important command to salvage data from the corrupt database is this one ```auto sqlite3 ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db .dump > dump.sql ``` Could you see if there is any data in `dump.sql` ---
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 11, 2017, 2:02am UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/12 "2017-02-11T02:02:19Z")
thanks @sa2000, original = 221mb dump = 192mb does that answer your question? ---
**Author:** ![sa2000](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sa2000/32/6922_2.png) [@sa2000](https://forums.plex.tv/u/sa2000)\ **Post date:** [February 11, 2017, 12:17pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/13 "2017-02-11T12:17:37Z")
> @killthevideostar said: > thanks @sa2000, > > original = 221mb > dump = 192mb > > does that answer > your question? I presume you have made sure Plex Media Server is shutdown and not running when doing this? You should be able to view the `dump.sql` file - it is would be a series of sql commands to recreate the database contents Just wondering if the db file was locked when you are doing the last command to restore the dmp file into it. 192Mb ending up as 0 bytes does not sound right Try the last command to restore to a test database file ```auto sqlite3 ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.test.db < dump.sql ``` ---
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 11, 2017, 12:50pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/14 "2017-02-11T12:50:10Z")
thanks, @sa2000. server has been shut down since i attempted any of this. how would i view it? opening 192mb in a text editor doesn’t sound good. will try the last command again. ---
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 11, 2017, 1:06pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/15 "2017-02-11T13:06:21Z")
hey, @sa2000, sure enough: 221 \> 192 \> 0, .db or test.db. ---
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 11, 2017, 1:15pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/16 "2017-02-11T13:15:04Z")
i did open dump.sql in a text editor. lightly browsing, i see a lot of recognizable stuff. ---
**Author:** ![sa2000](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sa2000/32/6922_2.png) [@sa2000](https://forums.plex.tv/u/sa2000)\ **Post date:** [February 11, 2017, 1:55pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/17 "2017-02-11T13:55:50Z")
> @killthevideostar said: > hey, @sa2000, > > sure enough: > > 221 \> 192 \> 0, .db or test.db. You could zip the dump file and upload on dropbox or similar service and send me link by PM and I will have a look. If the file is not usable, then only two remaining options, are to look for a backup to restore the db from or start afresh with a new database as a new install This is the support article for restoring from scheduled tasks backup [https://support.plex.tv/hc/en-us/articles/202485658](https://support.plex.tv/hc/en-us/articles/202485658) ---
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 11, 2017, 1:56pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/18 "2017-02-11T13:56:06Z")
so i googled “repair sqlite database” + found found the following stackexchange: > which gave pretty much the same plex advice on databases. but scrolling down to user “johnrechd” gave me two lines to delete out of the dump. i did this manually, but there’s a grep command in the replies to him. about 30 minutes later, 192 \> 206. deleted -shm + -wal. restarted server. i mini-plex-danced a single episode, +sure enough, it showed up. (although its metadata has not showed yet). but… is there any way to have plex detect “new files plex media server has not added to plex” on all the other ones? ---
**Author:** ![horseinmotion](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/horseinmotion/32/118851_2.png) [@horseinmotion](https://forums.plex.tv/u/horseinmotion)\ **Post date:** [February 11, 2017, 2:01pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/19 "2017-02-11T14:01:17Z")
(also, as i’m plexpass, i have backups from feb 5 • 220mb (when i noticed the last successful plex added episode) feb 2 • 218mb jan 30 • 220mb jan 27 • 217mb which is awesome, as my normal dual backup is misconfigured+ overwrote itself). ---
**Author:** ![sa2000](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/sa2000/32/6922_2.png) [@sa2000](https://forums.plex.tv/u/sa2000)\ **Post date:** [February 11, 2017, 2:02pm UTC](https://forums.plex.tv/t/recently-added-shows-not-showing/179117/20 "2017-02-11T14:02:15Z")
> @killthevideostar said: > so i googled > “repair sqlite database” + found > found the following stackexchange: > > [sqlite - How to recover a corrupt SQLite3 database? - Stack Overflow](http://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database) > > which gave pretty much the same > plex advice on databases. > > but scrolling down to user “johnrechd” > > gave me two lines to delete out > of the dump. i did this manually, > but there’s a grep command in the > replies to him. > > about 30 minutes later, 192 \> 206. > > deleted -shm + -wal. > > restarted server. > > i mini-plex-danced a single > episode, +sure enough, it showed up. > (although its metadata > has not showed yet). Good news Could you tell me which lines you edited out Would be an idea to let me have zip of the original dump.sql file > @killthevideostar said: > but… is there any way to have > plex detect “new files plex media > server has not added to plex” > on all the other ones? All I can suggest is trying out Library Update and Refresh Library [Next page](https://forums.plex.tv/t/recently-added-shows-not-showing/179117.md?page=2)