So, I have deleted from the program table as follows... delete from program where chanid not in (1001,1008,1021,1020);
...and when I ran mythfilldatabase I end up with the following (note the errors about the channel id towards the bottom)... [EMAIL PROTECTED] djwhyte]# mythfilldatabase Session management error: Authentication Rejected, reason : None of the authentication protocols specified are supported and host-based authentication failed 2005-03-12 13:58:41.813 mythfilldatabase: Listings Download Started ----------------- Start of XMLTV output ----------------- grabing 7 days into /tmp/mythXzKE0r starting 5 threads loading queue 12032005 unchanged 13032005 unchanged 14032005 unchanged 15032005 unchanged 16032005 unchanged 17032005 unchanged 18032005 downloading Use of uninitialized value in string at /usr/local/bin/tv_grab_au line 693. queue is complete all threads done building xml structure no pids in /var/local/tv_grab_au/18032005/guide.prn writing file done ------------------ End of XMLTV output ------------------ Updating icons for sourceid: 1 Unknown xmltv channel identifier: ABC2 Skipping channel. Unknown xmltv channel identifier: ACC Skipping channel. Unknown xmltv channel identifier: SBS Skipping channel. removing conflicting program: free.Brisbane.2.d1.com.au Rage 20050313235000 +1000-20050314063000 +1000 conflicted with : free.Brisbane.2.d1.com.au Order in the House 20050313235000 +1000-20050314005000 +1000 Updated programs: 174 Unchanged programs: 738 Adjusting program database end times... 0 replacements made. 2005-03-12 14:00:48.752 mythfilldatabase: Listings Download Finished Marking repeats...found 0 Unmarking repeats from grabber that fall within our new episode window...found 02005-03-12 14:00:48.838 Connecting to backend server: 192.168.0.100:6543 (try 1 of 5) 2005-03-12 14:00:48.845 Using protocol version 14 [EMAIL PROTECTED] djwhyte]# ...Any have any ideas what I am doing wrong? I have included the tv_grab_au script I modified incase I have done it wrong. Cheers, Dave On Mon, 7 Mar 2005 20:46:03 +1000, David Whyte <[EMAIL PROTECTED]> wrote: > 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. > -- GMAIL is 'da bomb baby....YEAH I have GMail invites, if you want one, email me direct.
tv_grab_au
Description: Binary data
_______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users