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
MediaPortal 1 Plugins
Popular Plugins
My TVSeries
Big problems with MyTV-series! (Database gone and won't readd!)
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="Geirern" data-source="post: 423292" data-attributes="member: 88264"><p>Not really sure if this is what you need, but this is the log from TVseries</p><p></p><p>[CODE]00000001 - 22.05.2009 23:24:34 - Switched LogLevel to: Normal</p><p>00000001 - 22.05.2009 23:24:34 - MP-TVSeries Version: v2.2.3389</p><p>00000001 - 22.05.2009 23:24:34 - MP-TVSeries Build Date: 12.04.2009 22:45:40</p><p>00000001 - 22.05.2009 23:24:34 - Successfully opened database 'C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal\Database\TVSeriesDatabase4.db3'</p><p>00000001 - 22.05.2009 23:24:48 - **** Plugin started in configuration mode ***</p><p>00000001 - 22.05.2009 23:24:48 - Loading Skin Settings: v1.1.0.0</p><p>00000001 - 22.05.2009 23:24:48 - Loading Supported Layouts Skin Settings</p><p>00000001 - 22.05.2009 23:24:48 - Loading Skin Group View Settings</p><p>00000001 - 22.05.2009 23:24:48 - Loading Skin Series View Settings</p><p>00000001 - 22.05.2009 23:24:48 - Loading Skin Season View Settings</p><p>00000001 - 22.05.2009 23:24:48 - Loading Skin Episode View Settings</p><p>00000001 - 22.05.2009 23:24:48 - Loading Skin Formatting Rules</p><p>00000001 - 22.05.2009 23:24:53 - Commit failed on this command: <delete from FormattingRules> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:delete from FormattingRules).</p><p>00000001 - 22.05.2009 23:24:58 - Commit failed on this command: <select * from FormattingRules where FormattingRules.ID = 10> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select * from FormattingRules where FormattingRules.ID = 10).</p><p>00000001 - 22.05.2009 23:25:03 - Commit failed on this command: <update FormattingRules set enabled = 1,Replace = '<Episode.InfoPanelLine6Key>',With = 'VIDEO INFO' where ID = 10> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:update FormattingRules set enabled = 1,Replace = '<Episode.InfoPanelLine6Key>',With = 'VIDEO INFO' where ID = 10).</p><p>00000001 - 22.05.2009 23:25:08 - Commit failed on this command: <select * from FormattingRules where FormattingRules.ID = 11> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select * from FormattingRules where FormattingRules.ID = 11).</p><p>00000001 - 22.05.2009 23:25:13 - Commit failed on this command: <update FormattingRules set enabled = 1,Replace = '<Episode.InfoPanelLine6Value>',With = '[<Episode.VideoCodec> <Episode.videoWidth>x<Episode.videoHeight> Eval(Round(<Episode.VideoAspectRatio>*100)/100) Eval(Round(<Episode.VideoFrameRate>*1000)/1000)fps Eval(Round(PrettyBytes1000(<Episode.VideoBitrate>)*10)/10-> |Kbps|Mbps|Gbps)] [<Episode.AudioCodec> <Episode.AudioChannels>channels Eval(Round(PrettyBytes1000(<Episode.AudioBitrate>)*10)/10-> |Kbps|Mbps|Gbps)] [<Episode.FileSize>]' where ID = 11> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:update FormattingRules set enabled = 1,Replace = '<Episode.InfoPanelLine6Value>',With = '[<Episode.VideoCodec> <Episode.videoWidth>x<Episode.videoHeight> Eval(Round(<Episode.VideoAspectRatio>*100)/100) Eval(Round(<Episode.VideoFrameRate>*1000)/1000)fps Eval(Round(PrettyBytes1000(<Episode.VideoBitrate>)*10)/10-> |Kbps|Mbps|Gbps)] [<Episode.AudioCodec> <Episode.AudioChannels>channels Eval(Round(PrettyBytes1000(<Episode.AudioBitrate>)*10)/10-> |Kbps|Mbps|Gbps)] [<Episode.FileSize>]' where ID = 11).</p><p>00000001 - 22.05.2009 23:25:14 - Loading Skin Logo Rules</p><p>00000001 - 22.05.2009 23:25:19 - Commit failed on this command: <select value from options where property = 'logoConfig'> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select value from options where property = 'logoConfig').</p><p>00000001 - 22.05.2009 23:25:25 - Commit failed on this command: <update options set value = 'skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 43.png;-;<Episode.videoWidth>;-;<;-;960;-;AND;-;<Episode.VideoAspectRatio>;-;<;-;1.5;-;AND;-;<Episode.VideoAspectRatio>;-;>;-;1.2;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 169.png;-;<Episode.videoWidth>;-;<;-;960;-;AND;-;<Episode.VideoAspectRatio>;-;<;-;1.9;-;AND;-;<Episode.VideoAspectRatio>;-;>=;-;1.5;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 540P.png;-;<Episode.videoWidth>;-;=;-;960;-;AND;-;<Episode.videoHeight>;-;<=;-;600;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HD 720P.png;-;<Episode.videoWidth>;-;=;-;1280;-;AND;-;<Episode.videoHeight>;-;<=;-;720;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HD 1080P.png;-;<Episode.videoWidth>;-;=;-;1920;-;AND;-;<Episode.videoHeight>;-;<=;-;1080;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DVD.png;-;<Episode.EpisodeFilename>;-;contains;-;DVD;-;AND;-;<Episode.EpisodeFilename>;-;!contains;-;HDDVD;-;AND;-;<Episode.EpisodeFilename>;-;!contains;-;HD-DVD;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HDTV.png;-;<Episode.EpisodeFilename>;-;contains;-;HDTV;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HDDVD.png;-;<Episode.EpisodeFilename>;-;contains;-;HDDVD;-;OR;-;<Episode.EpisodeFilename>;-;contains;-;HD-DVD;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\BLURAY.png;-;<Episode.EpisodeFilename>;-;contains;-;BLURAY;-;OR;-;<Episode.EpisodeFilename>;-;contains;-;BLU-RAY;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\H264.png;-;<Episode.VideoCodec>;-;contains;-;AVC;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\MPEG2.png;-;<Episode.VideoCodec>;-;contains;-;MPEG;-;AND;-;<Episode.VideoCodec>;-;!contains;-;AVC;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DIVX.png;-;<Episode.VideoCodec>;-;contains;-;DIVX;-;OR;-;<Episode.VideoCodec>;-;contains;-;DX50;-;OR;-;<Episode.VideoCodec>;-;contains;-;DIV3;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\XVID.png;-;<Episode.VideoCodec>;-;contains;-;XVID;-;OR;-;<Episode.VideoCodec>;-;contains;-;MPG4;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DD 20.png;-;<Episode.AudioCodec>;-;=;-;AC3;-;AND;-;<Episode.AudioChannels>;-;=;-;2;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DD 51.png;-;<Episode.AudioCodec>;-;=;-;AC3;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DTS 51.png;-;<Episode.AudioCodec>;-;=;-;DTS;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\FLAC 51.png;-;<Episode.AudioCodec>;-;contains;-;FLAC;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\MP3 20.png;-;<Episode.AudioCodec>;-;contains;-;MPA1L3;-;OR;-;<Episode.AudioCodec>;-;contains;-;MPA2L3;-;AND;-;<Episode.AudioChannels>;-;=;-;2;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SUBTITLES.png;-;<Episode.AvailableSubtitles>;-;=;-;1;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<next>skin\StreamedMP\Media\TVSeries\Logos\Misc\AAC.png;-;<Episode.AudioCodec>;-;contains;-;AAC;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\VORBIS.png;-;<Episode.AudioCodec>;-;contains;-;VORBIS;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode>' where property = 'logoConfig'> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:update options set value = 'skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 43.png;-;<Episode.videoWidth>;-;<;-;960;-;AND;-;<Episode.VideoAspectRatio>;-;<;-;1.5;-;AND;-;<Episode.VideoAspectRatio>;-;>;-;1.2;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 169.png;-;<Episode.videoWidth>;-;<;-;960;-;AND;-;<Episode.VideoAspectRatio>;-;<;-;1.9;-;AND;-;<Episode.VideoAspectRatio>;-;>=;-;1.5;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 540P.png;-;<Episode.videoWidth>;-;=;-;960;-;AND;-;<Episode.videoHeight>;-;<=;-;600;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HD 720P.png;-;<Episode.videoWidth>;-;=;-;1280;-;AND;-;<Episode.videoHeight>;-;<=;-;720;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HD 1080P.png;-;<Episode.videoWidth>;-;=;-;1920;-;AND;-;<Episode.videoHeight>;-;<=;-;1080;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DVD.png;-;<Episode.EpisodeFilename>;-;contains;-;DVD;-;AND;-;<Episode.EpisodeFilename>;-;!contains;-;HDDVD;-;AND;-;<Episode.EpisodeFilename>;-;!contains;-;HD-DVD;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HDTV.png;-;<Episode.EpisodeFilename>;-;contains;-;HDTV;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HDDVD.png;-;<Episode.EpisodeFilename>;-;contains;-;HDDVD;-;OR;-;<Episode.EpisodeFilename>;-;contains;-;HD-DVD;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\BLURAY.png;-;<Episode.EpisodeFilename>;-;contains;-;BLURAY;-;OR;-;<Episode.EpisodeFilename>;-;contains;-;BLU-RAY;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\H264.png;-;<Episode.VideoCodec>;-;contains;-;AVC;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\MPEG2.png;-;<Episode.VideoCodec>;-;contains;-;MPEG;-;AND;-;<Episode.VideoCodec>;-;!contains;-;AVC;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DIVX.png;-;<Episode.VideoCodec>;-;contains;-;DIVX;-;OR;-;<Episode.VideoCodec>;-;contains;-;DX50;-;OR;-;<Episode.VideoCodec>;-;contains;-;DIV3;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\XVID.png;-;<Episode.VideoCodec>;-;contains;-;XVID;-;OR;-;<Episode.VideoCodec>;-;contains;-;MPG4;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DD 20.png;-;<Episode.AudioCodec>;-;=;-;AC3;-;AND;-;<Episode.AudioChannels>;-;=;-;2;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DD 51.png;-;<Episode.AudioCodec>;-;=;-;AC3;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DTS 51.png;-;<Episode.AudioCodec>;-;=;-;DTS;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\FLAC 51.png;-;<Episode.AudioCodec>;-;contains;-;FLAC;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\MP3 20.png;-;<Episode.AudioCodec>;-;contains;-;MPA1L3;-;OR;-;<Episode.AudioCodec>;-;contains;-;MPA2L3;-;AND;-;<Episode.AudioChannels>;-;=;-;2;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SUBTITLES.png;-;<Episode.AvailableSubtitles>;-;=;-;1;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<next>skin\StreamedMP\Media\TVSeries\Logos\Misc\AAC.png;-;<Episode.AudioCodec>;-;contains;-;AAC;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\VORBIS.png;-;<Episode.AudioCodec>;-;contains;-;VORBIS;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode>' where property = 'logoConfig').</p><p>00000001 - 22.05.2009 23:25:25 - Loading Graphics Quality</p><p>00000001 - 22.05.2009 23:25:30 - Loading Translations for en(us)</p><p>00000001 - 22.05.2009 23:25:30 - 131 translated Strings found</p><p>00000001 - 22.05.2009 23:25:36 - Commit failed on this command: <select online_series.ID, online_series.Pretty_Name, online_series.SortName, 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.BannersDownloaded, online_series.HasLocalFiles, online_series.HasLocalFiles_Temp, online_series.GetEpisodesTimeStamp, online_series.UpdateBannersTimeStamp, online_series.isFavourite, online_series.WatchedFileTimeStamp, online_series.UnwatchedItems, online_series.EpisodeCount, online_series.EpisodesUnWatched, online_series.language, online_series.banner, online_series.FirstAired, online_series.IMDB_ID, online_series.zap2it_id, online_series.EpisodeOrders, online_series.choosenOrder, online_series.ContentRating, online_series.Network, online_series.NetworkID, online_series.Rating, online_series.Runtime, online_series.SeriesID, online_series.added, online_series.addedBy, online_series.fanart, online_series.lastupdated, online_series.poster, 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 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.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.BannersDownloaded, online_series.HasLocalFiles, online_series.HasLocalFiles_Temp, online_series.GetEpisodesTimeStamp, online_series.UpdateBannersTimeStamp, online_series.isFavourite, online_series.WatchedFileTimeStamp, online_series.UnwatchedItems, online_series.EpisodeCount, online_series.EpisodesUnWatched, online_series.language, online_series.banner, online_series.FirstAired, online_series.IMDB_ID, online_series.zap2it_id, online_series.EpisodeOrders, online_series.choosenOrder, online_series.ContentRating, online_series.Network, online_series.NetworkID, online_series.Rating, online_series.Runtime, online_series.SeriesID, online_series.added, online_series.addedBy, online_series.fanart, online_series.lastupdated, online_series.poster, 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 order by upper(online_series.Pretty_Name)).</p><p>00000001 - 22.05.2009 23:25:41 - Commit failed on this command: <select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.DownloadPending, online_episodes.DownloadExpectedName, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.AvailableSubtitles, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.ext, local_episodes.Removable, local_episodes.StopTime, local_episodes.AudioTracks, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID) where online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.CompositeID2 != '') union select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.DownloadPending, online_episodes.DownloadExpectedName, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.AvailableSubtitles, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.ext, local_episodes.Removable, local_episodes.StopTime, local_episodes.AudioTracks, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID) where local_episodes.CompositeID2 != '' order by online_episodesEpisodeIndex asc > (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.DownloadPending, online_episodes.DownloadExpectedName, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.AvailableSubtitles, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.ext, local_episodes.Removable, local_episodes.StopTime, local_episodes.AudioTracks, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID) where online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.CompositeID2 != '') union select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.DownloadPending, online_episodes.DownloadExpectedName, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.AvailableSubtitles, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.ext, local_episodes.Removable, local_episodes.StopTime, local_episodes.AudioTracks, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID) where local_episodes.CompositeID2 != '' order by online_episodesEpisodeIndex asc ).</p><p>[/CODE]</p></blockquote><p></p>
[QUOTE="Geirern, post: 423292, member: 88264"] Not really sure if this is what you need, but this is the log from TVseries [CODE]00000001 - 22.05.2009 23:24:34 - Switched LogLevel to: Normal 00000001 - 22.05.2009 23:24:34 - MP-TVSeries Version: v2.2.3389 00000001 - 22.05.2009 23:24:34 - MP-TVSeries Build Date: 12.04.2009 22:45:40 00000001 - 22.05.2009 23:24:34 - Successfully opened database 'C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal\Database\TVSeriesDatabase4.db3' 00000001 - 22.05.2009 23:24:48 - **** Plugin started in configuration mode *** 00000001 - 22.05.2009 23:24:48 - Loading Skin Settings: v1.1.0.0 00000001 - 22.05.2009 23:24:48 - Loading Supported Layouts Skin Settings 00000001 - 22.05.2009 23:24:48 - Loading Skin Group View Settings 00000001 - 22.05.2009 23:24:48 - Loading Skin Series View Settings 00000001 - 22.05.2009 23:24:48 - Loading Skin Season View Settings 00000001 - 22.05.2009 23:24:48 - Loading Skin Episode View Settings 00000001 - 22.05.2009 23:24:48 - Loading Skin Formatting Rules 00000001 - 22.05.2009 23:24:53 - Commit failed on this command: <delete from FormattingRules> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:delete from FormattingRules). 00000001 - 22.05.2009 23:24:58 - Commit failed on this command: <select * from FormattingRules where FormattingRules.ID = 10> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select * from FormattingRules where FormattingRules.ID = 10). 00000001 - 22.05.2009 23:25:03 - Commit failed on this command: <update FormattingRules set enabled = 1,Replace = '<Episode.InfoPanelLine6Key>',With = 'VIDEO INFO' where ID = 10> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:update FormattingRules set enabled = 1,Replace = '<Episode.InfoPanelLine6Key>',With = 'VIDEO INFO' where ID = 10). 00000001 - 22.05.2009 23:25:08 - Commit failed on this command: <select * from FormattingRules where FormattingRules.ID = 11> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select * from FormattingRules where FormattingRules.ID = 11). 00000001 - 22.05.2009 23:25:13 - Commit failed on this command: <update FormattingRules set enabled = 1,Replace = '<Episode.InfoPanelLine6Value>',With = '[<Episode.VideoCodec> <Episode.videoWidth>x<Episode.videoHeight> Eval(Round(<Episode.VideoAspectRatio>*100)/100) Eval(Round(<Episode.VideoFrameRate>*1000)/1000)fps Eval(Round(PrettyBytes1000(<Episode.VideoBitrate>)*10)/10-> |Kbps|Mbps|Gbps)] [<Episode.AudioCodec> <Episode.AudioChannels>channels Eval(Round(PrettyBytes1000(<Episode.AudioBitrate>)*10)/10-> |Kbps|Mbps|Gbps)] [<Episode.FileSize>]' where ID = 11> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:update FormattingRules set enabled = 1,Replace = '<Episode.InfoPanelLine6Value>',With = '[<Episode.VideoCodec> <Episode.videoWidth>x<Episode.videoHeight> Eval(Round(<Episode.VideoAspectRatio>*100)/100) Eval(Round(<Episode.VideoFrameRate>*1000)/1000)fps Eval(Round(PrettyBytes1000(<Episode.VideoBitrate>)*10)/10-> |Kbps|Mbps|Gbps)] [<Episode.AudioCodec> <Episode.AudioChannels>channels Eval(Round(PrettyBytes1000(<Episode.AudioBitrate>)*10)/10-> |Kbps|Mbps|Gbps)] [<Episode.FileSize>]' where ID = 11). 00000001 - 22.05.2009 23:25:14 - Loading Skin Logo Rules 00000001 - 22.05.2009 23:25:19 - Commit failed on this command: <select value from options where property = 'logoConfig'> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select value from options where property = 'logoConfig'). 00000001 - 22.05.2009 23:25:25 - Commit failed on this command: <update options set value = 'skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 43.png;-;<Episode.videoWidth>;-;<;-;960;-;AND;-;<Episode.VideoAspectRatio>;-;<;-;1.5;-;AND;-;<Episode.VideoAspectRatio>;-;>;-;1.2;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 169.png;-;<Episode.videoWidth>;-;<;-;960;-;AND;-;<Episode.VideoAspectRatio>;-;<;-;1.9;-;AND;-;<Episode.VideoAspectRatio>;-;>=;-;1.5;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 540P.png;-;<Episode.videoWidth>;-;=;-;960;-;AND;-;<Episode.videoHeight>;-;<=;-;600;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HD 720P.png;-;<Episode.videoWidth>;-;=;-;1280;-;AND;-;<Episode.videoHeight>;-;<=;-;720;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HD 1080P.png;-;<Episode.videoWidth>;-;=;-;1920;-;AND;-;<Episode.videoHeight>;-;<=;-;1080;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DVD.png;-;<Episode.EpisodeFilename>;-;contains;-;DVD;-;AND;-;<Episode.EpisodeFilename>;-;!contains;-;HDDVD;-;AND;-;<Episode.EpisodeFilename>;-;!contains;-;HD-DVD;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HDTV.png;-;<Episode.EpisodeFilename>;-;contains;-;HDTV;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HDDVD.png;-;<Episode.EpisodeFilename>;-;contains;-;HDDVD;-;OR;-;<Episode.EpisodeFilename>;-;contains;-;HD-DVD;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\BLURAY.png;-;<Episode.EpisodeFilename>;-;contains;-;BLURAY;-;OR;-;<Episode.EpisodeFilename>;-;contains;-;BLU-RAY;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\H264.png;-;<Episode.VideoCodec>;-;contains;-;AVC;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\MPEG2.png;-;<Episode.VideoCodec>;-;contains;-;MPEG;-;AND;-;<Episode.VideoCodec>;-;!contains;-;AVC;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DIVX.png;-;<Episode.VideoCodec>;-;contains;-;DIVX;-;OR;-;<Episode.VideoCodec>;-;contains;-;DX50;-;OR;-;<Episode.VideoCodec>;-;contains;-;DIV3;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\XVID.png;-;<Episode.VideoCodec>;-;contains;-;XVID;-;OR;-;<Episode.VideoCodec>;-;contains;-;MPG4;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DD 20.png;-;<Episode.AudioCodec>;-;=;-;AC3;-;AND;-;<Episode.AudioChannels>;-;=;-;2;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DD 51.png;-;<Episode.AudioCodec>;-;=;-;AC3;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DTS 51.png;-;<Episode.AudioCodec>;-;=;-;DTS;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\FLAC 51.png;-;<Episode.AudioCodec>;-;contains;-;FLAC;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\MP3 20.png;-;<Episode.AudioCodec>;-;contains;-;MPA1L3;-;OR;-;<Episode.AudioCodec>;-;contains;-;MPA2L3;-;AND;-;<Episode.AudioChannels>;-;=;-;2;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SUBTITLES.png;-;<Episode.AvailableSubtitles>;-;=;-;1;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<next>skin\StreamedMP\Media\TVSeries\Logos\Misc\AAC.png;-;<Episode.AudioCodec>;-;contains;-;AAC;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\VORBIS.png;-;<Episode.AudioCodec>;-;contains;-;VORBIS;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode>' where property = 'logoConfig'> (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:update options set value = 'skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 43.png;-;<Episode.videoWidth>;-;<;-;960;-;AND;-;<Episode.VideoAspectRatio>;-;<;-;1.5;-;AND;-;<Episode.VideoAspectRatio>;-;>;-;1.2;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 169.png;-;<Episode.videoWidth>;-;<;-;960;-;AND;-;<Episode.VideoAspectRatio>;-;<;-;1.9;-;AND;-;<Episode.VideoAspectRatio>;-;>=;-;1.5;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SD 540P.png;-;<Episode.videoWidth>;-;=;-;960;-;AND;-;<Episode.videoHeight>;-;<=;-;600;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HD 720P.png;-;<Episode.videoWidth>;-;=;-;1280;-;AND;-;<Episode.videoHeight>;-;<=;-;720;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HD 1080P.png;-;<Episode.videoWidth>;-;=;-;1920;-;AND;-;<Episode.videoHeight>;-;<=;-;1080;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DVD.png;-;<Episode.EpisodeFilename>;-;contains;-;DVD;-;AND;-;<Episode.EpisodeFilename>;-;!contains;-;HDDVD;-;AND;-;<Episode.EpisodeFilename>;-;!contains;-;HD-DVD;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HDTV.png;-;<Episode.EpisodeFilename>;-;contains;-;HDTV;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\HDDVD.png;-;<Episode.EpisodeFilename>;-;contains;-;HDDVD;-;OR;-;<Episode.EpisodeFilename>;-;contains;-;HD-DVD;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\BLURAY.png;-;<Episode.EpisodeFilename>;-;contains;-;BLURAY;-;OR;-;<Episode.EpisodeFilename>;-;contains;-;BLU-RAY;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\H264.png;-;<Episode.VideoCodec>;-;contains;-;AVC;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\MPEG2.png;-;<Episode.VideoCodec>;-;contains;-;MPEG;-;AND;-;<Episode.VideoCodec>;-;!contains;-;AVC;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DIVX.png;-;<Episode.VideoCodec>;-;contains;-;DIVX;-;OR;-;<Episode.VideoCodec>;-;contains;-;DX50;-;OR;-;<Episode.VideoCodec>;-;contains;-;DIV3;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\XVID.png;-;<Episode.VideoCodec>;-;contains;-;XVID;-;OR;-;<Episode.VideoCodec>;-;contains;-;MPG4;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DD 20.png;-;<Episode.AudioCodec>;-;=;-;AC3;-;AND;-;<Episode.AudioChannels>;-;=;-;2;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DD 51.png;-;<Episode.AudioCodec>;-;=;-;AC3;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\DTS 51.png;-;<Episode.AudioCodec>;-;=;-;DTS;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\FLAC 51.png;-;<Episode.AudioCodec>;-;contains;-;FLAC;-;AND;-;<Episode.AudioChannels>;-;=;-;6;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\MP3 20.png;-;<Episode.AudioCodec>;-;contains;-;MPA1L3;-;OR;-;<Episode.AudioCodec>;-;contains;-;MPA2L3;-;AND;-;<Episode.AudioChannels>;-;=;-;2;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\SUBTITLES.png;-;<Episode.AvailableSubtitles>;-;=;-;1;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<next>skin\StreamedMP\Media\TVSeries\Logos\Misc\AAC.png;-;<Episode.AudioCodec>;-;contains;-;AAC;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode><next>skin\StreamedMP\Media\TVSeries\Logos\Misc\VORBIS.png;-;<Episode.AudioCodec>;-;contains;-;VORBIS;-;AND;-;;-;=;-;;-;AND;-;;-;=;-;;-;<Restrict:Episode>' where property = 'logoConfig'). 00000001 - 22.05.2009 23:25:25 - Loading Graphics Quality 00000001 - 22.05.2009 23:25:30 - Loading Translations for en(us) 00000001 - 22.05.2009 23:25:30 - 131 translated Strings found 00000001 - 22.05.2009 23:25:36 - Commit failed on this command: <select online_series.ID, online_series.Pretty_Name, online_series.SortName, 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.BannersDownloaded, online_series.HasLocalFiles, online_series.HasLocalFiles_Temp, online_series.GetEpisodesTimeStamp, online_series.UpdateBannersTimeStamp, online_series.isFavourite, online_series.WatchedFileTimeStamp, online_series.UnwatchedItems, online_series.EpisodeCount, online_series.EpisodesUnWatched, online_series.language, online_series.banner, online_series.FirstAired, online_series.IMDB_ID, online_series.zap2it_id, online_series.EpisodeOrders, online_series.choosenOrder, online_series.ContentRating, online_series.Network, online_series.NetworkID, online_series.Rating, online_series.Runtime, online_series.SeriesID, online_series.added, online_series.addedBy, online_series.fanart, online_series.lastupdated, online_series.poster, 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 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.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.BannersDownloaded, online_series.HasLocalFiles, online_series.HasLocalFiles_Temp, online_series.GetEpisodesTimeStamp, online_series.UpdateBannersTimeStamp, online_series.isFavourite, online_series.WatchedFileTimeStamp, online_series.UnwatchedItems, online_series.EpisodeCount, online_series.EpisodesUnWatched, online_series.language, online_series.banner, online_series.FirstAired, online_series.IMDB_ID, online_series.zap2it_id, online_series.EpisodeOrders, online_series.choosenOrder, online_series.ContentRating, online_series.Network, online_series.NetworkID, online_series.Rating, online_series.Runtime, online_series.SeriesID, online_series.added, online_series.addedBy, online_series.fanart, online_series.lastupdated, online_series.poster, 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 order by upper(online_series.Pretty_Name)). 00000001 - 22.05.2009 23:25:41 - Commit failed on this command: <select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.DownloadPending, online_episodes.DownloadExpectedName, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.AvailableSubtitles, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.ext, local_episodes.Removable, local_episodes.StopTime, local_episodes.AudioTracks, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID) where online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.CompositeID2 != '') union select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.DownloadPending, online_episodes.DownloadExpectedName, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.AvailableSubtitles, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.ext, local_episodes.Removable, local_episodes.StopTime, local_episodes.AudioTracks, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID) where local_episodes.CompositeID2 != '' order by online_episodesEpisodeIndex asc > (SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.DownloadPending, online_episodes.DownloadExpectedName, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.AvailableSubtitles, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.ext, local_episodes.Removable, local_episodes.StopTime, local_episodes.AudioTracks, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID) where online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.CompositeID2 != '') union select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, online_episodes.lastupdated, online_episodes.DownloadPending, online_episodes.DownloadExpectedName, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.AvailableSubtitles, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.ext, local_episodes.Removable, local_episodes.StopTime, local_episodes.AudioTracks, local_episodes.TextCount from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID) where local_episodes.CompositeID2 != '' order by online_episodesEpisodeIndex asc ). [/CODE] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
My TVSeries
Big problems with MyTV-series! (Database gone and won't readd!)
Contact us
RSS
Top
Bottom