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 Talk
Can't get program guide to update
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="mm1352000" data-source="post: 1157540" data-attributes="member: 82144"><p>Hello again Patrick</p><p></p><p>I hope you're well. <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>Your log files (thanks for those <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite24" alt="(y)" title="Thumbs Up (y)" loading="lazy" data-shortname="(y)" /> ) are telling me that you're using the SchedulesDirect plugin to get your guide data.</p><p>The latest log file shows the SD plugin attempting to update the guide data:</p><p>[2015-10-23 15:52:18,704] [Log ] [SchedulesDirect EPG Client] [INFO ] - Starting EPG refresh job on thread #5</p><p>[2015-10-23 15:52:18,704] [Log ] [SchedulesDirect EPG Client] [INFO ] - UTC time is 23/10/2015 7:52:18 PM, local time is 23/10/2015 3:52:18 PM (DST is True)</p><p></p><p>However, it runs into a database access problem when trying to clear out all the old data:</p><p>[collapse]</p><p>[2015-10-23 15:53:16,080] [Log ] [SchedulesDirect EPG Client] [INFO ] - Error: StatementErrorUnclassified</p><p>Gentle.Common.GentleException: delete from Program where endTime < '2015-10-22 15:52:18'; ---> MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</p><p> at MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()</p><p> at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p> --- End of inner exception stack trace ---</p><p> at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p> at Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)</p><p> at TvDatabase.TvBusinessLayer.RemoveOldPrograms()</p><p> at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.PrepareForEpgImport()</p><p> at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.RefreshEPG(Object state)MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</p><p> at MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()</p><p> at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p>[2015-10-23 15:53:16,611] [Log ] [SchedulesDirect EPG Client] [INFO ] - Scheduling next poll for 24/10/2015 1:12:24 PM</p><p>[2015-10-23 15:53:16,704] [Log ] [SchedulesDirect EPG Client] [INFO ] - Unable to process any channels, have you done an autotune in setup?[/collapse]</p><p></p><p>In other words, your attempts to force an update are being blocked by this error.</p><p></p><p>Please can you try the following and see if it helps:</p><ol> <li data-xf-list-type="ol">Open TV Server configuration.</li> <li data-xf-list-type="ol">Navigate to the "manual control" section.</li> <li data-xf-list-type="ol">Click "refresh DVB EPG".</li> </ol><p>Note: I know you're not using DVB tuners or EPG, however this should have the effect of deleting all existing guide data... and that in turn should hopefully clear the way for the SD plugin to update successfully.</p><p></p><p>If this doesn't help, please can you post fresh log files so I can see what happened.</p><p></p><p>Regards,</p><p>mm</p><p><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p></blockquote><p></p>
[QUOTE="mm1352000, post: 1157540, member: 82144"] Hello again Patrick I hope you're well. :) Your log files (thanks for those (y) ) are telling me that you're using the SchedulesDirect plugin to get your guide data. The latest log file shows the SD plugin attempting to update the guide data: [2015-10-23 15:52:18,704] [Log ] [SchedulesDirect EPG Client] [INFO ] - Starting EPG refresh job on thread #5 [2015-10-23 15:52:18,704] [Log ] [SchedulesDirect EPG Client] [INFO ] - UTC time is 23/10/2015 7:52:18 PM, local time is 23/10/2015 3:52:18 PM (DST is True) However, it runs into a database access problem when trying to clear out all the old data: [collapse] [2015-10-23 15:53:16,080] [Log ] [SchedulesDirect EPG Client] [INFO ] - Error: StatementErrorUnclassified Gentle.Common.GentleException: delete from Program where endTime < '2015-10-22 15:52:18'; ---> MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr) --- End of inner exception stack trace --- at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr) at Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction) at TvDatabase.TvBusinessLayer.RemoveOldPrograms() at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.PrepareForEpgImport() at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.RefreshEPG(Object state)MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr) [2015-10-23 15:53:16,611] [Log ] [SchedulesDirect EPG Client] [INFO ] - Scheduling next poll for 24/10/2015 1:12:24 PM [2015-10-23 15:53:16,704] [Log ] [SchedulesDirect EPG Client] [INFO ] - Unable to process any channels, have you done an autotune in setup?[/collapse] In other words, your attempts to force an update are being blocked by this error. Please can you try the following and see if it helps: [LIST=1] [*]Open TV Server configuration. [*]Navigate to the "manual control" section. [*]Click "refresh DVB EPG". [/LIST] Note: I know you're not using DVB tuners or EPG, however this should have the effect of deleting all existing guide data... and that in turn should hopefully clear the way for the SD plugin to update successfully. If this doesn't help, please can you post fresh log files so I can see what happened. Regards, mm :) [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Talk
Can't get program guide to update
Contact us
RSS
Top
Bottom