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
Guide not updating
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: 1183290" data-attributes="member: 82144"><p>Hi</p><p></p><p>First, please don't double-post. It comes across as nagging. If you want a thread or post moved, just ask - we can do it easily. Sometimes it takes more than 24 hours to get an answer, as those of us who often answer have lives outside of MediaPortal. Your patience would be appreciated. I've deleted your other thread that was here:</p><p><a href="https://forum.team-mediaportal.com/threads/guide-isnt-updating.134285/" target="_blank">https://forum.team-mediaportal.com/threads/guide-isnt-updating.134285/</a></p><p></p><p>To the issue...</p><p>You seem to have database access problems. From the log file:</p><p>[2016-05-01 20:52:51,956] [Log ] [TVService] [INFO ] - TV Service: Plugin: <strong>SchedulesDirect EPG Client failed to start</strong></p><p>[2016-05-01 20:52:51,971] [Log ] [TVService] [ERROR] - Exception :Error: StatementErrorUnclassified</p><p>Gentle.Common.GentleException: select idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating from Program order by endTime desc limit 1 offset 0; ---> MySql.Data.MySqlClient.MySqlException: Timeout expired. <strong>The timeout period elapsed prior to completion of the operation or the server is not responding.</strong></p><p>[collapse] at MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)</p><p> at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()</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 Gentle.Framework.SqlStatement.Execute()</p><p> at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.GetLastProgramEntry()</p><p> at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.TvEngine.ITvServerPlugin.Start(IController controller)</p><p> at TvService.TvServiceThread.StartPlugins()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.ExecuteDbDataReader(CommandBehavior behavior)</p><p> at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()</p><p> at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)[/collapse]</p><p></p><p>...and from the Windows application event log at the same time:</p><p>"01/05/2016 8:52:51 PM";"MySQL";"(0)";"Information";"Sort aborted, host: btvserv1, user: root, thread: 166, error: Query execution was interrupted, query: select idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating from Program order by endTime desc limit 1 offset 0For more information, see Help and Support Center at <a href="http://www.mysql.com" target="_blank">http://www.mysql.com</a>. ";"3221225572"</p><p></p><p>Some other curiosities noticed in the Windows application event log:</p><p>[collapse]"01/05/2016 8:50:23 PM";"MySQL";"(0)";"Error";"Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'For more information, see Help and Support Center at <a href="http://www.mysql.com" target="_blank">http://www.mysql.com</a>. ";"3221225572"</p><p>...</p><p>"02/05/2016 4:51:36 AM";"MySQL";"(0)";"Information";"Aborted connection 3 to db: 'mptvdb' user: 'root' host: 'btvserv1' (Got timeout reading communication packets)For more information, see Help and Support Center at <a href="http://www.mysql.com" target="_blank">http://www.mysql.com</a>. ";"3221225572"</p><p>"02/05/2016 4:53:09 AM";"MySQL";"(0)";"Information";"Aborted connection 232 to db: 'mptvdb' user: 'root' host: 'btvserv1' (Got timeout reading communication packets)For more information, see Help and Support Center at <a href="http://www.mysql.com" target="_blank">http://www.mysql.com</a>. ";"3221225572"[/collapse]</p><p></p><p></p><p>Sorry I'm not much good with database issues like this. All I can really do is point out the things that stand out to me. I can see that the "keyring_file" and "aborted connection" messages in the Windows application event log seem to have started after you upgraded MySQL from the version we supply with our installer (5.6.10) to 5.7.11 on 31 March, so if this guide updating issue only started in the last week then perhaps you can ignore them.</p><p></p><p>The final and most important thing I note is that there was an unexpected shutdown on 29 April:</p><p>"29/04/2016 12:00:51 AM";"EventLog";"(0)";"Error";"The previous system shutdown at 11:58:51 PM on 28/04/2016 was unexpected.";"2147489656"</p><p></p><p>As you probably remember, file corruption caused by an unexpected shutdown was the cause of the problems in <a href="https://forum.team-mediaportal.com/threads/mp-client-cant-find-the-server.134038/" target="_blank">your support request at the end of march</a>. The latest unexpected shutdown is probably the cause of this guide update issue too. I strongly advise you to figure out and eliminate whatever's causing these unexpected shutdowns. If it's your habit to hard-reset the PC when you run into trouble, I'd advise to try to break the habit and find a better solution that isn't going to give you these nasty after-effects.</p></blockquote><p></p>
[QUOTE="mm1352000, post: 1183290, member: 82144"] Hi First, please don't double-post. It comes across as nagging. If you want a thread or post moved, just ask - we can do it easily. Sometimes it takes more than 24 hours to get an answer, as those of us who often answer have lives outside of MediaPortal. Your patience would be appreciated. I've deleted your other thread that was here: [URL]https://forum.team-mediaportal.com/threads/guide-isnt-updating.134285/[/URL] To the issue... You seem to have database access problems. From the log file: [2016-05-01 20:52:51,956] [Log ] [TVService] [INFO ] - TV Service: Plugin: [B]SchedulesDirect EPG Client failed to start[/B] [2016-05-01 20:52:51,971] [Log ] [TVService] [ERROR] - Exception :Error: StatementErrorUnclassified Gentle.Common.GentleException: select idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating from Program order by endTime desc limit 1 offset 0; ---> MySql.Data.MySqlClient.MySqlException: Timeout expired. [B]The timeout period elapsed prior to completion of the operation or the server is not responding.[/B] [collapse] at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() 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 Gentle.Framework.SqlStatement.Execute() at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.GetLastProgramEntry() at SchedulesDirect.Plugin.SchedulesDirectPluginTVE3.TvEngine.ITvServerPlugin.Start(IController controller) at TvService.TvServiceThread.StartPlugins()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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)[/collapse] ...and from the Windows application event log at the same time: "01/05/2016 8:52:51 PM";"MySQL";"(0)";"Information";"Sort aborted, host: btvserv1, user: root, thread: 166, error: Query execution was interrupted, query: select idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating from Program order by endTime desc limit 1 offset 0For more information, see Help and Support Center at [URL]http://www.mysql.com[/URL]. ";"3221225572" Some other curiosities noticed in the Windows application event log: [collapse]"01/05/2016 8:50:23 PM";"MySQL";"(0)";"Error";"Plugin keyring_file reported: 'keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided'For more information, see Help and Support Center at [URL]http://www.mysql.com[/URL]. ";"3221225572" ... "02/05/2016 4:51:36 AM";"MySQL";"(0)";"Information";"Aborted connection 3 to db: 'mptvdb' user: 'root' host: 'btvserv1' (Got timeout reading communication packets)For more information, see Help and Support Center at [URL]http://www.mysql.com[/URL]. ";"3221225572" "02/05/2016 4:53:09 AM";"MySQL";"(0)";"Information";"Aborted connection 232 to db: 'mptvdb' user: 'root' host: 'btvserv1' (Got timeout reading communication packets)For more information, see Help and Support Center at [URL]http://www.mysql.com[/URL]. ";"3221225572"[/collapse] Sorry I'm not much good with database issues like this. All I can really do is point out the things that stand out to me. I can see that the "keyring_file" and "aborted connection" messages in the Windows application event log seem to have started after you upgraded MySQL from the version we supply with our installer (5.6.10) to 5.7.11 on 31 March, so if this guide updating issue only started in the last week then perhaps you can ignore them. The final and most important thing I note is that there was an unexpected shutdown on 29 April: "29/04/2016 12:00:51 AM";"EventLog";"(0)";"Error";"The previous system shutdown at 11:58:51 PM on 28/04/2016 was unexpected.";"2147489656" As you probably remember, file corruption caused by an unexpected shutdown was the cause of the problems in [URL='https://forum.team-mediaportal.com/threads/mp-client-cant-find-the-server.134038/']your support request at the end of march[/URL]. The latest unexpected shutdown is probably the cause of this guide update issue too. I strongly advise you to figure out and eliminate whatever's causing these unexpected shutdowns. If it's your habit to hard-reset the PC when you run into trouble, I'd advise to try to break the habit and find a better solution that isn't going to give you these nasty after-effects. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
Guide not updating
Contact us
RSS
Top
Bottom
