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
General Forums
Newcomers Forum
Schedules Direct
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="STEVENJ" data-source="post: 852803" data-attributes="member: 97739"><p>I had an extended e-mail conversation with Geoff regarding getting this SchedulesDirect plug-in to work with Media Portal. I'm still having problems with this. However it may be helpful for others to see this conversation:</p><p> </p><p>On Mar 17, 2012 4:04 PM, "njsteve" wrote:</p><p> </p><p>I've now got Schedules Direct installed but there's no</p><p>data for any of the channels. Further, the channels appear in no</p><p>discernable order (neither numerical or alphabetical). I'm in the U.S.</p><p>(Philadelphia market) and a Schedules Direct subscriber.</p><p> </p><p>On March 17, 2012 4:21 PM Geoff Stewart wrote:</p><p> </p><p>do you have the plunging enabled?</p><p>if its enabled, do you have it setup to create channels for you?</p><p>when you start mediaportal, the log has some info to help figure out what's happening</p><p>takes a while to download data</p><p>as for the order.... in the mediaportal client config, there is a checkbox about order...play with that.. it defaults to some weird order</p><p>good luck</p><p> </p><p>On Mar 17, 2012 5:10 PM, "Steven Apel" wrote:</p><p style="margin-left: 20px"><span style="font-family: 'Arial'">Dear Geoff:</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-family: 'Arial'">Thanks for replying to me so quickly.</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-family: 'Arial'">I've managed to get the channel order sorted out. Also have gotten the channels re-labeled for their appearance in the TV Guide. However, I still don't have updated program listings. You mention "plunging" but I have no idea what you're talking about. Usually if I don't know the software intimately I can hack my way around it and learn. But for this I'm stumped. Can you outline the steps that I need to take to get guide data?</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-family: 'Arial'">Steve</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">On Saturday, March 17, 2012 6:49 PM Geoff Stewart wrote:</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">plunging is auto correct on my phone <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink ;)" loading="lazy" data-shortname=";)" /> meant plugin ...</p> <p style="margin-left: 20px">start mediaportal server</p> <p style="margin-left: 20px">take a look at tv.log</p> <p style="margin-left: 20px">it will give you some insight...</p> <p style="margin-left: 20px">send me a copy if you like</p> <p style="margin-left: 20px">g</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">On Mar 18, 2012 3:27 PM, "Steven Apel" wrote:</p><p style="margin-left: 20px"><span style="font-family: 'Arial'">Dear Geoff:</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-family: 'Arial'">The problem appears to be that the schedule never updates. In Schedule Direct under advanced options, even though I check the box for "force guide update on TV service startup", the checkmark keeps getting dropped. Consequently, the guide never updates. Have you any idea how to fix this?</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-family: 'Arial'">Steve</span></p> <p style="margin-left: 20px">On Sunday, March 18, 2012 3:43 PM Geoff Stewart wrote:</p> <p style="margin-left: 20px">the checkbox only lasts one restart and then it gets cleared by the plugin</p> <p style="margin-left: 20px">i can't help without the log... tv.log</p> <p style="margin-left: 20px">g</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">On Mar 18, 2012 4:15 PM, "Steven Apel"wrote:</p><p style="margin-left: 20px"><span style="font-family: 'Arial'">Where do I find the log to send you?</span></p> </p></p> <p style="margin-left: 20px">On Sunday, March 18, 2012 4:21 PM Geoff Stewart wrote:</p> <p style="margin-left: 20px">at the top left of the server config tool is a button that says log files or something like that.... send the newest tv.log file.....</p> <p style="margin-left: 20px">On Sunday, March 18, 2012 6:43 PM Geoff Stewart wrote:</p> <p style="margin-left: 20px">Hey Steve,</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">Looks in the log like the TV server cannot connect to your database.... do you have it configured for MySQL or SqlServer?</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">Is the database running?</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">Here's the log message I mean:</p> <p style="margin-left: 20px">2012-03-18 15:18:27.909528 [MPMain(1)]: BusinessLayer: GetProgramsForAllChannels caused an Exception - Table '.\mptvdb\program' is marked as crashed and should be repaired, at MySql.Data.MySqlClient.MySqlStream.OpenPacket()</p> <p style="margin-left: 20px"> at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)</p> <p style="margin-left: 20px"> at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()</p> <p style="margin-left: 20px"> at MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p> <p style="margin-left: 20px"> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p> <p style="margin-left: 20px"> at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)</p> <p style="margin-left: 20px"> at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)</p> <p style="margin-left: 20px"> at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)</p> <p style="margin-left: 20px"> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)</p> <p style="margin-left: 20px"> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)</p> <p style="margin-left: 20px"> at TvDatabase.TvBusinessLayer.GetProgramsForAllChannels(DateTime startTime, DateTime endTime, List`1 channelList)</p> <p style="margin-left: 20px">2012-03-18 15:18:27.915528 [MPMain(1)]: RemoteControl - Connected</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">Forget the marked as crashed.... it's the openpacket() call failing that means that it cannot connect to your database....</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">Oh, I guess it thinks it's MySQL by the log as I look at it again...</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">g</p> <p style="margin-left: 20px">On 19 March 2012 09:31, Steven Apelwrote:</p><p style="margin-left: 20px"><span style="font-family: 'Arial'">Geoff:</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-family: 'Arial'">Thanks for looking over the log.</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-family: 'Arial'">I don't know the answers to either of your questions. Perhaps you can guide me through doing whatever is needed to get this working.</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-family: 'Arial'">Steve</span></p> <p style="margin-left: 20px"><strong>On</strong> Monday, March 19, 2012 10:10 AM Geoff Stewart wrote:</p> <p style="margin-left: 20px">Sure thing.</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">The MP tv server needs a database. Looks like you are using MySQL database. Can you confirm that MySQL is running?</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">If you don't see mysql installed, then that's a problem <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">First, just try and confirm that you have a database installed.</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">If it's installed, then right-click on my computer->Manage->Services</p> <p style="margin-left: 20px">Look for MySQL service and confirm that it is running.</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">If that's good, then launch the MySQL client software that should have been installed when MP installed mysql</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">To do so, you probably just need to look in your start menu for a MySQL folder (MySQL Server 5.1) or something like that.... the default setup when you install MediaPortal is to install MySQL with the user name: root with password MediaPortal (case-sensitive)</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">Launch the command-line client... it will prompt you just for a password (assumes a user root)... enter MediaPortal</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">If you can connect, then you have MySQL running... good.</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">Now, we need to confirm that the mediaportal database is installed.</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">type the following in the command-line client:</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">connect mptvdb</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">If it says connection id: <something> with current database: mptvdb, then it worked... otherwise it did not.</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">Let me know how it goes.</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">Cheers.</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">Geoff</p> <p style="margin-left: 20px">On 19 March 2012 10:42, Steven Apel wrote:</p> <p style="margin-left: 20px"></p><p style="margin-left: 20px"><span style="font-family: 'Arial'">Geoff:</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-family: 'Arial'">Okay, I've confirmed I have MySQL installed and running. I also have a MySQL Server 5.1 folder. Now comes the roadblock. I can not find a "command-line" client in this folder. Going to the DOS command line (which I don't think you mean) gives me only an un-prompted space in which to type. So you see, I can't get beyond this point.</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-family: 'Arial'">Is something really fouled up on this new computer (which runs Windows 7) or am I missing the bloody obvious?</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-family: 'Arial'">Steve</span></p> <p style="margin-left: 20px">On 19 March 2012 10:44, Geoff Stewartwrote:</p> <p style="margin-left: 20px"></p><p style="margin-left: 20px">The command line client is in the start menu.... start->MySQL Server 5.1->command-line client (or something to that effect)</p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">see if you can see it there.<span style="color: #888888"></span></p> <p style="margin-left: 20px"><span style="color: #888888"></span></p> <p style="margin-left: 20px"><span style="color: #888888">g</span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px">On 19 March 2012 12:18, Steven Apel wrote:</p> <p style="margin-left: 20px"><span style="font-size: 10px"><span style="font-family: 'Arial'">Geoff:</span></span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"><span style="font-size: 10px"><span style="font-family: 'Arial'">I've done what you've said. I've also waited some time and still no new schedule data. Do I need to do all things in my SQL workbench as described in the forum in order to make this work or is there something else that I'm missing?</span></span></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"></p> </p></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"></p> <p style="margin-left: 20px"></p> </p></blockquote><p></p>
[QUOTE="STEVENJ, post: 852803, member: 97739"] I had an extended e-mail conversation with Geoff regarding getting this SchedulesDirect plug-in to work with Media Portal. I'm still having problems with this. However it may be helpful for others to see this conversation: On Mar 17, 2012 4:04 PM, "njsteve" wrote: I've now got Schedules Direct installed but there's no data for any of the channels. Further, the channels appear in no discernable order (neither numerical or alphabetical). I'm in the U.S. (Philadelphia market) and a Schedules Direct subscriber. On March 17, 2012 4:21 PM Geoff Stewart wrote: do you have the plunging enabled? if its enabled, do you have it setup to create channels for you? when you start mediaportal, the log has some info to help figure out what's happening takes a while to download data as for the order.... in the mediaportal client config, there is a checkbox about order...play with that.. it defaults to some weird order good luck On Mar 17, 2012 5:10 PM, "Steven Apel" wrote: [INDENT][FONT=Arial]Dear Geoff:[/FONT] [FONT=Arial]Thanks for replying to me so quickly.[/FONT] [FONT=Arial]I've managed to get the channel order sorted out. Also have gotten the channels re-labeled for their appearance in the TV Guide. However, I still don't have updated program listings. You mention "plunging" but I have no idea what you're talking about. Usually if I don't know the software intimately I can hack my way around it and learn. But for this I'm stumped. Can you outline the steps that I need to take to get guide data?[/FONT] [FONT=Arial]Steve[/FONT] [FONT=Arial][/FONT] On Saturday, March 17, 2012 6:49 PM Geoff Stewart wrote: plunging is auto correct on my phone ;) meant plugin ... start mediaportal server take a look at tv.log it will give you some insight... send me a copy if you like g On Mar 18, 2012 3:27 PM, "Steven Apel" wrote: [INDENT][FONT=Arial]Dear Geoff:[/FONT] [FONT=Arial]The problem appears to be that the schedule never updates. In Schedule Direct under advanced options, even though I check the box for "force guide update on TV service startup", the checkmark keeps getting dropped. Consequently, the guide never updates. Have you any idea how to fix this?[/FONT] [FONT=Arial]Steve[/FONT] On Sunday, March 18, 2012 3:43 PM Geoff Stewart wrote: the checkbox only lasts one restart and then it gets cleared by the plugin i can't help without the log... tv.log g On Mar 18, 2012 4:15 PM, "Steven Apel"wrote: [INDENT][FONT=Arial]Where do I find the log to send you?[/FONT][/INDENT][/INDENT] On Sunday, March 18, 2012 4:21 PM Geoff Stewart wrote: at the top left of the server config tool is a button that says log files or something like that.... send the newest tv.log file..... On Sunday, March 18, 2012 6:43 PM Geoff Stewart wrote: Hey Steve, Looks in the log like the TV server cannot connect to your database.... do you have it configured for MySQL or SqlServer? Is the database running? Here's the log message I mean: 2012-03-18 15:18:27.909528 [MPMain(1)]: BusinessLayer: GetProgramsForAllChannels caused an Exception - Table '.\mptvdb\program' is marked as crashed and should be repaired, at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() 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(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at TvDatabase.TvBusinessLayer.GetProgramsForAllChannels(DateTime startTime, DateTime endTime, List`1 channelList) 2012-03-18 15:18:27.915528 [MPMain(1)]: RemoteControl - Connected Forget the marked as crashed.... it's the openpacket() call failing that means that it cannot connect to your database.... Oh, I guess it thinks it's MySQL by the log as I look at it again... g On 19 March 2012 09:31, Steven Apelwrote: [INDENT][FONT=Arial]Geoff:[/FONT] [FONT=Arial]Thanks for looking over the log.[/FONT] [FONT=Arial]I don't know the answers to either of your questions. Perhaps you can guide me through doing whatever is needed to get this working.[/FONT] [FONT=Arial]Steve[/FONT] [B]On[/B] Monday, March 19, 2012 10:10 AM Geoff Stewart wrote: Sure thing. The MP tv server needs a database. Looks like you are using MySQL database. Can you confirm that MySQL is running? If you don't see mysql installed, then that's a problem :) First, just try and confirm that you have a database installed. If it's installed, then right-click on my computer->Manage->Services Look for MySQL service and confirm that it is running. If that's good, then launch the MySQL client software that should have been installed when MP installed mysql To do so, you probably just need to look in your start menu for a MySQL folder (MySQL Server 5.1) or something like that.... the default setup when you install MediaPortal is to install MySQL with the user name: root with password MediaPortal (case-sensitive) Launch the command-line client... it will prompt you just for a password (assumes a user root)... enter MediaPortal If you can connect, then you have MySQL running... good. Now, we need to confirm that the mediaportal database is installed. type the following in the command-line client: connect mptvdb If it says connection id: <something> with current database: mptvdb, then it worked... otherwise it did not. Let me know how it goes. Cheers. Geoff On 19 March 2012 10:42, Steven Apel wrote: [INDENT][FONT=Arial]Geoff:[/FONT] [FONT=Arial]Okay, I've confirmed I have MySQL installed and running. I also have a MySQL Server 5.1 folder. Now comes the roadblock. I can not find a "command-line" client in this folder. Going to the DOS command line (which I don't think you mean) gives me only an un-prompted space in which to type. So you see, I can't get beyond this point.[/FONT] [FONT=Arial]Is something really fouled up on this new computer (which runs Windows 7) or am I missing the bloody obvious?[/FONT] [FONT=Arial]Steve[/FONT] On 19 March 2012 10:44, Geoff Stewartwrote: [INDENT]The command line client is in the start menu.... start->MySQL Server 5.1->command-line client (or something to that effect) see if you can see it there.[COLOR=#888888] g[/COLOR] On 19 March 2012 12:18, Steven Apel wrote: [SIZE=2][FONT=Arial]Geoff:[/FONT][/SIZE] [SIZE=2][FONT=Arial]I've done what you've said. I've also waited some time and still no new schedule data. Do I need to do all things in my SQL workbench as described in the forum in order to make this work or is there something else that I'm missing?[/FONT][/SIZE] [/INDENT][/INDENT] [/INDENT][/INDENT] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
General Forums
Newcomers Forum
Schedules Direct
Contact us
RSS
Top
Bottom