Robert Kulagowski wrote:
Check that. It is possible (probable) that there is a capturecard
entry for 2 that needs to be removed before the update would work:
$ killall mythbackend
$ mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql
$ mysql -u mythtv -pmythtv mythconverg
mysql> delete from capturecard where cardid=2;
mysql> update capturecard set cardid=2 where cardid=3;
mysql> delete from cardinput where cardid=2;
mysql> update cardinput set cardid=2 where cardid=3;
$ mythbackend
But isn't cardid an auto-increment field? Doesn't this mean that the
next card that's created will be card 4 rather than 3?
Yes but that wasn't the question. This will change card number 3
to card number 2 in a much less invasive way than truncating the
tables and starting from scratch. If more cards are added or more
experimenting is done, it may make sense to clear the card data
at some point. As I recall, you had something like card number 14
at one time.
-- bjm
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
