[mythtv-users] More information on my browse problem.
Peter Valdemar Morch
swp5jhu02 at sneakemail.com
Fri May 14 07:43:20 EDT 2004
OK, so this may be a wild goose chase, but it sounds like you're up for
that too at this point! :-D
From what you write, I'm just curious as to whether the contents of the
program table are correct.
Does this show something similar on your unit? (Especially is the date
format similar? You might try looking at all the records in the program
database if there aren't too many.
myth at peter:~> mysql -u mythtv -p -e 'select chanid, starttime, endtime
from program order by starttime desc limit 10 ' mythconverg
Enter password:
+--------+----------------+----------------+
| chanid | starttime | endtime |
+--------+----------------+----------------+
| 1006 | 20040514055500 | 20040514062500 |
| 1014 | 20040514055500 | 20040514060000 |
| 1013 | 20040514053000 | 20040514060000 |
| 1006 | 20040514053000 | 20040514055500 |
| 1015 | 20040514053000 | 20040514060000 |
| 1017 | 20040514053000 | 20040514060000 |
| 1012 | 20040514053000 | 20040514060000 |
| 1011 | 20040514052500 | 20040514070000 |
| 1013 | 20040514050000 | 20040514053000 |
| 1015 | 20040514050000 | 20040514053000 |
+--------+----------------+----------------+
myth at peter:~> mysql -u mythtv -p -Ee 'select * from channel where
chanid=1006 ' mythconverg
Enter password:
*************************** 1. row ***************************
chanid: 1006
channum: 7
freqid: 43
sourceid: 1
callsign: 3+
name: 3+
icon:
finetune: 0
videofilters:
xmltvid: 279.tdckabeltv.dk
recpriority: 0
contrast: 32768
brightness: 32768
colour: 32768
hue: 32768
tvformat: Default
commfree: 0
visible: 1
outputfilters: NULL
(Here I guess we just want to make sure that the chanid form the program
table actually exists in the channel table...)
Peter
--
Peter Valdemar Mørch
http://www.XXXXXXXXX
More information about the mythtv-users
mailing list