LinHES Forums • View topic

bigbro · **Posted:** Sun Apr 22, 2007 6:15 pm

In this post R5E50 Upgrade Hints and Hazards http://mysettopbox.tv/phpBB2/viewtopic.php?p=88235#88235
A couple of quotes from TJC...

Quote:

..getting errors/warnings when you try to exit mythtv-setup along the lines of "Card 0 (type) is set to start on channel 2, which does not exist." see this thread...on getting rid of stale capture...

Later in thread..

Quote:

If the following commands show a cardid (especially 0) in the cardinput table which is not listed in the capturecard table you should remove all references to it:

There is a post referenced in there for removing the False or stale or No Longer Valid inputs however, it doesn't seem to be available.

I did look for the posts.

Here is the script I ran and my outputs.
As root:

Code:

mysql mythconverg -e "select cardid, videodevice, defaultinput from capturecard"
+--------+-------------+--------------+
| cardid | videodevice | defaultinput |
+--------+-------------+--------------+
|      1 | /dev/video0 | S-Video 0    |
|      2 | /dev/video0 | S-Video 0    |
|      3 | /dev/video0 | S-Video 0    |
|      4 | /dev/video1 | Composite 0  |
+--------+-------------+--------------+

mysql mythconverg -e "select cardid, sourceid, inputname from cardinput"
+--------+----------+-------------+
| cardid | sourceid | inputname   |
+--------+----------+-------------+
|      0 |        0 |             |
|      1 |        1 | S-Video 0   |
|      0 |        0 |             |
|      2 |        1 | S-Video 0   |
|      0 |        0 |             |
|      3 |        1 | S-Video 0   |
|      0 |        0 |             |
|      4 |        1 | Composite 0 |
|      0 |        0 |             |
+--------+----------+-------------+

My Question and I am sure there is more than one answer. What is the way to get rid of these "0" cardids?

I am thinking I can use Webmin > Servers > Mysql Database Server.
Select table "mythconverg"
Search out "cardinput"
It will show a Table. Select that table and it will show the fields.

At this point Select View Data

That gives me a list of the card inputs similar to the table above.
I can then select the Id's that are a "0" and tell it to delete the selected rows.

Is this workable?

If there is another method, please post as well.

Asking before I try.

Using Knoppmyth R5C7

TIA.

Andy

Solved: How to remove Stale Card inputs?

Who is online