Mika Orajärvi wrote:
I think there's some bugs in the mentioned file and function regarding
the names of the mysql tables/entries. I'm using the mythtv svn.
The problems appeared after I wiped the DB clean and run the setup
again.
In the mysql query:
----
query.prepare(
"SELECT startchan "
"FROM capturecard, cardinput "
"WHERE capturecard.cardid = cardinput.cardid AND "
" capturecard.cardid = :CARDID AND "
" inputname = :INPUTNAME");
---
I think the "inputname" should be "defaultinput". That's at least found
in the DB. After I changed the name, mythbackend found the starting
channel correctly.
inputname is a valid column in the cardinput table, and, therefore,
should be found by that query:
mysql> SELECT startchan
-> FROM capturecard, cardinput
-> WHERE capturecard.cardid = cardinput.cardid AND
-> capturecard.cardid = 1 AND
-> inputname = 'S-Video 0';
+-----------+
| startchan |
+-----------+
| 238 |
+-----------+
1 row in set (0.00 sec)
I'll bet you looked for it in the capturecard table... ;)
But there's probably another bug somewhere (haven't found that yet)
since LiveTv does not start. Backend gives the following log:
----
TVRec(1) Error: Channel: '1' was not found in the database.
Most likely, your DefaultTVChannel setting is
wrong.
Could not start livetv.
----
Shall I make a ticket?
No. Fix your config. ;) (Or, at least, not yet. First verify that
your config is correct.)
Make sure you provide a valid value for every input you have associated
with a video source.
Starting LiveTV channel.
This is updated on every successful channel change.
Oh, and make sure you change your code back before testing. Using
defaultinput breaks the query.
Mike
_______________________________________________
mythtv-dev mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
