Commit Failed? (1 Viewer)

[bcdudley]

I came in from work today, turned to MPTV and all my series were gone. I made sure that they were all still on the hard drive. I am getting this message in the error logs... Any ideas?

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.TraktIgnore, 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, 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.TraktIgnore, 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, 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)).

I also tried erasing the db (after making a backup), but I get the same error. Sometimes, it comes up and says the database file is corrupt as well.

 

[bcdudley]

The same thing just happened to me yesterday. When I got home from work and turned on MPTV, I had nothing in there. I got the exact same error and I also tried to delete the database after making a backup. I am getting the same results. I am thinking it is a problem with thetvdb.com or is it possible that an update was pushed out that could cause this?