[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