Canada
MediaPortal Version: 1.1.5.0
MediaPortal Skin: 1.1.0.0
Windows Version: Win7 Ultimate
CPU Type: Pentium dual core e5500
HDD: ATA
Memory: DDR3 1066 4gb
Motherboard: gigabyte GA-G41MT-ES2L
Video Card: ATI Radeon HD4300
Video Card Driver:
Sound Card: On Board
Sound Card AC3:
Sound Card Driver:
1. TV Card:
1. TV Card Type:
1. TV Card Driver:
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote:
TV:
TV - HTPC Connection:
hello,
a few days ago we had a power failure while MP was running. It still loads but is now painfully slow, and is full of latency. With MP shut down the PC behaves normally. Nothing in the error log and memory checks fine.
within the MP files I found the error.bak file. It reports the following error over and over. Sounds like corruption after a SQL query. What do I need to repair/replace to get past this?
2011-06-28 10:21:02.119990 [ERROR][DirectoryWorker(23)]: 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.myRating, 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.ID = 81189 and local_series.DuplicateLocalName = 0 and local_series.Hidden = 0 and online_series.id in( select distinct online_episodes.SeriesID from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID) where local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.CompositeID2 != '') union select distinct online_episodes.SeriesID from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID) where local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and local_episodes.CompositeID2 != '' ) order by upper(online_series.Pretty_Name)
MediaPortal Skin: 1.1.0.0
Windows Version: Win7 Ultimate
CPU Type: Pentium dual core e5500
HDD: ATA
Memory: DDR3 1066 4gb
Motherboard: gigabyte GA-G41MT-ES2L
Video Card: ATI Radeon HD4300
Video Card Driver:
Sound Card: On Board
Sound Card AC3:
Sound Card Driver:
1. TV Card:
1. TV Card Type:
1. TV Card Driver:
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote:
TV:
TV - HTPC Connection:
hello,
a few days ago we had a power failure while MP was running. It still loads but is now painfully slow, and is full of latency. With MP shut down the PC behaves normally. Nothing in the error log and memory checks fine.
within the MP files I found the error.bak file. It reports the following error over and over. Sounds like corruption after a SQL query. What do I need to repair/replace to get past this?
2011-06-28 10:21:02.119990 [ERROR][DirectoryWorker(23)]: 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.myRating, 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.ID = 81189 and local_series.DuplicateLocalName = 0 and local_series.Hidden = 0 and online_series.id in( select distinct online_episodes.SeriesID from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID) where local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.CompositeID2 != '') union select distinct online_episodes.SeriesID from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID) where local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and local_episodes.CompositeID2 != '' ) order by upper(online_series.Pretty_Name)