RE: [mythtv-users] Storage of currently tuned channel

2005-08-08 Thread Marc Tousignant
 -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

2005-08-08 Thread Rob Bongiovi
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

2005-08-08 Thread mythtv

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