home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
General Support
Corruption after power failure
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="carntsen" data-source="post: 761108" data-attributes="member: 114034"><p><strong>MediaPortal Version</strong>: 1.1.5.0</p><p><strong>MediaPortal Skin</strong>: 1.1.0.0</p><p><strong>Windows Version</strong>: Win7 Ultimate</p><p><strong>CPU Type</strong>: Pentium dual core e5500</p><p><strong>HDD</strong>: ATA</p><p><strong>Memory</strong>: DDR3 1066 4gb</p><p><strong>Motherboard</strong>: gigabyte GA-G41MT-ES2L</p><p><strong>Video Card</strong>: ATI Radeon HD4300 </p><p><strong>Video Card Driver</strong>: </p><p><strong>Sound Card</strong>: On Board</p><p><strong>Sound Card AC3</strong>: </p><p><strong>Sound Card Driver</strong>: </p><p><strong>1. TV Card</strong>: </p><p><strong>1. TV Card Type</strong>: </p><p><strong>1. TV Card Driver</strong>: </p><p><strong>2. TV Card</strong>: </p><p><strong>2. TV Card Type</strong>: </p><p><strong>2. TV Card Driver</strong>: </p><p><strong>3. TV Card</strong>: </p><p><strong>3. TV Card Type</strong>: </p><p><strong>3. TV Card Driver</strong>: </p><p><strong>4. TV Card</strong>: </p><p><strong>4. TV Card Type</strong>: </p><p><strong>4. TV Card Driver</strong>: </p><p><strong>MPEG2 Video Codec</strong>: </p><p><strong>MPEG2 Audio Codec</strong>: </p><p><strong>h.264 Video Codec</strong>: </p><p><strong>Satelite/CableTV Provider</strong>: </p><p><strong>HTPC Case</strong>: </p><p><strong>Cooling</strong>: </p><p><strong>Power Supply</strong>: </p><p><strong>Remote</strong>: </p><p><strong>TV</strong>: </p><p><strong>TV - HTPC Connection</strong>: </p><p></p><p></p><p>hello, </p><p>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. </p><p></p><p>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?</p><p></p><p></p><p>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)</p></blockquote><p></p>
[QUOTE="carntsen, post: 761108, member: 114034"] [b]MediaPortal Version[/b]: 1.1.5.0 [b]MediaPortal Skin[/b]: 1.1.0.0 [b]Windows Version[/b]: Win7 Ultimate [b]CPU Type[/b]: Pentium dual core e5500 [b]HDD[/b]: ATA [b]Memory[/b]: DDR3 1066 4gb [b]Motherboard[/b]: gigabyte GA-G41MT-ES2L [b]Video Card[/b]: ATI Radeon HD4300 [b]Video Card Driver[/b]: [b]Sound Card[/b]: On Board [b]Sound Card AC3[/b]: [b]Sound Card Driver[/b]: [b]1. TV Card[/b]: [b]1. TV Card Type[/b]: [b]1. TV Card Driver[/b]: [b]2. TV Card[/b]: [b]2. TV Card Type[/b]: [b]2. TV Card Driver[/b]: [b]3. TV Card[/b]: [b]3. TV Card Type[/b]: [b]3. TV Card Driver[/b]: [b]4. TV Card[/b]: [b]4. TV Card Type[/b]: [b]4. TV Card Driver[/b]: [b]MPEG2 Video Codec[/b]: [b]MPEG2 Audio Codec[/b]: [b]h.264 Video Codec[/b]: [b]Satelite/CableTV Provider[/b]: [b]HTPC Case[/b]: [b]Cooling[/b]: [b]Power Supply[/b]: [b]Remote[/b]: [b]TV[/b]: [b]TV - HTPC Connection[/b]: 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) [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
Corruption after power failure
Contact us
RSS
Top
Bottom
