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
Stab le to Crash Overnivght
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="JimCatMP" data-source="post: 973151" data-attributes="member: 103549"><p>Hi</p><p> </p><p>Looks like Online videos problem in database.</p><p> </p><p><em>MediaPortal log</em></p><p> </p><p><em>2013-03-08 22:45:38.465709 [Info.][(12)]: SQLiteClient: cmd:sqlite3_step err:ERROR detailed<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused :confused:" loading="lazy" data-shortname=":confused:" />QL logic error or missing database query:</em></p><p><em>update online_series SET HasLocalFiles = HasLocalFiles_Temp</em></p><p><em>2013-03-08 22:45:41.643891 [Info.][(12)]: SQLiteClient: Closing database: </em></p><p><em>2013-03-08 22:45:41.677893 [Info.][(12)]: SQLiteClient: cmd:sqlite3_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue :p" loading="lazy" data-shortname=":p" />vm=null err:</em></p><p><em>NOMEM detailed<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite9" alt=":eek:" title="Eek! :eek:" loading="lazy" data-shortname=":eek:" />ut of memory query:select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, </em></p><p><em>online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, </em></p><p><em>online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, </em></p><p><em>online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, </em></p><p><em>online_episodes.lastupdated, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.follwit_id, </em></p><p><em>online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, </em></p><p><em>online_episodes.DVD_discid, </em></p><p><em>online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, </em></p><p><em>online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.RatingCount, </em></p><p><em>online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, </em></p><p><em>online_episodes.airsbefore_season, online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.OriginalComposite, </em></p><p><em>local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, </em></p><p><em>local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.CompositeUpdated, </em></p><p><em>local_episodes.AvailableSubtitles, local_episodes.OriginalComposite2, local_episodes.CompositeID2, </em></p><p><em>local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded, </em></p><p><em>local_episodes.FileDateCreated, local_episodes.IsAvailable, local_episodes.DateWatched, local_episodes.ext, </em></p><p><em>local_episodes.VolumeLabel, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoFormat, </em></p><p><em>local_episodes.VideoFormatProfile, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, </em></p><p><em>local_episodes.AudioCodec, local_episodes.AudioFormat, local_episodes.AudioFormatProfile, local_episodes.AudioBitrate, </em></p><p><em>local_episodes.AudioChannels, local_episodes.AudioTracks, local_episodes.TextCount, local_episodes.StopTime from online_episodes </em></p><p><em>left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID) </em></p><p><em><span style="color: #ff0000">where local_episodes.EpisodeFilename != '' and local_episodes.videoWidth = 0 and local_episodes.localPlaytime > '-5' </span></em></p><p><em>and online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes </em></p><p><em>where local_episodes.CompositeID2 != '') union select online_episodes.CompositeID, online_episodes.EpisodeID, </em></p><p><em>online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, </em></p><p><em>online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, </em></p><p><em>online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, </em></p><p><em>online_episodes.Hidden, online_episodes.lastupdated, online_episodes.ThumbUrl, online_episodes.thumbFilename, </em></p><p><em>online_episodes.follwit_id, online_episodes.Combined_episodenumber, online_episodes.Combined_season, </em></p><p><em>online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, </em></p><p><em>online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, </em></p><p><em>online_episodes.ProductionCode, online_episodes.Rating, online_episodes.RatingCount, </em></p><p><em>online_episodes.absolute_number, </em></p><p><em>online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, </em></p><p><em>online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.OriginalComposite, local_episodes.CompositeID,</em></p><p><em>local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, </em></p><p><em>local_episodes.LocalImportProcessed, local_episodes.CompositeUpdated, local_episodes.AvailableSubtitles, </em></p><p><em>local_episodes.OriginalComposite2, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, </em></p><p><em>local_episodes.videoHeight, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.IsAvailable, </em></p><p><em>local_episodes.DateWatched, local_episodes.ext, local_episodes.VolumeLabel, local_episodes.localPlaytime, </em></p><p><em>local_episodes.VideoCodec, local_episodes.VideoFormat, local_episodes.VideoFormatProfile, local_episodes.VideoBitrate, </em></p><p><em>local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioFormat, </em></p><p><em>local_episodes.AudioFormatProfile, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.AudioTracks, </em></p><p><em>local_episodes.TextCount, local_episodes.StopTime from online_episodes </em></p><p><em>left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID) </em></p><p><em>where local_episodes.EpisodeFilename != '' </em></p><p><em>and local_episodes.videoWidth = 0 and local_episodes.localPlaytime > '-5' and local_episodes.CompositeID2 != '' </em></p><p><em>order by online_episodesEpisodeIndex asc 2</em></p><p> </p><p><em>OnLine Plugin</em></p><p> </p><p><em>[03-08 22:37:03,658] [OVInit ] [INFO ] Using language 'en'</em></p><p><em>[03-08 22:37:04,548] [OVInit ] [INFO ] Thumbnails will be stored in C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\OnlineVideos\ with a maximum age of 100 days.</em></p><p><em>[03-08 22:37:07,653] [OVInit ] [INFO ] Loaded 125 sites from OnlineVideoSites.xml</em></p><p><em>[03-08 22:37:17,881] [OVInit ] [WARN ] SiteUtil with name: MyVideoSerien not found!</em></p><p><em>[03-08 22:37:18,548] [OVInit ] [WARN ] HardwareInfo - could not set Configuration Value: nextPageRegExUrlDecoding. Error: Requested value 'true' was not found.</em></p><p><em>[03-08 22:37:18,568] [OVInit ] [WARN ] SiteUtil with name: LuckyTV not found!</em></p><p><em>[03-08 22:37:19,329] [OVInit ] [INFO ] Created 121 SiteUtils</em></p><p><em>[03-08 22:37:20,976] [OVLatest ] [INFO ] LatestVideosManager getting new data from SiteUtils.</em></p><p> </p><p> </p><p>I've split the line to make it readable, looks a horrendously complex and possibly slightly bizzare (but I don't know plugin or it's DB, so that's an observation, not a fact<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p><p> </p><p>Suggest you disable online vidoes and see where that takes you - hopfully, basic service back.</p><p> </p><p>If so, how you fix the DB, hopefully someone else will chip in once clear it's the source of the problem.</p><p> </p><p>Cheers - JCMP</p></blockquote><p></p>
[QUOTE="JimCatMP, post: 973151, member: 103549"] Hi Looks like Online videos problem in database. [I]MediaPortal log[/I] [I]2013-03-08 22:45:38.465709 [Info.][(12)]: SQLiteClient: cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:[/I] [I]update online_series SET HasLocalFiles = HasLocalFiles_Temp[/I] [I]2013-03-08 22:45:41.643891 [Info.][(12)]: SQLiteClient: Closing database: [/I] [I]2013-03-08 22:45:41.677893 [Info.][(12)]: SQLiteClient: cmd:sqlite3_prepare16:pvm=null err:[/I] [I]NOMEM detailed:out of memory query:select online_episodes.CompositeID, online_episodes.EpisodeID, online_episodes.SeriesID, [/I] [I]online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, online_episodes.EpisodeName, [/I] [I]online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, online_episodes.OnlineDataImported, [/I] [I]online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, online_episodes.Hidden, [/I] [I]online_episodes.lastupdated, online_episodes.ThumbUrl, online_episodes.thumbFilename, online_episodes.follwit_id, [/I] [I]online_episodes.Combined_episodenumber, online_episodes.Combined_season, online_episodes.DVD_chapter, [/I] [I]online_episodes.DVD_discid, [/I] [I]online_episodes.DVD_episodenumber, online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, [/I] [I]online_episodes.Language, online_episodes.ProductionCode, online_episodes.Rating, online_episodes.RatingCount, [/I] [I]online_episodes.absolute_number, online_episodes.airsafter_season, online_episodes.airsbefore_episode, [/I] [I]online_episodes.airsbefore_season, online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.OriginalComposite, [/I] [I]local_episodes.CompositeID, local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, [/I] [I]local_episodes.LocalEpisodeName, local_episodes.LocalImportProcessed, local_episodes.CompositeUpdated, [/I] [I]local_episodes.AvailableSubtitles, local_episodes.OriginalComposite2, local_episodes.CompositeID2, [/I] [I]local_episodes.EpisodeIndex2, local_episodes.videoWidth, local_episodes.videoHeight, local_episodes.FileDateAdded, [/I] [I]local_episodes.FileDateCreated, local_episodes.IsAvailable, local_episodes.DateWatched, local_episodes.ext, [/I] [I]local_episodes.VolumeLabel, local_episodes.localPlaytime, local_episodes.VideoCodec, local_episodes.VideoFormat, [/I] [I]local_episodes.VideoFormatProfile, local_episodes.VideoBitrate, local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, [/I] [I]local_episodes.AudioCodec, local_episodes.AudioFormat, local_episodes.AudioFormatProfile, local_episodes.AudioBitrate, [/I] [I]local_episodes.AudioChannels, local_episodes.AudioTracks, local_episodes.TextCount, local_episodes.StopTime from online_episodes [/I] [I]left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID) [/I] [I][COLOR=#ff0000]where local_episodes.EpisodeFilename != '' and local_episodes.videoWidth = 0 and local_episodes.localPlaytime > '-5' [/COLOR][/I] [I]and online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes [/I] [I]where local_episodes.CompositeID2 != '') union select online_episodes.CompositeID, online_episodes.EpisodeID, [/I] [I]online_episodes.SeriesID, online_episodes.EpisodeIndex as online_episodesEpisodeIndex , online_episodes.SeasonIndex, [/I] [I]online_episodes.EpisodeName, online_episodes.Watched, online_episodes.Summary, online_episodes.FirstAired, [/I] [I]online_episodes.OnlineDataImported, online_episodes.GuestStars, online_episodes.Director, online_episodes.Writer, [/I] [I]online_episodes.Hidden, online_episodes.lastupdated, online_episodes.ThumbUrl, online_episodes.thumbFilename, [/I] [I]online_episodes.follwit_id, online_episodes.Combined_episodenumber, online_episodes.Combined_season, [/I] [I]online_episodes.DVD_chapter, online_episodes.DVD_discid, online_episodes.DVD_episodenumber, [/I] [I]online_episodes.DVD_season, online_episodes.EpImgFlag, online_episodes.IMDB_ID, online_episodes.Language, [/I] [I]online_episodes.ProductionCode, online_episodes.Rating, online_episodes.RatingCount, [/I] [I]online_episodes.absolute_number, [/I] [I]online_episodes.airsafter_season, online_episodes.airsbefore_episode, online_episodes.airsbefore_season, [/I] [I]online_episodes.seasonid, local_episodes.EpisodeFilename, local_episodes.OriginalComposite, local_episodes.CompositeID,[/I] [I]local_episodes.SeriesID, local_episodes.SeasonIndex, local_episodes.EpisodeIndex, local_episodes.LocalEpisodeName, [/I] [I]local_episodes.LocalImportProcessed, local_episodes.CompositeUpdated, local_episodes.AvailableSubtitles, [/I] [I]local_episodes.OriginalComposite2, local_episodes.CompositeID2, local_episodes.EpisodeIndex2, local_episodes.videoWidth, [/I] [I]local_episodes.videoHeight, local_episodes.FileDateAdded, local_episodes.FileDateCreated, local_episodes.IsAvailable, [/I] [I]local_episodes.DateWatched, local_episodes.ext, local_episodes.VolumeLabel, local_episodes.localPlaytime, [/I] [I]local_episodes.VideoCodec, local_episodes.VideoFormat, local_episodes.VideoFormatProfile, local_episodes.VideoBitrate, [/I] [I]local_episodes.VideoFrameRate, local_episodes.VideoAspectRatio, local_episodes.AudioCodec, local_episodes.AudioFormat, [/I] [I]local_episodes.AudioFormatProfile, local_episodes.AudioBitrate, local_episodes.AudioChannels, local_episodes.AudioTracks, [/I] [I]local_episodes.TextCount, local_episodes.StopTime from online_episodes [/I] [I]left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID) [/I] [I]where local_episodes.EpisodeFilename != '' [/I] [I]and local_episodes.videoWidth = 0 and local_episodes.localPlaytime > '-5' and local_episodes.CompositeID2 != '' [/I] [I]order by online_episodesEpisodeIndex asc 2[/I] [I]OnLine Plugin[/I] [I][03-08 22:37:03,658] [OVInit ] [INFO ] Using language 'en'[/I] [I][03-08 22:37:04,548] [OVInit ] [INFO ] Thumbnails will be stored in C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\OnlineVideos\ with a maximum age of 100 days.[/I] [I][03-08 22:37:07,653] [OVInit ] [INFO ] Loaded 125 sites from OnlineVideoSites.xml[/I] [I][03-08 22:37:17,881] [OVInit ] [WARN ] SiteUtil with name: MyVideoSerien not found![/I] [I][03-08 22:37:18,548] [OVInit ] [WARN ] HardwareInfo - could not set Configuration Value: nextPageRegExUrlDecoding. Error: Requested value 'true' was not found.[/I] [I][03-08 22:37:18,568] [OVInit ] [WARN ] SiteUtil with name: LuckyTV not found![/I] [I][03-08 22:37:19,329] [OVInit ] [INFO ] Created 121 SiteUtils[/I] [I][03-08 22:37:20,976] [OVLatest ] [INFO ] LatestVideosManager getting new data from SiteUtils.[/I] I've split the line to make it readable, looks a horrendously complex and possibly slightly bizzare (but I don't know plugin or it's DB, so that's an observation, not a fact:-) Suggest you disable online vidoes and see where that takes you - hopfully, basic service back. If so, how you fix the DB, hopefully someone else will chip in once clear it's the source of the problem. Cheers - JCMP [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
Stab le to Crash Overnivght
Contact us
RSS
Top
Bottom
