Series gone? (1 Viewer)

[BlackShadow]

Hi,

I use tv-series plugins a while now and like it very much.
I'm currently not on the lastest build but recently I had a problem.
When I go to tv series in mediaportal it sais 0 series.

When I go to the configuration of tv series and go to about it sais:
0 series 5435 episodes.
How come my series are gone?
Database corrupt?

What is the best way to rescan/recheck my series without starting from empty database?

BlackShadow

 

[BlackShadow]

I just emptied my database and re-imported half of my series and it worked, they became visible.
I than re-import the rest of my series and import was success but my series count is 0 again even when he sais 5435 episodes.
I'm still on mediaportal 1.1.2
Should I update tv-series plugin? To what version?
I have 2.6.6

BlackShadow

 

[mastyman]

Sounds like your database might be corrupt but you havent posted your logs so only a guess

FAQ on database corruption and how to resolve it is here

Also you could update your TVSeries to the latest but it wont fix a corrupt database

MEDIAPORTAL - MP-TVSeries

 

[BlackShadow]

Hi,

I updated to 2.9 and still same problem (even afther empty database and re-import)
I gues I try deleting the database and start from brand new one
The log:

00000001 - 19/04/2011 23:11:14 - **** Plugin started in configuration mode ***
00000001 - 19/04/2011 23:11:14 - Loading Skin Settings: v1.1.0.0
00000001 - 19/04/2011 23:11:14 - Loading Supported Layouts Skin Settings
00000001 - 19/04/2011 23:11:14 - Loading Skin Group View Settings
00000001 - 19/04/2011 23:11:14 - Loading Skin Series View Settings
00000001 - 19/04/2011 23:11:14 - Loading Skin Season View Settings
00000001 - 19/04/2011 23:11:14 - Loading Skin Episode View Settings
00000001 - 19/04/2011 23:11:14 - Loading Skin Thumbnail Graphics Quality
00000001 - 19/04/2011 23:11:14 - Loading Skin Formatting Rules
00000001 - 19/04/2011 23:11:21 - Loading Skin Logo Rules
00000001 - 19/04/2011 23:11:21 - Loading images to be loaded in video OSD
00000001 - 19/04/2011 23:11:21 - Loading images to be loaded during video play
00000001 - 19/04/2011 23:11:21 - Loading Settings for Thumbs NewStamp positions
00000001 - 19/04/2011 23:11:21 - Loading Skin Defines
00000001 - 19/04/2011 23:11:21 - Loading Translations for nl
00000001 - 19/04/2011 23:11:21 - 228 translated Strings found
00000010 - 19/04/2011 23:11:21 - Retrieving a list of languages from online
00000001 - 19/04/2011 23:11:37 - Commit failed on this command: <select online_series.ID, online_series.Pretty_Name, online_series.SortName, online_series.origName, online_series.Status, online_series.Genre, online_series.BannerFileNames, online_series.CurrentBannerFileName, online_series.PosterFileNames, online_series.PosterBannerFileName, online_series.Summary, online_series.OnlineDataImported, online_series.AirsDay, online_series.AirsTime, online_series.Actors, online_series.EpisodeOrders, online_series.choosenOrder, online_series.EpisodeSortOrder, online_series.BannersDownloaded, online_series.HasLocalFiles, online_series.HasLocalFiles_Temp, online_series.GetEpisodesTimeStamp, online_series.UpdateBannersTimeStamp, online_series.WatchedFileTimeStamp, online_series.UnwatchedItems, online_series.EpisodeCount, online_series.EpisodesUnWatched, online_series.ViewTags, online_series.language, online_series.banner, online_series.FirstAired, online_series.IMDB_ID, online_series.zap2it_id, online_series.ContentRating, online_series.Network, online_series.NetworkID, online_series.Rating, online_series.RatingCount, online_series.Runtime, online_series.SeriesID, online_series.added, online_series.addedBy, online_series.fanart, online_series.lastupdated, online_series.poster, online_series.HasNewEpisodes, online_series.TraktIgnore, local_series.Parsed_Name, local_series.ID, local_series.ScanIgnore, local_series.DuplicateLocalName, local_series.Hidden from online_series left join local_series on local_series.ID==online_series.ID where local_series.DuplicateLocalName = 0 and local_series.Hidden = 0 order by upper(online_series.Pretty_Name)> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select online_series.ID, online_series.Pretty_Name, online_series.SortName, online_series.origName, online_series.Status, online_series.Genre, online_series.BannerFileNames, online_series.CurrentBannerFileName, online_series.PosterFileNames, online_series.PosterBannerFileName, online_series.Summary, online_series.OnlineDataImported, online_series.AirsDay, online_series.AirsTime, online_series.Actors, online_series.EpisodeOrders, online_series.choosenOrder, online_series.EpisodeSortOrder, online_series.BannersDownloaded, online_series.HasLocalFiles, online_series.HasLocalFiles_Temp, online_series.GetEpisodesTimeStamp, online_series.UpdateBannersTimeStamp, online_series.WatchedFileTimeStamp, online_series.UnwatchedItems, online_series.EpisodeCount, online_series.EpisodesUnWatched, online_series.ViewTags, online_series.language, online_series.banner, online_series.FirstAired, online_series.IMDB_ID, online_series.zap2it_id, online_series.ContentRating, online_series.Network, online_series.NetworkID, online_series.Rating, online_series.RatingCount, online_series.Runtime, online_series.SeriesID, online_series.added, online_series.addedBy, online_series.fanart, online_series.lastupdated, online_series.poster, online_series.HasNewEpisodes, online_series.TraktIgnore, local_series.Parsed_Name, local_series.ID, local_series.ScanIgnore, local_series.DuplicateLocalName, local_series.Hidden from online_series left join local_series on local_series.ID==online_series.ID where local_series.DuplicateLocalName = 0 and local_series.Hidden = 0 order by upper(online_series.Pretty_Name)).
00000001 - 19/04/2011 23:11:38 - Successfully retrieved 23 languages from online

 

[mastyman]

empty the database wont help when its corrupted, you need to delete the database file and start again or restore from a backup

FAQ - mptvseries - Frequently Asked Questions. - MP-TVSeries: plug-in for organizing TV shows in MediaPortal - Google Project Hosting

 

[BlackShadow]

Thanks for the info.
I deleted the database, re-imported everything and now it works again

BlackShadow