[mythtv-users] cardid reset?

[Ben Brown]

Bruce Markey wrote:

> bobnvic at everestkc.net wrote:
>
>> In adding a new PVR-250MCE card recently I had problems
>> with it not changing channels.  I ended running setup
>> and saying yes to deleting the card and channel info.  After putting 
>> the card info back in, I noticed that I now had cardids of 4,5 and 6 
>> (no 1,2 or 3).  I ended up
>> doing this a couple more times trying to reset the cardid
>> and now have cardids of 11,12 and 13.  Changing the values
>> directly in capturecard in mysql only messed things up.
>>
>> I think everything's working now, but I'd like to reset the
>> cardids to 1,2 and 3.  How can I do this?  Is there a
>> reason for it to work this way or do I have something messed
>> up?
>
>
> The capturecard 'cardid' field is auto_increment so it will
> always use a new, higher number. Probably the easiest way
> to reset is to first make new backup:
>
> http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.5
>
> Once you are sure you have a good backup, look in the file
> for "CREATE TABLE capturecard (". From the mysql commandline,
> "drop capturecard;" then cut'n'paste the 20 or so lines to
> recreate the table. Do the same for the "cardinput" table.
>
> Run setup again and the first card will be "1". The scheduler
> will use card 1 first, card 2 second and so on so this would
> be a good time to consider your order of preference. Note,
> /dev/video0 doesn't have to be first and card 1 doesn't even have
> to be on the master. I have card 1 on a slave and cards 2 and
> 5 (last) on a dual tuner master.
>
> http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.12
>
> --  bjm
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>
you can also try firing up mysql and issuing a couple of sql commands.
something to the effect of

tvhead# mysql -u root mythconverg
mysql > UPDATE capturecard SET cardid = 1 WHERE cardid = 12;

Ben