[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