RE: [mythtv-users] Storage of currently tuned channel
-Original Message- From: [EMAIL PROTECTED] [mailto:mythtv-users- [EMAIL PROTECTED] On Behalf Of Brett May Sent: Monday, August 08, 2005 4:10 AM To: Discussion about mythtv Subject: [mythtv-users] Storage of currently tuned channel Hi All, Can anyone tell me where the current tuned channel is stored in mythtv. Is it stored in the database anywhere? There seems to be a bug in mythtv 18.0 that allows you to change to non visible channels (probably fixed in cvs). I have managed to change to a HD channel and ViaXVMC can't handle it and crashes the frontend. Unfortunately I am now stuck on this channel and can't find a way to change to a valid channel before starting mythbackend. I can use tzap piped to mplayer to watch other channels so its not the card that is stuck. Mythbacked is changing to this channel on startup. Any help would be greatly appreciated. Cheers, Brett Simplest way to do this I think is this. First stop the backend. Not sure if editing the database while it is running will work right. Login to mysql mysql -umythtv -p mythconverg If you left it default the password is mythtv too. Otherwise use your own user/pass. select cardinputid, inputname, startchan from cardinput; This will tell you which card is your HD card and the current channel. UPDATE cardinput SET startchan='13' WHERE cardinputid='1'; This will change the channel in the database. Replace 1 with the cardinput from next to your hd tuner and replace the 13 with any valid hd channel. ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
RE: [mythtv-users] Storage of currently tuned channel
Is there a way to do this from within a script like Jarod's mythpowerbutton.sh? I am trying to make this as wife/children friendly and run into this problem. Would like to allow them to hit a button and have the box kill the frontend, stop the backend, fix the start channel, start the backend, and start the front end. I can do all except the fixing the start channel. Anyone have a one line command prompt way to do this? Thanks, Rob --- Marc Tousignant [EMAIL PROTECTED] wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:mythtv-users- [EMAIL PROTECTED] On Behalf Of Brett May Sent: Monday, August 08, 2005 4:10 AM To: Discussion about mythtv Subject: [mythtv-users] Storage of currently tuned channel Hi All, Can anyone tell me where the current tuned channel is stored in mythtv. Is it stored in the database anywhere? There seems to be a bug in mythtv 18.0 that allows you to change to non visible channels (probably fixed in cvs). I have managed to change to a HD channel and ViaXVMC can't handle it and crashes the frontend. Unfortunately I am now stuck on this channel and can't find a way to change to a valid channel before starting mythbackend. I can use tzap piped to mplayer to watch other channels so its not the card that is stuck. Mythbacked is changing to this channel on startup. Any help would be greatly appreciated. Cheers, Brett Simplest way to do this I think is this. First stop the backend. Not sure if editing the database while it is running will work right. Login to mysql mysql -umythtv -p mythconverg If you left it default the password is mythtv too. Otherwise use your own user/pass. select cardinputid, inputname, startchan from cardinput; This will tell you which card is your HD card and the current channel. UPDATE cardinput SET startchan='13' WHERE cardinputid='1'; This will change the channel in the database. Replace 1 with the cardinput from next to your hd tuner and replace the 13 with any valid hd channel. ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
RE: [mythtv-users] Storage of currently tuned channel
The MySQL line is as follows, I think: mysql -uUSER -Ddatabase -pPASSWORD -eUPDATE cardinputl SET startchan='the_starting_channel_you_want' where cardinputid='the_id_of_the_card_you_want_to_change'; Now just replace the following stuff: -uUSER -- replace the USER with a valid username for MySQL (root is one) -pPASSWORD -- the password of the above user the_starting_channel_you_want -- as was already said, change into the channel you want the_id_of_the_card_you_want_to_change-- this is the id of the card you want to affect That should do it, although I'm not sure this is what you wanted ;-) Is there a way to do this from within a script like Jarod's mythpowerbutton.sh? I am trying to make this as wife/children friendly and run into this problem. Would like to allow them to hit a button and have the box kill the frontend, stop the backend, fix the start channel, start the backend, and start the front end. I can do all except the fixing the start channel. Anyone have a one line command prompt way to do this? Thanks, Rob --- Marc Tousignant [EMAIL PROTECTED] wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:mythtv-users- [EMAIL PROTECTED] On Behalf Of Brett May Sent: Monday, August 08, 2005 4:10 AM To: Discussion about mythtv Subject: [mythtv-users] Storage of currently tuned channel Hi All, Can anyone tell me where the current tuned channel is stored in mythtv. Is it stored in the database anywhere? There seems to be a bug in mythtv 18.0 that allows you to change to non visible channels (probably fixed in cvs). I have managed to change to a HD channel and ViaXVMC can't handle it and crashes the frontend. Unfortunately I am now stuck on this channel and can't find a way to change to a valid channel before starting mythbackend. I can use tzap piped to mplayer to watch other channels so its not the card that is stuck. Mythbacked is changing to this channel on startup. Any help would be greatly appreciated. Cheers, Brett Simplest way to do this I think is this. First stop the backend. Not sure if editing the database while it is running will work right. Login to mysql mysql -umythtv -p mythconverg If you left it default the password is mythtv too. Otherwise use your own user/pass. select cardinputid, inputname, startchan from cardinput; This will tell you which card is your HD card and the current channel. UPDATE cardinput SET startchan='13' WHERE cardinputid='1'; This will change the channel in the database. Replace 1 with the cardinput from next to your hd tuner and replace the 13 with any valid hd channel. ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users