1 | 2007-01-24 00:24:56.755 Using runtime prefix = /usr |
---|
2 | 2007-01-24 00:24:56.792 New DB connection, total: 1 |
---|
3 | 2007-01-24 00:24:56.796 Connected to database 'mythconverg' at host: localhost |
---|
4 | 2007-01-24 00:24:56.799 Enabling Settings Cache. |
---|
5 | 2007-01-24 00:24:56.799 Clearing Settings Cache. |
---|
6 | 2007-01-24 00:24:56.801 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname = 'PVR' ; |
---|
7 | 2007-01-24 00:24:56.802 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname IS NULL; |
---|
8 | 2007-01-24 00:24:56.804 MSqlQuery: SELECT data FROM settings WHERE value = 'LogMaxCount' AND hostname = 'PVR' ; |
---|
9 | 2007-01-24 00:24:56.805 MSqlQuery: SELECT data FROM settings WHERE value = 'LogPrintLevel' AND hostname = 'PVR' ; |
---|
10 | 2007-01-24 00:24:56.807 MSqlQuery: SELECT sourceid,name,xmltvgrabber,userid,password,lineupid FROM videosource ORDER BY sourceid; |
---|
11 | 2007-01-24 00:24:56.808 New DB connection, total: 2 |
---|
12 | 2007-01-24 00:24:56.809 Connected to database 'mythconverg' at host: localhost |
---|
13 | 2007-01-24 00:24:56.841 MSqlQuery: SELECT MAX(endtime) FROM program WHERE manualid=0; |
---|
14 | 2007-01-24 00:24:56.841 Updating source #1 (DTV) with grabber datadirect |
---|
15 | 2007-01-24 00:24:56.842 MSqlQuery: SELECT COUNT(chanid) FROM channel WHERE sourceid = 1 AND xmltvid != '' |
---|
16 | 2007-01-24 00:24:56.846 Found 12 channels for source 1 which use grabber |
---|
17 | 2007-01-24 00:24:56.846 |
---|
18 | 2007-01-24 00:24:56.846 Checking day @ offset 0, date: Wed Jan 24 2007 |
---|
19 | 2007-01-24 00:24:56.855 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '-1' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '0' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
20 | 2007-01-24 00:24:56.856 Checking program counts for day -1 |
---|
21 | 2007-01-24 00:24:56.856 chanid 1021 -> 0 programs |
---|
22 | 2007-01-24 00:24:56.856 chanid 1041 -> 1 programs |
---|
23 | 2007-01-24 00:24:56.856 chanid 1042 -> 1 programs |
---|
24 | 2007-01-24 00:24:56.856 chanid 1051 -> 1 programs |
---|
25 | 2007-01-24 00:24:56.856 chanid 1052 -> 1 programs |
---|
26 | 2007-01-24 00:24:56.856 chanid 1091 -> 0 programs |
---|
27 | 2007-01-24 00:24:56.856 chanid 1092 -> 0 programs |
---|
28 | 2007-01-24 00:24:56.856 chanid 1093 -> 0 programs |
---|
29 | 2007-01-24 00:24:56.856 chanid 1094 -> 0 programs |
---|
30 | 2007-01-24 00:24:56.856 chanid 1111 -> 0 programs |
---|
31 | 2007-01-24 00:24:56.856 chanid 1112 -> 0 programs |
---|
32 | 2007-01-24 00:24:56.857 chanid 1301 -> 1 programs |
---|
33 | 2007-01-24 00:24:56.863 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '0' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '1' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
34 | 2007-01-24 00:24:56.864 Checking program counts for day 0 |
---|
35 | 2007-01-24 00:24:56.864 chanid 1021 -> 5 programs |
---|
36 | 2007-01-24 00:24:56.864 chanid 1041 -> 5 programs |
---|
37 | 2007-01-24 00:24:56.864 chanid 1042 -> 5 programs |
---|
38 | 2007-01-24 00:24:56.864 chanid 1051 -> 5 programs |
---|
39 | 2007-01-24 00:24:56.864 chanid 1052 -> 5 programs |
---|
40 | 2007-01-24 00:24:56.864 chanid 1091 -> 3 programs |
---|
41 | 2007-01-24 00:24:56.864 chanid 1092 -> 3 programs |
---|
42 | 2007-01-24 00:24:56.864 chanid 1093 -> 3 programs |
---|
43 | 2007-01-24 00:24:56.864 chanid 1094 -> 3 programs |
---|
44 | 2007-01-24 00:24:56.864 chanid 1111 -> 7 programs |
---|
45 | 2007-01-24 00:24:56.864 chanid 1112 -> 7 programs |
---|
46 | 2007-01-24 00:24:56.864 chanid 1301 -> 7 programs |
---|
47 | 2007-01-24 00:24:56.865 Data is already present for Wed Jan 24 2007, skipping |
---|
48 | 2007-01-24 00:24:56.865 |
---|
49 | 2007-01-24 00:24:56.865 Checking day @ offset 1, date: Thu Jan 25 2007 |
---|
50 | 2007-01-24 00:24:56.865 Data Refresh always needed for tomorrow |
---|
51 | 2007-01-24 00:24:56.865 Refreshing data for Thu Jan 25 2007 |
---|
52 | 2007-01-24 00:24:56.866 New DB DataDirect connection |
---|
53 | 2007-01-24 00:24:56.866 Connected to database 'mythconverg' at host: localhost |
---|
54 | 2007-01-24 00:24:56.868 MSqlQuery: UPDATE settings SET data ='2007-01-24 00:24' WHERE value='mythfilldatabaseLastRunStart' |
---|
55 | 2007-01-24 00:24:56.868 Retrieving datadirect data. |
---|
56 | 2007-01-24 00:24:56.868 Grabbing data for Wed Jan 24 2007 offset 1 |
---|
57 | 2007-01-24 00:24:56.868 From Thu Jan 25 06:00:00 2007 to Fri Jan 26 06:00:00 2007 (UTC) |
---|
58 | 2007-01-24 00:24:56.868 Grabbing listing data |
---|
59 | 2007-01-24 00:24:58.040 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_genre ( programid char(12) NOT NULL, class char(30), relevance char(1), INDEX progidx (programid)); |
---|
60 | 2007-01-24 00:24:58.041 MSqlQuery: TRUNCATE TABLE dd_genre; |
---|
61 | 2007-01-24 00:24:58.043 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_lineup ( lineupid char(100), name char(42), type char(20), postal char(6), device char(30) ); |
---|
62 | 2007-01-24 00:24:58.044 MSqlQuery: TRUNCATE TABLE dd_lineup; |
---|
63 | 2007-01-24 00:24:58.045 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_lineupmap ( lineupid char(100), stationid char(12), channel char(5), channelMinor char(3) ); |
---|
64 | 2007-01-24 00:24:58.045 MSqlQuery: TRUNCATE TABLE dd_lineupmap; |
---|
65 | 2007-01-24 00:24:58.047 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_productioncrew ( programid char(12), role char(30), givenname char(20), surname char(20), fullname char(41), INDEX progidx (programid), INDEX nameidx (fullname)); |
---|
66 | 2007-01-24 00:24:58.048 MSqlQuery: TRUNCATE TABLE dd_productioncrew; |
---|
67 | 2007-01-24 00:24:58.050 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_program ( programid char(12) NOT NULL, seriesid char(12), title varchar(120), subtitle varchar(150), description text, mpaarating char(5), starrating char(5), runtime time, year char(4), showtype char(30), category_type char(64), colorcode char(20), originalairdate date, syndicatedepisodenumber char(20), stars float unsigned, PRIMARY KEY (programid)); |
---|
68 | 2007-01-24 00:24:58.051 MSqlQuery: TRUNCATE TABLE dd_program; |
---|
69 | 2007-01-24 00:24:58.052 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_schedule ( programid char(12), stationid char(12), scheduletime datetime, duration time, isrepeat bool, stereo bool, subtitled bool, hdtv bool, closecaptioned bool, tvrating char(5), partnumber int, parttotal int, endtime datetime, INDEX progidx (programid) ); |
---|
70 | 2007-01-24 00:24:58.053 MSqlQuery: TRUNCATE TABLE dd_schedule; |
---|
71 | 2007-01-24 00:24:58.054 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_station ( stationid char(12), callsign char(10), stationname varchar(40), affiliate varchar(25), fccchannelnumber char(15) ); |
---|
72 | 2007-01-24 00:24:58.055 MSqlQuery: TRUNCATE TABLE dd_station; |
---|
73 | 2007-01-24 00:24:58.057 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_v_program ( chanid int unsigned NOT NULL, starttime datetime NOT NULL, endtime datetime, title varchar(128), subtitle varchar(128), description text, category varchar(64), category_type varchar(64), airdate year, stars float unsigned, previouslyshown tinyint, isrepeat bool, stereo bool, subtitled bool, hdtv bool, closecaptioned bool, partnumber int, parttotal int, seriesid char(12), originalairdate date, showtype varchar(30), colorcode varchar(20), syndicatedepisodenumber varchar(20), programid char(12), tvrating char(5), mpaarating char(5), INDEX progidx (programid)); |
---|
74 | 2007-01-24 00:24:58.058 MSqlQuery: TRUNCATE TABLE dd_v_program; |
---|
75 | 2007-01-24 00:24:58.060 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_v_station ( stationid char(12), callsign char(10), stationname varchar(40), affiliate varchar(25), fccchannelnumber char(15), channel char(5), channelMinor char(3) ); |
---|
76 | 2007-01-24 00:24:58.061 MSqlQuery: TRUNCATE TABLE dd_v_station; |
---|
77 | 2007-01-24 00:24:58.062 DataDirect: Your subscription expires on 03/05/07 18:16:22 |
---|
78 | 2007-01-24 00:24:58.063 MSqlQuery: UPDATE settings SET data ='Your subscription expires on 03/05/07 18:16:22' WHERE value='DataDirectMessage' |
---|
79 | 2007-01-24 00:24:58.064 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('21237', 'KDNLDT', 'KDNLDT (KDNL-DT)', 'ABC Affiliate', '31') |
---|
80 | 2007-01-24 00:24:58.065 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('32057', 'KETCDT', 'KETCDT (KETC-DT)', 'PBS Affiliate', '39') |
---|
81 | 2007-01-24 00:24:58.066 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('32060', 'KETCDT2', 'KETCDT2 (KETC-DT2)', 'PBS Affiliate', '39') |
---|
82 | 2007-01-24 00:24:58.067 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('32065', 'KETCDT3', 'KETCDT3 (KETC-DT3)', 'PBS Affiliate', '39') |
---|
83 | 2007-01-24 00:24:58.068 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('49623', 'KETCDT4', 'KETCDT4 (KETC-DT4)', 'PBS Affiliate', '39') |
---|
84 | 2007-01-24 00:24:58.068 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('20506', 'KMOVDT', 'KMOVDT (KMOV-DT)', 'CBS Affiliate', '56') |
---|
85 | 2007-01-24 00:24:58.069 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('34808', 'KPLRDT', 'KPLRDT (KPLR-DT)', 'CW Affiliate', '26') |
---|
86 | 2007-01-24 00:24:58.071 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('50834', 'KPLRDT2', 'KPLRDT2 (KPLR-DT2)', 'Independent', '26') |
---|
87 | 2007-01-24 00:24:58.072 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('20513', 'KSDKDT', 'KSDKDT (KSDK-DT)', 'NBC Affiliate', '35') |
---|
88 | 2007-01-24 00:24:58.072 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('47735', 'KSDKDT2', 'KSDKDT2 (KSDK-DT2)', 'NBC Affiliate', '35') |
---|
89 | 2007-01-24 00:24:58.073 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('21300', 'KTVIDT', 'KTVIDT (KTVI-DT)', 'Fox Affiliate', '43') |
---|
90 | 2007-01-24 00:24:58.074 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '20506', '4', '1') |
---|
91 | 2007-01-24 00:24:58.075 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '20513', '5', '1') |
---|
92 | 2007-01-24 00:24:58.076 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '21237', '30', '1') |
---|
93 | 2007-01-24 00:24:58.076 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '21300', '2', '1') |
---|
94 | 2007-01-24 00:24:58.077 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '32057', '9', '1') |
---|
95 | 2007-01-24 00:24:58.078 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '32060', '9', '2') |
---|
96 | 2007-01-24 00:24:58.078 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '32065', '9', '3') |
---|
97 | 2007-01-24 00:24:58.079 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '34808', '11', '1') |
---|
98 | 2007-01-24 00:24:58.080 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '47735', '5', '2') |
---|
99 | 2007-01-24 00:24:58.080 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '49623', '9', '4') |
---|
100 | 2007-01-24 00:24:58.081 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '50834', '11', '2') |
---|
101 | 2007-01-24 00:24:58.082 New DB connection, total: 3 |
---|
102 | 2007-01-24 00:24:58.083 Connected to database 'mythconverg' at host: localhost |
---|
103 | 2007-01-24 00:24:58.085 MSqlQuery: SELECT sourceid FROM videosource WHERE lineupid = 'PC:63119' |
---|
104 | 2007-01-24 00:24:58.085 sourceid 1 has lineup type: LocalBroadcast |
---|
105 | 2007-01-24 00:24:58.086 MSqlQuery: INSERT INTO dd_lineup ( lineupid, name, type, device, postal) VALUES ('PC:63119', 'Local Broadcast Listings', 'LocalBroadcast', NULL, '63119') |
---|
106 | |
---|
107 | 2007-01-24 00:25:00.127 Grab complete. Actual data from Thu Jan 25 06:00:00 2007 to Fri Jan 26 06:00:00 2007 (UTC) |
---|
108 | 2007-01-24 00:25:00.128 MSqlQuery: UPDATE settings SET data ='2007-01-24 00:25' WHERE value='mythfilldatabaseLastRunEnd' |
---|
109 | 2007-01-24 00:25:00.128 Main temp tables populated. |
---|
110 | 2007-01-24 00:25:00.128 Updating myth channels. |
---|
111 | 2007-01-24 00:25:00.129 MSqlQuery: TRUNCATE TABLE dd_v_station; |
---|
112 | 2007-01-24 00:25:00.131 MSqlQuery: INSERT INTO dd_v_station ( stationid, callsign, stationname, affiliate, fccchannelnumber, channel, channelMinor) SELECT dd_station.stationid, callsign, stationname, affiliate, fccchannelnumber, channel, channelMinor FROM dd_station, dd_lineupmap WHERE ((dd_station.stationid = dd_lineupmap.stationid) AND (dd_lineupmap.lineupid = 'PC:63119')) |
---|
113 | 2007-01-24 00:25:00.131 MSqlQuery: SELECT cardtype FROM capturecard, cardinput WHERE capturecard.cardid = cardinput.cardid AND cardinput.sourceid = 1 |
---|
114 | 2007-01-24 00:25:00.132 MSqlQuery: SELECT cardtype FROM capturecard, cardinput WHERE capturecard.cardid = cardinput.cardid AND cardinput.sourceid = 1 |
---|
115 | 2007-01-24 00:25:00.133 MSqlQuery: SELECT dd_v_station.stationid, dd_v_station.callsign, dd_v_station.stationname, dd_v_station.fccchannelnumber, dd_v_station.channel, dd_v_station.channelMinor FROM dd_v_station LEFT JOIN channel ON dd_v_station.stationid = channel.xmltvid AND channel.sourceid = 1 WHERE channel.chanid IS NULL |
---|
116 | 2007-01-24 00:25:00.134 MSqlQuery: SELECT channum FROM channel WHERE sourceid = 1 |
---|
117 | 2007-01-24 00:25:00.135 MSqlQuery: SELECT chanid, callsign, name FROM channel WHERE sourceid = 1 AND xmltvid = 0 AND ( channum = '9.2' OR ( freqid = 39 AND freqid != '0' AND freqid != '' ) OR ( atsc_major_chan = 9 AND atsc_minor_chan = 2 ) ) |
---|
118 | 2007-01-24 00:25:00.135 DataDirect: Not adding channel KETCDT2 (KETC-DT2) (KETCDT2). |
---|
119 | 2007-01-24 00:25:00.136 MSqlQuery: SELECT channum FROM channel WHERE sourceid = 1 |
---|
120 | 2007-01-24 00:25:00.137 MSqlQuery: SELECT chanid, callsign, name FROM channel WHERE sourceid = 1 AND xmltvid = 0 AND ( channum = '9.3' OR ( freqid = 39 AND freqid != '0' AND freqid != '' ) OR ( atsc_major_chan = 9 AND atsc_minor_chan = 3 ) ) |
---|
121 | 2007-01-24 00:25:00.137 DataDirect: Not adding channel KETCDT3 (KETC-DT3) (KETCDT3). |
---|
122 | 2007-01-24 00:25:00.137 MSqlQuery: SELECT channum FROM channel WHERE sourceid = 1 |
---|
123 | 2007-01-24 00:25:00.138 MSqlQuery: SELECT chanid, callsign, name FROM channel WHERE sourceid = 1 AND xmltvid = 0 AND ( channum = '5.2' OR ( freqid = 35 AND freqid != '0' AND freqid != '' ) OR ( atsc_major_chan = 5 AND atsc_minor_chan = 2 ) ) |
---|
124 | 2007-01-24 00:25:00.138 DataDirect: Not adding channel KSDKDT2 (KSDK-DT2) (KSDKDT2). |
---|
125 | 2007-01-24 00:25:00.139 MSqlQuery: SELECT channum FROM channel WHERE sourceid = 1 |
---|
126 | 2007-01-24 00:25:00.139 MSqlQuery: SELECT chanid, callsign, name FROM channel WHERE sourceid = 1 AND xmltvid = 0 AND ( channum = '9.4' OR ( freqid = 39 AND freqid != '0' AND freqid != '' ) OR ( atsc_major_chan = 9 AND atsc_minor_chan = 4 ) ) |
---|
127 | 2007-01-24 00:25:00.139 DataDirect: Not adding channel KETCDT4 (KETC-DT4) (KETCDT4). |
---|
128 | 2007-01-24 00:25:00.140 MSqlQuery: SELECT channum FROM channel WHERE sourceid = 1 |
---|
129 | 2007-01-24 00:25:00.140 MSqlQuery: SELECT chanid, callsign, name FROM channel WHERE sourceid = 1 AND xmltvid = 0 AND ( channum = '11.2' OR ( freqid = 26 AND freqid != '0' AND freqid != '' ) OR ( atsc_major_chan = 11 AND atsc_minor_chan = 2 ) ) |
---|
130 | 2007-01-24 00:25:00.140 DataDirect: Not adding channel KPLRDT2 (KPLR-DT2) (KPLRDT2). |
---|
131 | 2007-01-24 00:25:00.141 Updating icons for sourceid: 1 |
---|
132 | 2007-01-24 00:25:00.141 MSqlQuery: SELECT ch.chanid, nim.url FROM (channel ch, callsignnetworkmap csm) RIGHT JOIN networkiconmap nim ON csm.network = nim.network WHERE ch.callsign = csm.callsign AND (icon = 'none' OR icon = '') AND ch.sourceid = 1 |
---|
133 | 2007-01-24 00:25:00.141 Grabbing login cookies for listing update |
---|
134 | 2007-01-24 00:25:00.142 Grabbing login cookies and lineups |
---|
135 | 2007-01-24 00:25:00.960 Grabbing listing for listing update |
---|
136 | 2007-01-24 00:25:00.960 Grabbing lineup PC:63119 for modification |
---|
137 | 2007-01-24 00:25:01.871 MSqlQuery: SELECT xmltvid FROM channel WHERE sourceid = 1 |
---|
138 | 2007-01-24 00:25:01.872 MSqlQuery: SELECT xmltvgrabber, userid, password, lineupid FROM videosource WHERE sourceid = 1 |
---|
139 | 2007-01-24 00:25:01.872 Saving updated DataDirect listing |
---|
140 | 2007-01-24 00:25:01.872 Saving lineup PC:63119 with 6 channels |
---|
141 | 2007-01-24 00:25:03.160 Removed 5 channel(s) from lineup. |
---|
142 | 2007-01-24 00:25:03.160 Channels updated. |
---|
143 | 2007-01-24 00:25:03.161 MSqlQuery: TRUNCATE TABLE dd_v_program; |
---|
144 | 2007-01-24 00:25:03.177 MSqlQuery: INSERT INTO dd_v_program ( chanid, starttime, endtime, title, subtitle, description, airdate, stars, previouslyshown, stereo, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, showtype, category_type, colorcode, syndicatedepisodenumber, tvrating, mpaarating, programid ) SELECT chanid, scheduletime, endtime, title, subtitle, description, year, stars, isrepeat, stereo, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, showtype, category_type, colorcode, syndicatedepisodenumber, tvrating, mpaarating, dd_program.programid FROM channel, dd_schedule, dd_program WHERE ((dd_schedule.programid = dd_program.programid) AND (channel.xmltvid = dd_schedule.stationid) AND (channel.sourceid = 1)) |
---|
145 | 2007-01-24 00:25:03.178 MSqlQuery: ANALYZE TABLE dd_v_program; |
---|
146 | 2007-01-24 00:25:03.179 MSqlQuery: ANALYZE TABLE dd_productioncrew; |
---|
147 | 2007-01-24 00:25:03.180 MSqlQuery: SELECT count(*) from dd_v_program; |
---|
148 | 2007-01-24 00:25:03.180 Clearing data for source. |
---|
149 | 2007-01-24 00:25:03.180 Clearing from Thu Jan 25 00:00:00 2007 to Fri Jan 26 00:00:00 2007 (localtime) |
---|
150 | 2007-01-24 00:25:03.181 MSqlQuery: SELECT chanid FROM channel WHERE sourceid = 1 ; |
---|
151 | 2007-01-24 00:25:03.182 New DB connection, total: 4 |
---|
152 | 2007-01-24 00:25:03.182 Connected to database 'mythconverg' at host: localhost |
---|
153 | 2007-01-24 00:25:03.183 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1111 ; |
---|
154 | 2007-01-24 00:25:03.188 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1111 ; |
---|
155 | 2007-01-24 00:25:03.190 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1111 ; |
---|
156 | 2007-01-24 00:25:03.201 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1111 ; |
---|
157 | 2007-01-24 00:25:03.204 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1111 ; |
---|
158 | 2007-01-24 00:25:03.205 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1112 ; |
---|
159 | 2007-01-24 00:25:03.212 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1112 ; |
---|
160 | 2007-01-24 00:25:03.215 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1112 ; |
---|
161 | 2007-01-24 00:25:03.225 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1112 ; |
---|
162 | 2007-01-24 00:25:03.228 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1112 ; |
---|
163 | 2007-01-24 00:25:03.229 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1301 ; |
---|
164 | 2007-01-24 00:25:03.235 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1301 ; |
---|
165 | 2007-01-24 00:25:03.237 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1301 ; |
---|
166 | 2007-01-24 00:25:03.243 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1301 ; |
---|
167 | 2007-01-24 00:25:03.246 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1301 ; |
---|
168 | 2007-01-24 00:25:03.246 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1051 ; |
---|
169 | 2007-01-24 00:25:03.251 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1051 ; |
---|
170 | 2007-01-24 00:25:03.253 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1051 ; |
---|
171 | 2007-01-24 00:25:03.258 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1051 ; |
---|
172 | 2007-01-24 00:25:03.260 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1051 ; |
---|
173 | 2007-01-24 00:25:03.261 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1052 ; |
---|
174 | 2007-01-24 00:25:03.266 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1052 ; |
---|
175 | 2007-01-24 00:25:03.269 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1052 ; |
---|
176 | 2007-01-24 00:25:03.273 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1052 ; |
---|
177 | 2007-01-24 00:25:03.276 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1052 ; |
---|
178 | 2007-01-24 00:25:03.276 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1091 ; |
---|
179 | 2007-01-24 00:25:03.281 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1091 ; |
---|
180 | 2007-01-24 00:25:03.283 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1091 ; |
---|
181 | 2007-01-24 00:25:03.283 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1091 ; |
---|
182 | 2007-01-24 00:25:03.287 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1091 ; |
---|
183 | 2007-01-24 00:25:03.287 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1092 ; |
---|
184 | 2007-01-24 00:25:03.291 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1092 ; |
---|
185 | 2007-01-24 00:25:03.292 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1092 ; |
---|
186 | 2007-01-24 00:25:03.293 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1092 ; |
---|
187 | 2007-01-24 00:25:03.295 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1092 ; |
---|
188 | 2007-01-24 00:25:03.296 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1093 ; |
---|
189 | 2007-01-24 00:25:03.300 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1093 ; |
---|
190 | 2007-01-24 00:25:03.302 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1093 ; |
---|
191 | 2007-01-24 00:25:03.302 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1093 ; |
---|
192 | 2007-01-24 00:25:03.306 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1093 ; |
---|
193 | 2007-01-24 00:25:03.306 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1094 ; |
---|
194 | 2007-01-24 00:25:03.312 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1094 ; |
---|
195 | 2007-01-24 00:25:03.314 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1094 ; |
---|
196 | 2007-01-24 00:25:03.315 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1094 ; |
---|
197 | 2007-01-24 00:25:03.318 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1094 ; |
---|
198 | 2007-01-24 00:25:03.318 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1021 ; |
---|
199 | 2007-01-24 00:25:03.323 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1021 ; |
---|
200 | 2007-01-24 00:25:03.325 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1021 ; |
---|
201 | 2007-01-24 00:25:03.328 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1021 ; |
---|
202 | 2007-01-24 00:25:03.330 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1021 ; |
---|
203 | 2007-01-24 00:25:03.331 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1041 ; |
---|
204 | 2007-01-24 00:25:03.335 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1041 ; |
---|
205 | 2007-01-24 00:25:03.336 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1041 ; |
---|
206 | 2007-01-24 00:25:03.343 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1041 ; |
---|
207 | 2007-01-24 00:25:03.345 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1041 ; |
---|
208 | 2007-01-24 00:25:03.346 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1042 ; |
---|
209 | 2007-01-24 00:25:03.351 MSqlQuery: DELETE FROM program WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1042 ; |
---|
210 | 2007-01-24 00:25:03.353 MSqlQuery: DELETE FROM programrating WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1042 ; |
---|
211 | 2007-01-24 00:25:03.359 MSqlQuery: DELETE FROM credits WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1042 ; |
---|
212 | 2007-01-24 00:25:03.361 MSqlQuery: DELETE FROM programgenres WHERE starttime >= '2007-01-25T00:00:00' AND starttime < '2007-01-26T00:00:00' AND chanid = 1042 ; |
---|
213 | 2007-01-24 00:25:03.361 Data for source cleared. |
---|
214 | 2007-01-24 00:25:03.361 Updating programs. |
---|
215 | 2007-01-24 00:25:03.427 MSqlQuery: INSERT IGNORE INTO program (chanid, starttime, endtime, title, subtitle, description, showtype, category, category_type, airdate, stars, previouslyshown, stereo, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, colorcode, syndicatedepisodenumber, programid) SELECT dd_v_program.chanid, DATE_ADD(starttime, INTERVAL channel.tmoffset MINUTE), DATE_ADD(endtime, INTERVAL channel.tmoffset MINUTE), title, subtitle, description, showtype, dd_genre.class, category_type, airdate, stars, previouslyshown, stereo, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, colorcode, syndicatedepisodenumber, dd_v_program.programid FROM (dd_v_program, channel) LEFT JOIN dd_genre ON (dd_v_program.programid = dd_genre.programid AND dd_genre.relevance = '0') WHERE dd_v_program.chanid = channel.chanid; |
---|
216 | 2007-01-24 00:25:03.430 MSqlQuery: INSERT IGNORE INTO programrating (chanid, starttime, system, rating) SELECT dd_v_program.chanid, DATE_ADD(starttime, INTERVAL channel.tmoffset MINUTE), 'MPAA', mpaarating FROM dd_v_program, channel WHERE mpaarating != '' AND dd_v_program.chanid = channel.chanid |
---|
217 | 2007-01-24 00:25:03.444 MSqlQuery: INSERT IGNORE INTO programrating (chanid, starttime, system, rating) SELECT dd_v_program.chanid, DATE_ADD(starttime, INTERVAL channel.tmoffset MINUTE), 'VCHIP', tvrating FROM dd_v_program, channel WHERE tvrating != '' AND dd_v_program.chanid = channel.chanid |
---|
218 | 2007-01-24 00:25:03.456 MSqlQuery: INSERT IGNORE INTO people (name) SELECT fullname FROM dd_productioncrew; |
---|
219 | 2007-01-24 00:25:03.534 MSqlQuery: INSERT IGNORE INTO credits (chanid, starttime, person, role) SELECT dd_v_program.chanid, DATE_ADD(starttime, INTERVAL channel.tmoffset MINUTE), person, role FROM dd_productioncrew, dd_v_program, channel, people WHERE ((dd_productioncrew.programid = dd_v_program.programid) AND (dd_productioncrew.fullname = people.name)) AND dd_v_program.chanid = channel.chanid; |
---|
220 | 2007-01-24 00:25:03.577 MSqlQuery: INSERT IGNORE INTO programgenres (chanid, starttime, relevance, genre) SELECT dd_v_program.chanid, DATE_ADD(starttime, INTERVAL channel.tmoffset MINUTE), relevance, class FROM dd_v_program, dd_genre, channel WHERE (dd_v_program.programid = dd_genre.programid) AND dd_v_program.chanid = channel.chanid |
---|
221 | 2007-01-24 00:25:03.577 Program table update complete. |
---|
222 | 2007-01-24 00:25:03.577 |
---|
223 | 2007-01-24 00:25:03.577 Checking day @ offset 2, date: Fri Jan 26 2007 |
---|
224 | 2007-01-24 00:25:03.584 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '1' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '2' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
225 | 2007-01-24 00:25:03.584 Checking program counts for day 1 |
---|
226 | 2007-01-24 00:25:03.584 chanid 1021 -> 6 programs |
---|
227 | 2007-01-24 00:25:03.585 chanid 1041 -> 5 programs |
---|
228 | 2007-01-24 00:25:03.585 chanid 1042 -> 5 programs |
---|
229 | 2007-01-24 00:25:03.585 chanid 1051 -> 7 programs |
---|
230 | 2007-01-24 00:25:03.585 chanid 1052 -> 7 programs |
---|
231 | 2007-01-24 00:25:03.585 chanid 1091 -> 4 programs |
---|
232 | 2007-01-24 00:25:03.585 chanid 1092 -> 4 programs |
---|
233 | 2007-01-24 00:25:03.585 chanid 1093 -> 4 programs |
---|
234 | 2007-01-24 00:25:03.585 chanid 1094 -> 4 programs |
---|
235 | 2007-01-24 00:25:03.585 chanid 1111 -> 7 programs |
---|
236 | 2007-01-24 00:25:03.585 chanid 1112 -> 7 programs |
---|
237 | 2007-01-24 00:25:03.585 chanid 1301 -> 6 programs |
---|
238 | 2007-01-24 00:25:03.592 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '2' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '3' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
239 | 2007-01-24 00:25:03.592 Checking program counts for day 2 |
---|
240 | 2007-01-24 00:25:03.592 chanid 1021 -> 6 programs |
---|
241 | 2007-01-24 00:25:03.592 chanid 1041 -> 5 programs |
---|
242 | 2007-01-24 00:25:03.592 chanid 1042 -> 5 programs |
---|
243 | 2007-01-24 00:25:03.592 chanid 1051 -> 5 programs |
---|
244 | 2007-01-24 00:25:03.592 chanid 1052 -> 5 programs |
---|
245 | 2007-01-24 00:25:03.592 chanid 1091 -> 5 programs |
---|
246 | 2007-01-24 00:25:03.592 chanid 1092 -> 5 programs |
---|
247 | 2007-01-24 00:25:03.593 chanid 1093 -> 5 programs |
---|
248 | 2007-01-24 00:25:03.593 chanid 1094 -> 5 programs |
---|
249 | 2007-01-24 00:25:03.593 chanid 1111 -> 6 programs |
---|
250 | 2007-01-24 00:25:03.593 chanid 1112 -> 6 programs |
---|
251 | 2007-01-24 00:25:03.593 chanid 1301 -> 6 programs |
---|
252 | 2007-01-24 00:25:03.593 Data is already present for Fri Jan 26 2007, skipping |
---|
253 | 2007-01-24 00:25:03.593 |
---|
254 | 2007-01-24 00:25:03.593 Checking day @ offset 3, date: Sat Jan 27 2007 |
---|
255 | 2007-01-24 00:25:03.599 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '2' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '3' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
256 | 2007-01-24 00:25:03.600 Checking program counts for day 2 |
---|
257 | 2007-01-24 00:25:03.600 chanid 1021 -> 6 programs |
---|
258 | 2007-01-24 00:25:03.600 chanid 1041 -> 5 programs |
---|
259 | 2007-01-24 00:25:03.600 chanid 1042 -> 5 programs |
---|
260 | 2007-01-24 00:25:03.600 chanid 1051 -> 5 programs |
---|
261 | 2007-01-24 00:25:03.600 chanid 1052 -> 5 programs |
---|
262 | 2007-01-24 00:25:03.600 chanid 1091 -> 5 programs |
---|
263 | 2007-01-24 00:25:03.600 chanid 1092 -> 5 programs |
---|
264 | 2007-01-24 00:25:03.600 chanid 1093 -> 5 programs |
---|
265 | 2007-01-24 00:25:03.600 chanid 1094 -> 5 programs |
---|
266 | 2007-01-24 00:25:03.600 chanid 1111 -> 6 programs |
---|
267 | 2007-01-24 00:25:03.601 chanid 1112 -> 6 programs |
---|
268 | 2007-01-24 00:25:03.601 chanid 1301 -> 6 programs |
---|
269 | 2007-01-24 00:25:03.609 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '3' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '4' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
270 | 2007-01-24 00:25:03.609 Checking program counts for day 3 |
---|
271 | 2007-01-24 00:25:03.610 chanid 1021 -> 5 programs |
---|
272 | 2007-01-24 00:25:03.610 chanid 1041 -> 4 programs |
---|
273 | 2007-01-24 00:25:03.610 chanid 1042 -> 4 programs |
---|
274 | 2007-01-24 00:25:03.610 chanid 1051 -> 4 programs |
---|
275 | 2007-01-24 00:25:03.610 chanid 1052 -> 4 programs |
---|
276 | 2007-01-24 00:25:03.610 chanid 1091 -> 4 programs |
---|
277 | 2007-01-24 00:25:03.610 chanid 1092 -> 4 programs |
---|
278 | 2007-01-24 00:25:03.610 chanid 1093 -> 4 programs |
---|
279 | 2007-01-24 00:25:03.610 chanid 1094 -> 4 programs |
---|
280 | 2007-01-24 00:25:03.610 chanid 1111 -> 5 programs |
---|
281 | 2007-01-24 00:25:03.610 chanid 1112 -> 5 programs |
---|
282 | 2007-01-24 00:25:03.610 chanid 1301 -> 3 programs |
---|
283 | 2007-01-24 00:25:03.610 Data is already present for Sat Jan 27 2007, skipping |
---|
284 | 2007-01-24 00:25:03.612 |
---|
285 | 2007-01-24 00:25:03.612 Checking day @ offset 4, date: Sun Jan 28 2007 |
---|
286 | 2007-01-24 00:25:03.618 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '3' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '4' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
287 | 2007-01-24 00:25:03.618 Checking program counts for day 3 |
---|
288 | 2007-01-24 00:25:03.618 chanid 1021 -> 5 programs |
---|
289 | 2007-01-24 00:25:03.619 chanid 1041 -> 4 programs |
---|
290 | 2007-01-24 00:25:03.619 chanid 1042 -> 4 programs |
---|
291 | 2007-01-24 00:25:03.619 chanid 1051 -> 4 programs |
---|
292 | 2007-01-24 00:25:03.619 chanid 1052 -> 4 programs |
---|
293 | 2007-01-24 00:25:03.619 chanid 1091 -> 4 programs |
---|
294 | 2007-01-24 00:25:03.619 chanid 1092 -> 4 programs |
---|
295 | 2007-01-24 00:25:03.619 chanid 1093 -> 4 programs |
---|
296 | 2007-01-24 00:25:03.619 chanid 1094 -> 4 programs |
---|
297 | 2007-01-24 00:25:03.619 chanid 1111 -> 5 programs |
---|
298 | 2007-01-24 00:25:03.619 chanid 1112 -> 5 programs |
---|
299 | 2007-01-24 00:25:03.619 chanid 1301 -> 3 programs |
---|
300 | 2007-01-24 00:25:03.625 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '4' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '5' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
301 | 2007-01-24 00:25:03.626 Checking program counts for day 4 |
---|
302 | 2007-01-24 00:25:03.626 chanid 1021 -> 6 programs |
---|
303 | 2007-01-24 00:25:03.626 chanid 1041 -> 5 programs |
---|
304 | 2007-01-24 00:25:03.626 chanid 1042 -> 5 programs |
---|
305 | 2007-01-24 00:25:03.626 chanid 1051 -> 6 programs |
---|
306 | 2007-01-24 00:25:03.626 chanid 1052 -> 6 programs |
---|
307 | 2007-01-24 00:25:03.627 chanid 1091 -> 3 programs |
---|
308 | 2007-01-24 00:25:03.627 chanid 1092 -> 3 programs |
---|
309 | 2007-01-24 00:25:03.627 chanid 1093 -> 3 programs |
---|
310 | 2007-01-24 00:25:03.627 chanid 1094 -> 3 programs |
---|
311 | 2007-01-24 00:25:03.627 chanid 1111 -> 7 programs |
---|
312 | 2007-01-24 00:25:03.627 chanid 1112 -> 7 programs |
---|
313 | 2007-01-24 00:25:03.627 chanid 1301 -> 5 programs |
---|
314 | 2007-01-24 00:25:03.627 Data is already present for Sun Jan 28 2007, skipping |
---|
315 | 2007-01-24 00:25:03.627 |
---|
316 | 2007-01-24 00:25:03.627 Checking day @ offset 5, date: Mon Jan 29 2007 |
---|
317 | 2007-01-24 00:25:03.634 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '4' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '5' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
318 | 2007-01-24 00:25:03.634 Checking program counts for day 4 |
---|
319 | 2007-01-24 00:25:03.634 chanid 1021 -> 6 programs |
---|
320 | 2007-01-24 00:25:03.634 chanid 1041 -> 5 programs |
---|
321 | 2007-01-24 00:25:03.634 chanid 1042 -> 5 programs |
---|
322 | 2007-01-24 00:25:03.634 chanid 1051 -> 6 programs |
---|
323 | 2007-01-24 00:25:03.634 chanid 1052 -> 6 programs |
---|
324 | 2007-01-24 00:25:03.634 chanid 1091 -> 3 programs |
---|
325 | 2007-01-24 00:25:03.634 chanid 1092 -> 3 programs |
---|
326 | 2007-01-24 00:25:03.635 chanid 1093 -> 3 programs |
---|
327 | 2007-01-24 00:25:03.635 chanid 1094 -> 3 programs |
---|
328 | 2007-01-24 00:25:03.635 chanid 1111 -> 7 programs |
---|
329 | 2007-01-24 00:25:03.635 chanid 1112 -> 7 programs |
---|
330 | 2007-01-24 00:25:03.635 chanid 1301 -> 5 programs |
---|
331 | 2007-01-24 00:25:03.641 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '5' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '6' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
332 | 2007-01-24 00:25:03.642 Checking program counts for day 5 |
---|
333 | 2007-01-24 00:25:03.642 chanid 1021 -> 6 programs |
---|
334 | 2007-01-24 00:25:03.642 chanid 1041 -> 6 programs |
---|
335 | 2007-01-24 00:25:03.642 chanid 1042 -> 6 programs |
---|
336 | 2007-01-24 00:25:03.642 chanid 1051 -> 5 programs |
---|
337 | 2007-01-24 00:25:03.642 chanid 1052 -> 5 programs |
---|
338 | 2007-01-24 00:25:03.642 chanid 1091 -> 3 programs |
---|
339 | 2007-01-24 00:25:03.642 chanid 1092 -> 3 programs |
---|
340 | 2007-01-24 00:25:03.642 chanid 1093 -> 3 programs |
---|
341 | 2007-01-24 00:25:03.642 chanid 1094 -> 3 programs |
---|
342 | 2007-01-24 00:25:03.642 chanid 1111 -> 8 programs |
---|
343 | 2007-01-24 00:25:03.642 chanid 1112 -> 8 programs |
---|
344 | 2007-01-24 00:25:03.643 chanid 1301 -> 6 programs |
---|
345 | 2007-01-24 00:25:03.643 Data is already present for Mon Jan 29 2007, skipping |
---|
346 | 2007-01-24 00:25:03.643 |
---|
347 | 2007-01-24 00:25:03.643 Checking day @ offset 6, date: Tue Jan 30 2007 |
---|
348 | 2007-01-24 00:25:03.649 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '5' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '6' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
349 | 2007-01-24 00:25:03.649 Checking program counts for day 5 |
---|
350 | 2007-01-24 00:25:03.649 chanid 1021 -> 6 programs |
---|
351 | 2007-01-24 00:25:03.649 chanid 1041 -> 6 programs |
---|
352 | 2007-01-24 00:25:03.650 chanid 1042 -> 6 programs |
---|
353 | 2007-01-24 00:25:03.650 chanid 1051 -> 5 programs |
---|
354 | 2007-01-24 00:25:03.650 chanid 1052 -> 5 programs |
---|
355 | 2007-01-24 00:25:03.650 chanid 1091 -> 3 programs |
---|
356 | 2007-01-24 00:25:03.650 chanid 1092 -> 3 programs |
---|
357 | 2007-01-24 00:25:03.650 chanid 1093 -> 3 programs |
---|
358 | 2007-01-24 00:25:03.650 chanid 1094 -> 3 programs |
---|
359 | 2007-01-24 00:25:03.650 chanid 1111 -> 8 programs |
---|
360 | 2007-01-24 00:25:03.651 chanid 1112 -> 8 programs |
---|
361 | 2007-01-24 00:25:03.651 chanid 1301 -> 6 programs |
---|
362 | 2007-01-24 00:25:03.657 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '6' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '7' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
363 | 2007-01-24 00:25:03.657 Checking program counts for day 6 |
---|
364 | 2007-01-24 00:25:03.657 chanid 1021 -> 6 programs |
---|
365 | 2007-01-24 00:25:03.657 chanid 1041 -> 5 programs |
---|
366 | 2007-01-24 00:25:03.657 chanid 1042 -> 5 programs |
---|
367 | 2007-01-24 00:25:03.657 chanid 1051 -> 5 programs |
---|
368 | 2007-01-24 00:25:03.658 chanid 1052 -> 5 programs |
---|
369 | 2007-01-24 00:25:03.658 chanid 1091 -> 4 programs |
---|
370 | 2007-01-24 00:25:03.658 chanid 1092 -> 4 programs |
---|
371 | 2007-01-24 00:25:03.658 chanid 1093 -> 4 programs |
---|
372 | 2007-01-24 00:25:03.658 chanid 1094 -> 4 programs |
---|
373 | 2007-01-24 00:25:03.658 chanid 1111 -> 7 programs |
---|
374 | 2007-01-24 00:25:03.658 chanid 1112 -> 7 programs |
---|
375 | 2007-01-24 00:25:03.658 chanid 1301 -> 7 programs |
---|
376 | 2007-01-24 00:25:03.658 Data is already present for Tue Jan 30 2007, skipping |
---|
377 | 2007-01-24 00:25:03.658 |
---|
378 | 2007-01-24 00:25:03.658 Checking day @ offset 7, date: Wed Jan 31 2007 |
---|
379 | 2007-01-24 00:25:03.665 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '6' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '7' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
380 | 2007-01-24 00:25:03.665 Checking program counts for day 6 |
---|
381 | 2007-01-24 00:25:03.665 chanid 1021 -> 6 programs |
---|
382 | 2007-01-24 00:25:03.665 chanid 1041 -> 5 programs |
---|
383 | 2007-01-24 00:25:03.665 chanid 1042 -> 5 programs |
---|
384 | 2007-01-24 00:25:03.666 chanid 1051 -> 5 programs |
---|
385 | 2007-01-24 00:25:03.666 chanid 1052 -> 5 programs |
---|
386 | 2007-01-24 00:25:03.666 chanid 1091 -> 4 programs |
---|
387 | 2007-01-24 00:25:03.666 chanid 1092 -> 4 programs |
---|
388 | 2007-01-24 00:25:03.666 chanid 1093 -> 4 programs |
---|
389 | 2007-01-24 00:25:03.666 chanid 1094 -> 4 programs |
---|
390 | 2007-01-24 00:25:03.666 chanid 1111 -> 7 programs |
---|
391 | 2007-01-24 00:25:03.666 chanid 1112 -> 7 programs |
---|
392 | 2007-01-24 00:25:03.666 chanid 1301 -> 7 programs |
---|
393 | 2007-01-24 00:25:03.672 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '7' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '8' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
394 | 2007-01-24 00:25:03.672 Checking program counts for day 7 |
---|
395 | 2007-01-24 00:25:03.672 chanid 1021 -> 6 programs |
---|
396 | 2007-01-24 00:25:03.673 chanid 1041 -> 5 programs |
---|
397 | 2007-01-24 00:25:03.673 chanid 1042 -> 5 programs |
---|
398 | 2007-01-24 00:25:03.673 chanid 1051 -> 5 programs |
---|
399 | 2007-01-24 00:25:03.673 chanid 1052 -> 5 programs |
---|
400 | 2007-01-24 00:25:03.673 chanid 1091 -> 3 programs |
---|
401 | 2007-01-24 00:25:03.673 chanid 1092 -> 3 programs |
---|
402 | 2007-01-24 00:25:03.673 chanid 1093 -> 3 programs |
---|
403 | 2007-01-24 00:25:03.673 chanid 1094 -> 3 programs |
---|
404 | 2007-01-24 00:25:03.673 chanid 1111 -> 7 programs |
---|
405 | 2007-01-24 00:25:03.673 chanid 1112 -> 7 programs |
---|
406 | 2007-01-24 00:25:03.673 chanid 1301 -> 7 programs |
---|
407 | 2007-01-24 00:25:03.673 Data is already present for Wed Jan 31 2007, skipping |
---|
408 | 2007-01-24 00:25:03.674 |
---|
409 | 2007-01-24 00:25:03.674 Checking day @ offset 8, date: Thu Feb 1 2007 |
---|
410 | 2007-01-24 00:25:03.680 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '7' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '8' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
411 | 2007-01-24 00:25:03.680 Checking program counts for day 7 |
---|
412 | 2007-01-24 00:25:03.681 chanid 1021 -> 6 programs |
---|
413 | 2007-01-24 00:25:03.681 chanid 1041 -> 5 programs |
---|
414 | 2007-01-24 00:25:03.681 chanid 1042 -> 5 programs |
---|
415 | 2007-01-24 00:25:03.681 chanid 1051 -> 5 programs |
---|
416 | 2007-01-24 00:25:03.681 chanid 1052 -> 5 programs |
---|
417 | 2007-01-24 00:25:03.681 chanid 1091 -> 3 programs |
---|
418 | 2007-01-24 00:25:03.681 chanid 1092 -> 3 programs |
---|
419 | 2007-01-24 00:25:03.681 chanid 1093 -> 3 programs |
---|
420 | 2007-01-24 00:25:03.681 chanid 1094 -> 3 programs |
---|
421 | 2007-01-24 00:25:03.681 chanid 1111 -> 7 programs |
---|
422 | 2007-01-24 00:25:03.681 chanid 1112 -> 7 programs |
---|
423 | 2007-01-24 00:25:03.681 chanid 1301 -> 7 programs |
---|
424 | 2007-01-24 00:25:03.688 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '8' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '9' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
425 | 2007-01-24 00:25:03.688 Checking program counts for day 8 |
---|
426 | 2007-01-24 00:25:03.688 chanid 1021 -> 6 programs |
---|
427 | 2007-01-24 00:25:03.688 chanid 1041 -> 5 programs |
---|
428 | 2007-01-24 00:25:03.688 chanid 1042 -> 5 programs |
---|
429 | 2007-01-24 00:25:03.688 chanid 1051 -> 6 programs |
---|
430 | 2007-01-24 00:25:03.688 chanid 1052 -> 6 programs |
---|
431 | 2007-01-24 00:25:03.688 chanid 1091 -> 4 programs |
---|
432 | 2007-01-24 00:25:03.689 chanid 1092 -> 4 programs |
---|
433 | 2007-01-24 00:25:03.689 chanid 1093 -> 4 programs |
---|
434 | 2007-01-24 00:25:03.689 chanid 1094 -> 4 programs |
---|
435 | 2007-01-24 00:25:03.689 chanid 1111 -> 7 programs |
---|
436 | 2007-01-24 00:25:03.689 chanid 1112 -> 7 programs |
---|
437 | 2007-01-24 00:25:03.689 chanid 1301 -> 6 programs |
---|
438 | 2007-01-24 00:25:03.689 Data is already present for Thu Feb 1 2007, skipping |
---|
439 | 2007-01-24 00:25:03.689 |
---|
440 | 2007-01-24 00:25:03.689 Checking day @ offset 9, date: Fri Feb 2 2007 |
---|
441 | 2007-01-24 00:25:03.695 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '8' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '9' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
442 | 2007-01-24 00:25:03.695 Checking program counts for day 8 |
---|
443 | 2007-01-24 00:25:03.696 chanid 1021 -> 6 programs |
---|
444 | 2007-01-24 00:25:03.696 chanid 1041 -> 5 programs |
---|
445 | 2007-01-24 00:25:03.696 chanid 1042 -> 5 programs |
---|
446 | 2007-01-24 00:25:03.696 chanid 1051 -> 6 programs |
---|
447 | 2007-01-24 00:25:03.696 chanid 1052 -> 6 programs |
---|
448 | 2007-01-24 00:25:03.696 chanid 1091 -> 4 programs |
---|
449 | 2007-01-24 00:25:03.696 chanid 1092 -> 4 programs |
---|
450 | 2007-01-24 00:25:03.696 chanid 1093 -> 4 programs |
---|
451 | 2007-01-24 00:25:03.696 chanid 1094 -> 4 programs |
---|
452 | 2007-01-24 00:25:03.696 chanid 1111 -> 7 programs |
---|
453 | 2007-01-24 00:25:03.696 chanid 1112 -> 7 programs |
---|
454 | 2007-01-24 00:25:03.696 chanid 1301 -> 6 programs |
---|
455 | 2007-01-24 00:25:03.703 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '9' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '10' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
456 | 2007-01-24 00:25:03.703 Checking program counts for day 9 |
---|
457 | 2007-01-24 00:25:03.703 chanid 1021 -> 6 programs |
---|
458 | 2007-01-24 00:25:03.703 chanid 1041 -> 5 programs |
---|
459 | 2007-01-24 00:25:03.703 chanid 1042 -> 5 programs |
---|
460 | 2007-01-24 00:25:03.703 chanid 1051 -> 5 programs |
---|
461 | 2007-01-24 00:25:03.704 chanid 1052 -> 5 programs |
---|
462 | 2007-01-24 00:25:03.704 chanid 1091 -> 4 programs |
---|
463 | 2007-01-24 00:25:03.704 chanid 1092 -> 4 programs |
---|
464 | 2007-01-24 00:25:03.704 chanid 1093 -> 4 programs |
---|
465 | 2007-01-24 00:25:03.704 chanid 1094 -> 4 programs |
---|
466 | 2007-01-24 00:25:03.704 chanid 1111 -> 6 programs |
---|
467 | 2007-01-24 00:25:03.704 chanid 1112 -> 6 programs |
---|
468 | 2007-01-24 00:25:03.704 chanid 1301 -> 6 programs |
---|
469 | 2007-01-24 00:25:03.704 Data is already present for Fri Feb 2 2007, skipping |
---|
470 | 2007-01-24 00:25:03.704 |
---|
471 | 2007-01-24 00:25:03.704 Checking day @ offset 10, date: Sat Feb 3 2007 |
---|
472 | 2007-01-24 00:25:03.712 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '9' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '10' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
473 | 2007-01-24 00:25:03.712 Checking program counts for day 9 |
---|
474 | 2007-01-24 00:25:03.712 chanid 1021 -> 6 programs |
---|
475 | 2007-01-24 00:25:03.712 chanid 1041 -> 5 programs |
---|
476 | 2007-01-24 00:25:03.712 chanid 1042 -> 5 programs |
---|
477 | 2007-01-24 00:25:03.712 chanid 1051 -> 5 programs |
---|
478 | 2007-01-24 00:25:03.712 chanid 1052 -> 5 programs |
---|
479 | 2007-01-24 00:25:03.713 chanid 1091 -> 4 programs |
---|
480 | 2007-01-24 00:25:03.713 chanid 1092 -> 4 programs |
---|
481 | 2007-01-24 00:25:03.713 chanid 1093 -> 4 programs |
---|
482 | 2007-01-24 00:25:03.713 chanid 1094 -> 4 programs |
---|
483 | 2007-01-24 00:25:03.713 chanid 1111 -> 6 programs |
---|
484 | 2007-01-24 00:25:03.713 chanid 1112 -> 6 programs |
---|
485 | 2007-01-24 00:25:03.713 chanid 1301 -> 6 programs |
---|
486 | 2007-01-24 00:25:03.719 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '10' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '11' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
487 | 2007-01-24 00:25:03.719 Checking program counts for day 10 |
---|
488 | 2007-01-24 00:25:03.719 chanid 1021 -> 5 programs |
---|
489 | 2007-01-24 00:25:03.719 chanid 1041 -> 5 programs |
---|
490 | 2007-01-24 00:25:03.719 chanid 1042 -> 5 programs |
---|
491 | 2007-01-24 00:25:03.720 chanid 1051 -> 4 programs |
---|
492 | 2007-01-24 00:25:03.720 chanid 1052 -> 4 programs |
---|
493 | 2007-01-24 00:25:03.720 chanid 1091 -> 4 programs |
---|
494 | 2007-01-24 00:25:03.720 chanid 1092 -> 4 programs |
---|
495 | 2007-01-24 00:25:03.720 chanid 1093 -> 4 programs |
---|
496 | 2007-01-24 00:25:03.720 chanid 1094 -> 4 programs |
---|
497 | 2007-01-24 00:25:03.720 chanid 1111 -> 5 programs |
---|
498 | 2007-01-24 00:25:03.720 chanid 1112 -> 5 programs |
---|
499 | 2007-01-24 00:25:03.720 chanid 1301 -> 4 programs |
---|
500 | 2007-01-24 00:25:03.720 Data is already present for Sat Feb 3 2007, skipping |
---|
501 | 2007-01-24 00:25:03.720 |
---|
502 | 2007-01-24 00:25:03.720 Checking day @ offset 11, date: Sun Feb 4 2007 |
---|
503 | 2007-01-24 00:25:03.727 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '10' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '11' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
504 | 2007-01-24 00:25:03.727 Checking program counts for day 10 |
---|
505 | 2007-01-24 00:25:03.727 chanid 1021 -> 5 programs |
---|
506 | 2007-01-24 00:25:03.727 chanid 1041 -> 5 programs |
---|
507 | 2007-01-24 00:25:03.727 chanid 1042 -> 5 programs |
---|
508 | 2007-01-24 00:25:03.727 chanid 1051 -> 4 programs |
---|
509 | 2007-01-24 00:25:03.728 chanid 1052 -> 4 programs |
---|
510 | 2007-01-24 00:25:03.728 chanid 1091 -> 4 programs |
---|
511 | 2007-01-24 00:25:03.728 chanid 1092 -> 4 programs |
---|
512 | 2007-01-24 00:25:03.728 chanid 1093 -> 4 programs |
---|
513 | 2007-01-24 00:25:03.728 chanid 1094 -> 4 programs |
---|
514 | 2007-01-24 00:25:03.728 chanid 1111 -> 5 programs |
---|
515 | 2007-01-24 00:25:03.728 chanid 1112 -> 5 programs |
---|
516 | 2007-01-24 00:25:03.728 chanid 1301 -> 4 programs |
---|
517 | 2007-01-24 00:25:03.735 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '11' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '12' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
518 | 2007-01-24 00:25:03.735 Checking program counts for day 11 |
---|
519 | 2007-01-24 00:25:03.735 chanid 1021 -> 4 programs |
---|
520 | 2007-01-24 00:25:03.735 chanid 1041 -> 5 programs |
---|
521 | 2007-01-24 00:25:03.735 chanid 1042 -> 5 programs |
---|
522 | 2007-01-24 00:25:03.735 chanid 1051 -> 5 programs |
---|
523 | 2007-01-24 00:25:03.735 chanid 1052 -> 5 programs |
---|
524 | 2007-01-24 00:25:03.735 chanid 1091 -> 4 programs |
---|
525 | 2007-01-24 00:25:03.735 chanid 1092 -> 4 programs |
---|
526 | 2007-01-24 00:25:03.735 chanid 1093 -> 4 programs |
---|
527 | 2007-01-24 00:25:03.735 chanid 1094 -> 4 programs |
---|
528 | 2007-01-24 00:25:03.736 chanid 1111 -> 7 programs |
---|
529 | 2007-01-24 00:25:03.736 chanid 1112 -> 7 programs |
---|
530 | 2007-01-24 00:25:03.736 chanid 1301 -> 4 programs |
---|
531 | 2007-01-24 00:25:03.736 Data is already present for Sun Feb 4 2007, skipping |
---|
532 | 2007-01-24 00:25:03.736 |
---|
533 | 2007-01-24 00:25:03.736 Checking day @ offset 12, date: Mon Feb 5 2007 |
---|
534 | 2007-01-24 00:25:03.742 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '11' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '12' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
535 | 2007-01-24 00:25:03.742 Checking program counts for day 11 |
---|
536 | 2007-01-24 00:25:03.742 chanid 1021 -> 4 programs |
---|
537 | 2007-01-24 00:25:03.743 chanid 1041 -> 5 programs |
---|
538 | 2007-01-24 00:25:03.743 chanid 1042 -> 5 programs |
---|
539 | 2007-01-24 00:25:03.743 chanid 1051 -> 5 programs |
---|
540 | 2007-01-24 00:25:03.743 chanid 1052 -> 5 programs |
---|
541 | 2007-01-24 00:25:03.743 chanid 1091 -> 4 programs |
---|
542 | 2007-01-24 00:25:03.743 chanid 1092 -> 4 programs |
---|
543 | 2007-01-24 00:25:03.743 chanid 1093 -> 4 programs |
---|
544 | 2007-01-24 00:25:03.743 chanid 1094 -> 4 programs |
---|
545 | 2007-01-24 00:25:03.743 chanid 1111 -> 7 programs |
---|
546 | 2007-01-24 00:25:03.743 chanid 1112 -> 7 programs |
---|
547 | 2007-01-24 00:25:03.743 chanid 1301 -> 4 programs |
---|
548 | 2007-01-24 00:25:03.750 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '12' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '13' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
549 | 2007-01-24 00:25:03.750 Checking program counts for day 12 |
---|
550 | 2007-01-24 00:25:03.750 chanid 1021 -> 6 programs |
---|
551 | 2007-01-24 00:25:03.750 chanid 1041 -> 6 programs |
---|
552 | 2007-01-24 00:25:03.750 chanid 1042 -> 6 programs |
---|
553 | 2007-01-24 00:25:03.750 chanid 1051 -> 5 programs |
---|
554 | 2007-01-24 00:25:03.750 chanid 1052 -> 5 programs |
---|
555 | 2007-01-24 00:25:03.750 chanid 1091 -> 4 programs |
---|
556 | 2007-01-24 00:25:03.751 chanid 1092 -> 4 programs |
---|
557 | 2007-01-24 00:25:03.751 chanid 1093 -> 4 programs |
---|
558 | 2007-01-24 00:25:03.751 chanid 1094 -> 4 programs |
---|
559 | 2007-01-24 00:25:03.751 chanid 1111 -> 8 programs |
---|
560 | 2007-01-24 00:25:03.751 chanid 1112 -> 8 programs |
---|
561 | 2007-01-24 00:25:03.751 chanid 1301 -> 6 programs |
---|
562 | 2007-01-24 00:25:03.751 Data is already present for Mon Feb 5 2007, skipping |
---|
563 | 2007-01-24 00:25:03.751 |
---|
564 | 2007-01-24 00:25:03.751 Checking day @ offset 13, date: Tue Feb 6 2007 |
---|
565 | 2007-01-24 00:25:03.757 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '12' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '13' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
566 | 2007-01-24 00:25:03.757 Checking program counts for day 12 |
---|
567 | 2007-01-24 00:25:03.757 chanid 1021 -> 6 programs |
---|
568 | 2007-01-24 00:25:03.758 chanid 1041 -> 6 programs |
---|
569 | 2007-01-24 00:25:03.763 chanid 1042 -> 6 programs |
---|
570 | 2007-01-24 00:25:03.763 chanid 1051 -> 5 programs |
---|
571 | 2007-01-24 00:25:03.763 chanid 1052 -> 5 programs |
---|
572 | 2007-01-24 00:25:03.763 chanid 1091 -> 4 programs |
---|
573 | 2007-01-24 00:25:03.763 chanid 1092 -> 4 programs |
---|
574 | 2007-01-24 00:25:03.764 chanid 1093 -> 4 programs |
---|
575 | 2007-01-24 00:25:03.764 chanid 1094 -> 4 programs |
---|
576 | 2007-01-24 00:25:03.764 chanid 1111 -> 8 programs |
---|
577 | 2007-01-24 00:25:03.764 chanid 1112 -> 8 programs |
---|
578 | 2007-01-24 00:25:03.764 chanid 1301 -> 6 programs |
---|
579 | 2007-01-24 00:25:03.771 MSqlQuery: SELECT c.chanid, COUNT(p.starttime) FROM channel c LEFT JOIN program p ON c.chanid = p.chanid AND starttime >= DATE_ADD(DATE_ADD(CURRENT_DATE(), INTERVAL '13' DAY), INTERVAL '20' HOUR) AND starttime < DATE_ADD(CURRENT_DATE(), INTERVAL '14' DAY) WHERE c.sourceid = 1 AND c.xmltvid != '' GROUP BY c.chanid; |
---|
580 | 2007-01-24 00:25:03.771 Checking program counts for day 13 |
---|
581 | 2007-01-24 00:25:03.771 chanid 1021 -> 0 programs |
---|
582 | 2007-01-24 00:25:03.772 chanid 1041 -> 0 programs |
---|
583 | 2007-01-24 00:25:03.772 chanid 1042 -> 0 programs |
---|
584 | 2007-01-24 00:25:03.772 chanid 1051 -> 0 programs |
---|
585 | 2007-01-24 00:25:03.772 chanid 1052 -> 0 programs |
---|
586 | 2007-01-24 00:25:03.772 chanid 1091 -> 0 programs |
---|
587 | 2007-01-24 00:25:03.772 chanid 1092 -> 0 programs |
---|
588 | 2007-01-24 00:25:03.772 chanid 1093 -> 0 programs |
---|
589 | 2007-01-24 00:25:03.772 chanid 1094 -> 0 programs |
---|
590 | 2007-01-24 00:25:03.772 chanid 1111 -> 0 programs |
---|
591 | 2007-01-24 00:25:03.772 chanid 1112 -> 0 programs |
---|
592 | 2007-01-24 00:25:03.772 chanid 1301 -> 0 programs |
---|
593 | 2007-01-24 00:25:03.772 Data refresh needed because only 0 out of 12 channels have at least one program listed for day @ offset 13 from 8PM - midnight. Previous day had 12 channels with data in that time period. |
---|
594 | 2007-01-24 00:25:03.773 Refreshing data for Tue Feb 6 2007 |
---|
595 | 2007-01-24 00:25:03.773 MSqlQuery: UPDATE settings SET data ='2007-01-24 00:25' WHERE value='mythfilldatabaseLastRunStart' |
---|
596 | 2007-01-24 00:25:03.773 Retrieving datadirect data. |
---|
597 | 2007-01-24 00:25:03.773 Grabbing data for Wed Jan 24 2007 offset 13 |
---|
598 | 2007-01-24 00:25:03.773 From Tue Feb 6 06:00:00 2007 to Wed Feb 7 06:00:00 2007 (UTC) |
---|
599 | 2007-01-24 00:25:03.774 Grabbing listing data |
---|
600 | 2007-01-24 00:25:05.773 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_genre ( programid char(12) NOT NULL, class char(30), relevance char(1), INDEX progidx (programid)); |
---|
601 | 2007-01-24 00:25:05.774 MSqlQuery: TRUNCATE TABLE dd_genre; |
---|
602 | 2007-01-24 00:25:05.774 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_lineup ( lineupid char(100), name char(42), type char(20), postal char(6), device char(30) ); |
---|
603 | 2007-01-24 00:25:05.775 MSqlQuery: TRUNCATE TABLE dd_lineup; |
---|
604 | 2007-01-24 00:25:05.776 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_lineupmap ( lineupid char(100), stationid char(12), channel char(5), channelMinor char(3) ); |
---|
605 | 2007-01-24 00:25:05.777 MSqlQuery: TRUNCATE TABLE dd_lineupmap; |
---|
606 | 2007-01-24 00:25:05.777 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_productioncrew ( programid char(12), role char(30), givenname char(20), surname char(20), fullname char(41), INDEX progidx (programid), INDEX nameidx (fullname)); |
---|
607 | 2007-01-24 00:25:05.778 MSqlQuery: TRUNCATE TABLE dd_productioncrew; |
---|
608 | 2007-01-24 00:25:05.779 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_program ( programid char(12) NOT NULL, seriesid char(12), title varchar(120), subtitle varchar(150), description text, mpaarating char(5), starrating char(5), runtime time, year char(4), showtype char(30), category_type char(64), colorcode char(20), originalairdate date, syndicatedepisodenumber char(20), stars float unsigned, PRIMARY KEY (programid)); |
---|
609 | 2007-01-24 00:25:05.781 MSqlQuery: TRUNCATE TABLE dd_program; |
---|
610 | 2007-01-24 00:25:05.782 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_schedule ( programid char(12), stationid char(12), scheduletime datetime, duration time, isrepeat bool, stereo bool, subtitled bool, hdtv bool, closecaptioned bool, tvrating char(5), partnumber int, parttotal int, endtime datetime, INDEX progidx (programid) ); |
---|
611 | 2007-01-24 00:25:05.783 MSqlQuery: TRUNCATE TABLE dd_schedule; |
---|
612 | 2007-01-24 00:25:05.784 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_station ( stationid char(12), callsign char(10), stationname varchar(40), affiliate varchar(25), fccchannelnumber char(15) ); |
---|
613 | 2007-01-24 00:25:05.785 MSqlQuery: TRUNCATE TABLE dd_station; |
---|
614 | 2007-01-24 00:25:05.785 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_v_program ( chanid int unsigned NOT NULL, starttime datetime NOT NULL, endtime datetime, title varchar(128), subtitle varchar(128), description text, category varchar(64), category_type varchar(64), airdate year, stars float unsigned, previouslyshown tinyint, isrepeat bool, stereo bool, subtitled bool, hdtv bool, closecaptioned bool, partnumber int, parttotal int, seriesid char(12), originalairdate date, showtype varchar(30), colorcode varchar(20), syndicatedepisodenumber varchar(20), programid char(12), tvrating char(5), mpaarating char(5), INDEX progidx (programid)); |
---|
615 | 2007-01-24 00:25:05.787 MSqlQuery: TRUNCATE TABLE dd_v_program; |
---|
616 | 2007-01-24 00:25:05.788 MSqlQuery: CREATE TEMPORARY TABLE IF NOT EXISTS dd_v_station ( stationid char(12), callsign char(10), stationname varchar(40), affiliate varchar(25), fccchannelnumber char(15), channel char(5), channelMinor char(3) ); |
---|
617 | 2007-01-24 00:25:05.789 MSqlQuery: TRUNCATE TABLE dd_v_station; |
---|
618 | 2007-01-24 00:25:05.790 DataDirect: Your subscription expires on 03/05/07 18:16:22 |
---|
619 | 2007-01-24 00:25:05.791 MSqlQuery: UPDATE settings SET data ='Your subscription expires on 03/05/07 18:16:22' WHERE value='DataDirectMessage' |
---|
620 | 2007-01-24 00:25:05.792 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('21237', 'KDNLDT', 'KDNLDT (KDNL-DT)', 'ABC Affiliate', '31') |
---|
621 | 2007-01-24 00:25:05.793 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('32057', 'KETCDT', 'KETCDT (KETC-DT)', 'PBS Affiliate', '39') |
---|
622 | 2007-01-24 00:25:05.794 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('20506', 'KMOVDT', 'KMOVDT (KMOV-DT)', 'CBS Affiliate', '56') |
---|
623 | 2007-01-24 00:25:05.794 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('34808', 'KPLRDT', 'KPLRDT (KPLR-DT)', 'CW Affiliate', '26') |
---|
624 | 2007-01-24 00:25:05.795 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('20513', 'KSDKDT', 'KSDKDT (KSDK-DT)', 'NBC Affiliate', '35') |
---|
625 | 2007-01-24 00:25:05.796 MSqlQuery: INSERT INTO dd_station ( stationid, callsign, stationname, affiliate, fccchannelnumber) VALUES ('21300', 'KTVIDT', 'KTVIDT (KTVI-DT)', 'Fox Affiliate', '43') |
---|
626 | 2007-01-24 00:25:05.797 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '20506', '4', '1') |
---|
627 | 2007-01-24 00:25:05.798 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '20513', '5', '1') |
---|
628 | 2007-01-24 00:25:05.798 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '21237', '30', '1') |
---|
629 | 2007-01-24 00:25:05.799 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '21300', '2', '1') |
---|
630 | 2007-01-24 00:25:05.800 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '32057', '9', '1') |
---|
631 | 2007-01-24 00:25:05.801 MSqlQuery: INSERT INTO dd_lineupmap ( lineupid, stationid, channel, channelMinor) VALUES ('PC:63119', '34808', '11', '1') |
---|
632 | 2007-01-24 00:25:05.802 MSqlQuery: INSERT INTO dd_lineup ( lineupid, name, type, device, postal) VALUES ('PC:63119', 'Local Broadcast Listings', 'LocalBroadcast', NULL, '63119') |
---|
633 | productioncrew ( programid, role, givenname, surname, fullname) VALUES ('MV0507670000', 'Executive_Producer', 'David L.', 'Wolper', 'David L. Wolper') |
---|
634 | |
---|
635 | 2007-01-24 00:25:12.404 MSqlQuery: SELECT MAX(starttime),title,subtitle,description FROM program WHERE programid = '' GROUP BY title,subtitle,description; |
---|
636 | 2007-01-24 00:25:12.404 Found 1447 |
---|
637 | 2007-01-24 00:25:12.428 MSqlQuery: SELECT count(previouslyshown) FROM program WHERE previouslyshown = 1; |
---|
638 | 2007-01-24 00:25:12.428 MSqlQuery: UPDATE settings SET data = '1' WHERE value = 'HaveRepeats'; |
---|
639 | 2007-01-24 00:25:12.429 MSqlQuery: SELECT data FROM settings WHERE value = 'MythFillGrabberSuggestsTime' AND hostname = 'PVR' ; |
---|
640 | 2007-01-24 00:25:12.430 MSqlQuery: SELECT data FROM settings WHERE value = 'MythFillGrabberSuggestsTime' AND hostname IS NULL; |
---|
641 | 2007-01-24 00:25:12.430 Grabbing next suggested grabbing time |
---|
642 | 2007-01-24 00:25:12.864 DataDirect: BlockedTime is: 2007-01-24T00:25:12 |
---|
643 | 2007-01-24 00:25:12.865 DataDirect: NextSuggestedTime is: 2007-01-24T14:09:59 |
---|
644 | 2007-01-24 00:25:12.866 MSqlQuery: SELECT data FROM settings WHERE value = 'MythFillPeriod' AND hostname = 'PVR' ; |
---|
645 | 2007-01-24 00:25:12.867 MSqlQuery: SELECT data FROM settings WHERE value = 'MythFillPeriod' AND hostname IS NULL; |
---|
646 | 2007-01-24 00:25:12.868 MSqlQuery: UPDATE settings SET data = '14' WHERE value = 'MythFillMinHour'; |
---|
647 | 2007-01-24 00:25:12.869 MSqlQuery: UPDATE settings SET data = '16' WHERE value = 'MythFillMaxHour'; |
---|
648 | 2007-01-24 00:25:12.870 MSqlQuery: UPDATE settings SET data = '2007-01-24T14:09:59' WHERE value = 'MythFillSuggestedRunTime'; |
---|
649 | 2007-01-24 00:25:12.870 |
---|
650 | =============================================================== |
---|
651 | | Attempting to contact the master backend for rescheduling. | |
---|
652 | | If the master is not running, rescheduling will happen when | |
---|
653 | | the master backend is restarted. | |
---|
654 | =============================================================== |
---|
655 | 2007-01-24 00:25:12.871 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname = 'PVR' ; |
---|
656 | 2007-01-24 00:25:12.872 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname IS NULL; |
---|
657 | 2007-01-24 00:25:12.873 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname = 'PVR' ; |
---|
658 | 2007-01-24 00:25:12.873 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname IS NULL; |
---|
659 | 2007-01-24 00:25:12.874 MythSocket(8138368:11): new socket |
---|
660 | 2007-01-24 00:25:12.875 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendReconnectWaitTime' AND hostname = 'PVR' ; |
---|
661 | 2007-01-24 00:25:12.876 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendReconnectWaitTime' AND hostname IS NULL; |
---|
662 | 2007-01-24 00:25:12.877 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendConnectRetry' AND hostname = 'PVR' ; |
---|
663 | 2007-01-24 00:25:12.878 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendConnectRetry' AND hostname IS NULL; |
---|
664 | 2007-01-24 00:25:12.878 Connecting to backend server: 192.168.0.10:6543 (try 1 of 5) |
---|
665 | 2007-01-24 00:25:12.878 MythSocket(8144d98:12): new socket |
---|
666 | 2007-01-24 00:25:12.878 MythSocket(8144d98:12): attempting connect() to (192.168.0.10:6543) |
---|
667 | 2007-01-24 00:25:12.879 MythSocket(8144d98:12): state change Idle -> Connected |
---|
668 | 2007-01-24 00:25:12.880 write -> 12 21 MYTH_PROTO_VERSION 32 |
---|
669 | 2007-01-24 00:25:12.881 read <- 12 13 ACCEPT[]:[]32 |
---|
670 | 2007-01-24 00:25:12.881 Using protocol version 32 |
---|
671 | 2007-01-24 00:25:12.881 write -> 12 17 ANN Monitor PVR 0 |
---|
672 | 2007-01-24 00:25:12.914 read <- 12 2 OK |
---|
673 | 2007-01-24 00:25:12.914 MythSocket(8138368:11): attempting connect() to (192.168.0.10:6543) |
---|
674 | 2007-01-24 00:25:12.914 MythSocket(8138368:11): state change Idle -> Connected |
---|
675 | 2007-01-24 00:25:12.915 write -> 11 17 ANN Monitor PVR 1 |
---|
676 | 2007-01-24 00:25:12.918 read <- 11 2 OK |
---|
677 | 2007-01-24 00:25:12.919 MythSocket(8138368:11): UpRef: 1 |
---|
678 | 2007-01-24 00:25:12.919 write -> 12 24 RESCHEDULE_RECORDINGS -1 |
---|
679 | 2007-01-24 00:25:12.920 read <- 12 1 1 |
---|
680 | 2007-01-24 00:25:12.921 write -> 12 32 MESSAGE[]:[]CLEAR_SETTINGS_CACHE |
---|
681 | 2007-01-24 00:25:12.921 read <- 12 2 OK |
---|
682 | 2007-01-24 00:25:12.921 MythSocket(8144d98:12): DownRef: -1 |
---|
683 | 2007-01-24 00:25:12.922 MythSocket(8144d98:12): state change Connected -> Idle |
---|
684 | 2007-01-24 00:25:12.922 MythSocket(8144d98:-1): delete socket |
---|
685 | 2007-01-24 00:25:12.922 MythSocket(8138368:11): DownRef: 0 |
---|
686 | 2007-01-24 00:25:12.923 MythSocket: readyread thread start |
---|
687 | 2007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable |
---|
688 | 2007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable |
---|
689 | 2007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable |
---|
690 | 2007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable |
---|
691 | 2007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable |
---|
692 | 2007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable |
---|
693 | 2007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable |
---|
694 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
695 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
696 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
697 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
698 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
699 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
700 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
701 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
702 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
703 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
704 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
705 | 2007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable |
---|
706 | 2007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable |
---|
707 | 2007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable |
---|
708 | 2007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable |
---|
709 | 2007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable |
---|
710 | 2007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable |
---|
711 | 2007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable |
---|
712 | 2007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable |
---|
713 | 2007-01-24 00:25:12.928 mythfilldatabase run complete. |
---|
714 | 2007-01-24 00:25:12.934 MythSocket: readyread thread exit |
---|