In my upgrade to 0.17 I really screwed things up! In the end I delted the channels and set them up again, but not in the exact same way.
Now, I am trying to add ABC2 (a new aussie channel) but it is picking up the data for a channel which I cannot tune (SBS) and so generally hide. The following are the relevant excerpts from the program and channel tables... mysql> select distinct chanid from program; +--------+ | chanid | +--------+ | 1000 | | 1001 | | 1002 | | 1008 | | 1020 | | 1021 | | 1024 | | 1025 | | 1026 | | 1027 | | 1028 | +--------+ 11 rows in set (0.02 sec) mysql> select distinct chanid, channum, callsign from channel; +--------+---------+-----------------+ | chanid | channum | callsign | +--------+---------+-----------------+ | 1001 | 2 | ABC TV Brisbane | | 1008 | 10 | TEN Digital | | 1021 | 7 | 7 Digital | | 1000 | | 1000 | | 1020 | 9 | Nine Digital | | 1028 | 21 | ABC2 | +--------+---------+-----------------+ 6 rows in set (0.00 sec) mysql> Can I simply remove from the program table the data for the chanids that don't exist in the channel table? My goal is to clear up the ABC2/SBS mixup! Cheers, Dave -- GMAIL is 'da bomb baby....YEAH I have GMail invites, if you want one, email me direct.
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
