[mythtv-users] Re: Cleaning up the channels DB

David Whyte david.whyte at gmail.com
Sat Mar 12 04:04:45 UTC 2005


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)...

[root at myth 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
[root at myth 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 <david.whyte at gmail.com> 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tv_grab_au
Type: application/octet-stream
Size: 17811 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20050312/bb547f67/tv_grab_au.obj


More information about the mythtv-users mailing list