Ticket #2986: datalog1

File datalog1, 69.7 KB (added by DannyCan@…, 17 years ago)

Sorry I accidentally removed the lines that say it's removing the channels. It starts removing them at time stamp: "2007-01-24 00:25:00.135"

Line 
12007-01-24 00:24:56.755 Using runtime prefix = /usr
22007-01-24 00:24:56.792 New DB connection, total: 1
32007-01-24 00:24:56.796 Connected to database 'mythconverg' at host: localhost
42007-01-24 00:24:56.799 Enabling Settings Cache.
52007-01-24 00:24:56.799 Clearing Settings Cache.
62007-01-24 00:24:56.801 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname = 'PVR' ;
72007-01-24 00:24:56.802 MSqlQuery: SELECT data FROM settings WHERE value = 'LogEnabled' AND hostname IS NULL;
82007-01-24 00:24:56.804 MSqlQuery: SELECT data FROM settings WHERE value = 'LogMaxCount' AND hostname = 'PVR' ;
92007-01-24 00:24:56.805 MSqlQuery: SELECT data FROM settings WHERE value = 'LogPrintLevel' AND hostname = 'PVR' ;
102007-01-24 00:24:56.807 MSqlQuery: SELECT sourceid,name,xmltvgrabber,userid,password,lineupid FROM videosource  ORDER BY sourceid;
112007-01-24 00:24:56.808 New DB connection, total: 2
122007-01-24 00:24:56.809 Connected to database 'mythconverg' at host: localhost
132007-01-24 00:24:56.841 MSqlQuery: SELECT MAX(endtime) FROM program WHERE manualid=0;
142007-01-24 00:24:56.841 Updating source #1 (DTV) with grabber datadirect
152007-01-24 00:24:56.842 MSqlQuery: SELECT COUNT(chanid) FROM channel WHERE sourceid = 1 AND xmltvid != ''
162007-01-24 00:24:56.846 Found 12 channels for source 1 which use grabber
172007-01-24 00:24:56.846
182007-01-24 00:24:56.846 Checking day @ offset 0, date: Wed Jan 24 2007
192007-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;
202007-01-24 00:24:56.856 Checking program counts for day -1
212007-01-24 00:24:56.856     chanid 1021 -> 0 programs
222007-01-24 00:24:56.856     chanid 1041 -> 1 programs
232007-01-24 00:24:56.856     chanid 1042 -> 1 programs
242007-01-24 00:24:56.856     chanid 1051 -> 1 programs
252007-01-24 00:24:56.856     chanid 1052 -> 1 programs
262007-01-24 00:24:56.856     chanid 1091 -> 0 programs
272007-01-24 00:24:56.856     chanid 1092 -> 0 programs
282007-01-24 00:24:56.856     chanid 1093 -> 0 programs
292007-01-24 00:24:56.856     chanid 1094 -> 0 programs
302007-01-24 00:24:56.856     chanid 1111 -> 0 programs
312007-01-24 00:24:56.856     chanid 1112 -> 0 programs
322007-01-24 00:24:56.857     chanid 1301 -> 1 programs
332007-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;
342007-01-24 00:24:56.864 Checking program counts for day 0
352007-01-24 00:24:56.864     chanid 1021 -> 5 programs
362007-01-24 00:24:56.864     chanid 1041 -> 5 programs
372007-01-24 00:24:56.864     chanid 1042 -> 5 programs
382007-01-24 00:24:56.864     chanid 1051 -> 5 programs
392007-01-24 00:24:56.864     chanid 1052 -> 5 programs
402007-01-24 00:24:56.864     chanid 1091 -> 3 programs
412007-01-24 00:24:56.864     chanid 1092 -> 3 programs
422007-01-24 00:24:56.864     chanid 1093 -> 3 programs
432007-01-24 00:24:56.864     chanid 1094 -> 3 programs
442007-01-24 00:24:56.864     chanid 1111 -> 7 programs
452007-01-24 00:24:56.864     chanid 1112 -> 7 programs
462007-01-24 00:24:56.864     chanid 1301 -> 7 programs
472007-01-24 00:24:56.865 Data is already present for Wed Jan 24 2007, skipping
482007-01-24 00:24:56.865
492007-01-24 00:24:56.865 Checking day @ offset 1, date: Thu Jan 25 2007
502007-01-24 00:24:56.865 Data Refresh always needed for tomorrow
512007-01-24 00:24:56.865 Refreshing data for Thu Jan 25 2007
522007-01-24 00:24:56.866 New DB DataDirect connection
532007-01-24 00:24:56.866 Connected to database 'mythconverg' at host: localhost
542007-01-24 00:24:56.868 MSqlQuery: UPDATE settings SET data ='2007-01-24 00:24' WHERE value='mythfilldatabaseLastRunStart'
552007-01-24 00:24:56.868 Retrieving datadirect data.
562007-01-24 00:24:56.868 Grabbing data for Wed Jan 24 2007 offset 1
572007-01-24 00:24:56.868 From Thu Jan 25 06:00:00 2007 to Fri Jan 26 06:00:00 2007 (UTC)
582007-01-24 00:24:56.868 Grabbing listing data
592007-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));
602007-01-24 00:24:58.041 MSqlQuery: TRUNCATE TABLE dd_genre;
612007-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) );
622007-01-24 00:24:58.044 MSqlQuery: TRUNCATE TABLE dd_lineup;
632007-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) );
642007-01-24 00:24:58.045 MSqlQuery: TRUNCATE TABLE dd_lineupmap;
652007-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));
662007-01-24 00:24:58.048 MSqlQuery: TRUNCATE TABLE dd_productioncrew;
672007-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));
682007-01-24 00:24:58.051 MSqlQuery: TRUNCATE TABLE dd_program;
692007-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) );
702007-01-24 00:24:58.053 MSqlQuery: TRUNCATE TABLE dd_schedule;
712007-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) );
722007-01-24 00:24:58.055 MSqlQuery: TRUNCATE TABLE dd_station;
732007-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));
742007-01-24 00:24:58.058 MSqlQuery: TRUNCATE TABLE dd_v_program;
752007-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) );
762007-01-24 00:24:58.061 MSqlQuery: TRUNCATE TABLE dd_v_station;
772007-01-24 00:24:58.062 DataDirect: Your subscription expires on 03/05/07 18:16:22
782007-01-24 00:24:58.063 MSqlQuery: UPDATE settings SET data ='Your subscription expires on 03/05/07 18:16:22' WHERE value='DataDirectMessage'
792007-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')
802007-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')
812007-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')
822007-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')
832007-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')
842007-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')
852007-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')
862007-01-24 00:24:58.071 MSqlQuery: INSERT INTO dd_station      ( stationid,  callsign,  stationname,        affiliate,  fccchannelnumber)       VALUES      ('50834', 'KPLRDT2', 'KPLRDT2 (KPLR-DT2)',       'Independent', '26')
872007-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')
882007-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')
892007-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')
902007-01-24 00:24:58.074 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '20506', '4', '1')
912007-01-24 00:24:58.075 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '20513', '5', '1')
922007-01-24 00:24:58.076 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '21237', '30', '1')
932007-01-24 00:24:58.076 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '21300', '2', '1')
942007-01-24 00:24:58.077 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '32057', '9', '1')
952007-01-24 00:24:58.078 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '32060', '9', '2')
962007-01-24 00:24:58.078 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '32065', '9', '3')
972007-01-24 00:24:58.079 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '34808', '11', '1')
982007-01-24 00:24:58.080 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '47735', '5', '2')
992007-01-24 00:24:58.080 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '49623', '9', '4')
1002007-01-24 00:24:58.081 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '50834', '11', '2')
1012007-01-24 00:24:58.082 New DB connection, total: 3
1022007-01-24 00:24:58.083 Connected to database 'mythconverg' at host: localhost
1032007-01-24 00:24:58.085 MSqlQuery: SELECT sourceid FROM videosource WHERE lineupid = 'PC:63119'
1042007-01-24 00:24:58.085 sourceid 1 has lineup type: LocalBroadcast
1052007-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
1072007-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)
1082007-01-24 00:25:00.128 MSqlQuery: UPDATE settings SET data ='2007-01-24 00:25' WHERE value='mythfilldatabaseLastRunEnd'
1092007-01-24 00:25:00.128 Main temp tables populated.
1102007-01-24 00:25:00.128 Updating myth channels.
1112007-01-24 00:25:00.129 MSqlQuery: TRUNCATE TABLE dd_v_station;
1122007-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'))
1132007-01-24 00:25:00.131 MSqlQuery: SELECT cardtype FROM capturecard, cardinput WHERE capturecard.cardid = cardinput.cardid AND       cardinput.sourceid = 1
1142007-01-24 00:25:00.132 MSqlQuery: SELECT cardtype FROM capturecard, cardinput WHERE capturecard.cardid = cardinput.cardid AND       cardinput.sourceid = 1
1152007-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
1162007-01-24 00:25:00.134 MSqlQuery: SELECT channum FROM channel WHERE sourceid = 1
1172007-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 ) )
1182007-01-24 00:25:00.135 DataDirect: Not adding channel KETCDT2 (KETC-DT2) (KETCDT2).
1192007-01-24 00:25:00.136 MSqlQuery: SELECT channum FROM channel WHERE sourceid = 1
1202007-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 ) )
1212007-01-24 00:25:00.137 DataDirect: Not adding channel KETCDT3 (KETC-DT3) (KETCDT3).
1222007-01-24 00:25:00.137 MSqlQuery: SELECT channum FROM channel WHERE sourceid = 1
1232007-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 ) )
1242007-01-24 00:25:00.138 DataDirect: Not adding channel KSDKDT2 (KSDK-DT2) (KSDKDT2).
1252007-01-24 00:25:00.139 MSqlQuery: SELECT channum FROM channel WHERE sourceid = 1
1262007-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 ) )
1272007-01-24 00:25:00.139 DataDirect: Not adding channel KETCDT4 (KETC-DT4) (KETCDT4).
1282007-01-24 00:25:00.140 MSqlQuery: SELECT channum FROM channel WHERE sourceid = 1
1292007-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 ) )
1302007-01-24 00:25:00.140 DataDirect: Not adding channel KPLRDT2 (KPLR-DT2) (KPLRDT2).
1312007-01-24 00:25:00.141 Updating icons for sourceid: 1
1322007-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
1332007-01-24 00:25:00.141 Grabbing login cookies for listing update
1342007-01-24 00:25:00.142 Grabbing login cookies and lineups
1352007-01-24 00:25:00.960 Grabbing listing for listing update
1362007-01-24 00:25:00.960 Grabbing lineup PC:63119 for modification
1372007-01-24 00:25:01.871 MSqlQuery: SELECT xmltvid FROM channel WHERE sourceid = 1
1382007-01-24 00:25:01.872 MSqlQuery: SELECT xmltvgrabber, userid, password, lineupid FROM videosource WHERE sourceid = 1
1392007-01-24 00:25:01.872 Saving updated DataDirect listing
1402007-01-24 00:25:01.872 Saving lineup PC:63119 with 6 channels
1412007-01-24 00:25:03.160 Removed 5 channel(s) from lineup.
1422007-01-24 00:25:03.160 Channels updated.
1432007-01-24 00:25:03.161 MSqlQuery: TRUNCATE TABLE dd_v_program;
1442007-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))
1452007-01-24 00:25:03.178 MSqlQuery: ANALYZE TABLE dd_v_program;
1462007-01-24 00:25:03.179 MSqlQuery: ANALYZE TABLE dd_productioncrew;
1472007-01-24 00:25:03.180 MSqlQuery: SELECT count(*) from dd_v_program;
1482007-01-24 00:25:03.180 Clearing data for source.
1492007-01-24 00:25:03.180 Clearing from Thu Jan 25 00:00:00 2007 to Fri Jan 26 00:00:00 2007 (localtime)
1502007-01-24 00:25:03.181 MSqlQuery: SELECT chanid FROM channel WHERE sourceid = 1 ;
1512007-01-24 00:25:03.182 New DB connection, total: 4
1522007-01-24 00:25:03.182 Connected to database 'mythconverg' at host: localhost
1532007-01-24 00:25:03.183 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1111 ;
1542007-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 ;
1552007-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 ;
1562007-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 ;
1572007-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 ;
1582007-01-24 00:25:03.205 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1112 ;
1592007-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 ;
1602007-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 ;
1612007-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 ;
1622007-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 ;
1632007-01-24 00:25:03.229 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1301 ;
1642007-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 ;
1652007-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 ;
1662007-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 ;
1672007-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 ;
1682007-01-24 00:25:03.246 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1051 ;
1692007-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 ;
1702007-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 ;
1712007-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 ;
1722007-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 ;
1732007-01-24 00:25:03.261 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1052 ;
1742007-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 ;
1752007-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 ;
1762007-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 ;
1772007-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 ;
1782007-01-24 00:25:03.276 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1091 ;
1792007-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 ;
1802007-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 ;
1812007-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 ;
1822007-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 ;
1832007-01-24 00:25:03.287 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1092 ;
1842007-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 ;
1852007-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 ;
1862007-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 ;
1872007-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 ;
1882007-01-24 00:25:03.296 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1093 ;
1892007-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 ;
1902007-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 ;
1912007-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 ;
1922007-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 ;
1932007-01-24 00:25:03.306 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1094 ;
1942007-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 ;
1952007-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 ;
1962007-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 ;
1972007-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 ;
1982007-01-24 00:25:03.318 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1021 ;
1992007-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 ;
2002007-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 ;
2012007-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 ;
2022007-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 ;
2032007-01-24 00:25:03.331 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1041 ;
2042007-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 ;
2052007-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 ;
2062007-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 ;
2072007-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 ;
2082007-01-24 00:25:03.346 MSqlQuery: SELECT tmoffset FROM channel where chanid = 1042 ;
2092007-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 ;
2102007-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 ;
2112007-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 ;
2122007-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 ;
2132007-01-24 00:25:03.361 Data for source cleared.
2142007-01-24 00:25:03.361 Updating programs.
2152007-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;
2162007-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
2172007-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
2182007-01-24 00:25:03.456 MSqlQuery: INSERT IGNORE INTO people (name) SELECT fullname FROM dd_productioncrew;
2192007-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;
2202007-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
2212007-01-24 00:25:03.577 Program table update complete.
2222007-01-24 00:25:03.577
2232007-01-24 00:25:03.577 Checking day @ offset 2, date: Fri Jan 26 2007
2242007-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;
2252007-01-24 00:25:03.584 Checking program counts for day 1
2262007-01-24 00:25:03.584     chanid 1021 -> 6 programs
2272007-01-24 00:25:03.585     chanid 1041 -> 5 programs
2282007-01-24 00:25:03.585     chanid 1042 -> 5 programs
2292007-01-24 00:25:03.585     chanid 1051 -> 7 programs
2302007-01-24 00:25:03.585     chanid 1052 -> 7 programs
2312007-01-24 00:25:03.585     chanid 1091 -> 4 programs
2322007-01-24 00:25:03.585     chanid 1092 -> 4 programs
2332007-01-24 00:25:03.585     chanid 1093 -> 4 programs
2342007-01-24 00:25:03.585     chanid 1094 -> 4 programs
2352007-01-24 00:25:03.585     chanid 1111 -> 7 programs
2362007-01-24 00:25:03.585     chanid 1112 -> 7 programs
2372007-01-24 00:25:03.585     chanid 1301 -> 6 programs
2382007-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;
2392007-01-24 00:25:03.592 Checking program counts for day 2
2402007-01-24 00:25:03.592     chanid 1021 -> 6 programs
2412007-01-24 00:25:03.592     chanid 1041 -> 5 programs
2422007-01-24 00:25:03.592     chanid 1042 -> 5 programs
2432007-01-24 00:25:03.592     chanid 1051 -> 5 programs
2442007-01-24 00:25:03.592     chanid 1052 -> 5 programs
2452007-01-24 00:25:03.592     chanid 1091 -> 5 programs
2462007-01-24 00:25:03.592     chanid 1092 -> 5 programs
2472007-01-24 00:25:03.593     chanid 1093 -> 5 programs
2482007-01-24 00:25:03.593     chanid 1094 -> 5 programs
2492007-01-24 00:25:03.593     chanid 1111 -> 6 programs
2502007-01-24 00:25:03.593     chanid 1112 -> 6 programs
2512007-01-24 00:25:03.593     chanid 1301 -> 6 programs
2522007-01-24 00:25:03.593 Data is already present for Fri Jan 26 2007, skipping
2532007-01-24 00:25:03.593
2542007-01-24 00:25:03.593 Checking day @ offset 3, date: Sat Jan 27 2007
2552007-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;
2562007-01-24 00:25:03.600 Checking program counts for day 2
2572007-01-24 00:25:03.600     chanid 1021 -> 6 programs
2582007-01-24 00:25:03.600     chanid 1041 -> 5 programs
2592007-01-24 00:25:03.600     chanid 1042 -> 5 programs
2602007-01-24 00:25:03.600     chanid 1051 -> 5 programs
2612007-01-24 00:25:03.600     chanid 1052 -> 5 programs
2622007-01-24 00:25:03.600     chanid 1091 -> 5 programs
2632007-01-24 00:25:03.600     chanid 1092 -> 5 programs
2642007-01-24 00:25:03.600     chanid 1093 -> 5 programs
2652007-01-24 00:25:03.600     chanid 1094 -> 5 programs
2662007-01-24 00:25:03.600     chanid 1111 -> 6 programs
2672007-01-24 00:25:03.601     chanid 1112 -> 6 programs
2682007-01-24 00:25:03.601     chanid 1301 -> 6 programs
2692007-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;
2702007-01-24 00:25:03.609 Checking program counts for day 3
2712007-01-24 00:25:03.610     chanid 1021 -> 5 programs
2722007-01-24 00:25:03.610     chanid 1041 -> 4 programs
2732007-01-24 00:25:03.610     chanid 1042 -> 4 programs
2742007-01-24 00:25:03.610     chanid 1051 -> 4 programs
2752007-01-24 00:25:03.610     chanid 1052 -> 4 programs
2762007-01-24 00:25:03.610     chanid 1091 -> 4 programs
2772007-01-24 00:25:03.610     chanid 1092 -> 4 programs
2782007-01-24 00:25:03.610     chanid 1093 -> 4 programs
2792007-01-24 00:25:03.610     chanid 1094 -> 4 programs
2802007-01-24 00:25:03.610     chanid 1111 -> 5 programs
2812007-01-24 00:25:03.610     chanid 1112 -> 5 programs
2822007-01-24 00:25:03.610     chanid 1301 -> 3 programs
2832007-01-24 00:25:03.610 Data is already present for Sat Jan 27 2007, skipping
2842007-01-24 00:25:03.612
2852007-01-24 00:25:03.612 Checking day @ offset 4, date: Sun Jan 28 2007
2862007-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;
2872007-01-24 00:25:03.618 Checking program counts for day 3
2882007-01-24 00:25:03.618     chanid 1021 -> 5 programs
2892007-01-24 00:25:03.619     chanid 1041 -> 4 programs
2902007-01-24 00:25:03.619     chanid 1042 -> 4 programs
2912007-01-24 00:25:03.619     chanid 1051 -> 4 programs
2922007-01-24 00:25:03.619     chanid 1052 -> 4 programs
2932007-01-24 00:25:03.619     chanid 1091 -> 4 programs
2942007-01-24 00:25:03.619     chanid 1092 -> 4 programs
2952007-01-24 00:25:03.619     chanid 1093 -> 4 programs
2962007-01-24 00:25:03.619     chanid 1094 -> 4 programs
2972007-01-24 00:25:03.619     chanid 1111 -> 5 programs
2982007-01-24 00:25:03.619     chanid 1112 -> 5 programs
2992007-01-24 00:25:03.619     chanid 1301 -> 3 programs
3002007-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;
3012007-01-24 00:25:03.626 Checking program counts for day 4
3022007-01-24 00:25:03.626     chanid 1021 -> 6 programs
3032007-01-24 00:25:03.626     chanid 1041 -> 5 programs
3042007-01-24 00:25:03.626     chanid 1042 -> 5 programs
3052007-01-24 00:25:03.626     chanid 1051 -> 6 programs
3062007-01-24 00:25:03.626     chanid 1052 -> 6 programs
3072007-01-24 00:25:03.627     chanid 1091 -> 3 programs
3082007-01-24 00:25:03.627     chanid 1092 -> 3 programs
3092007-01-24 00:25:03.627     chanid 1093 -> 3 programs
3102007-01-24 00:25:03.627     chanid 1094 -> 3 programs
3112007-01-24 00:25:03.627     chanid 1111 -> 7 programs
3122007-01-24 00:25:03.627     chanid 1112 -> 7 programs
3132007-01-24 00:25:03.627     chanid 1301 -> 5 programs
3142007-01-24 00:25:03.627 Data is already present for Sun Jan 28 2007, skipping
3152007-01-24 00:25:03.627
3162007-01-24 00:25:03.627 Checking day @ offset 5, date: Mon Jan 29 2007
3172007-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;
3182007-01-24 00:25:03.634 Checking program counts for day 4
3192007-01-24 00:25:03.634     chanid 1021 -> 6 programs
3202007-01-24 00:25:03.634     chanid 1041 -> 5 programs
3212007-01-24 00:25:03.634     chanid 1042 -> 5 programs
3222007-01-24 00:25:03.634     chanid 1051 -> 6 programs
3232007-01-24 00:25:03.634     chanid 1052 -> 6 programs
3242007-01-24 00:25:03.634     chanid 1091 -> 3 programs
3252007-01-24 00:25:03.634     chanid 1092 -> 3 programs
3262007-01-24 00:25:03.635     chanid 1093 -> 3 programs
3272007-01-24 00:25:03.635     chanid 1094 -> 3 programs
3282007-01-24 00:25:03.635     chanid 1111 -> 7 programs
3292007-01-24 00:25:03.635     chanid 1112 -> 7 programs
3302007-01-24 00:25:03.635     chanid 1301 -> 5 programs
3312007-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;
3322007-01-24 00:25:03.642 Checking program counts for day 5
3332007-01-24 00:25:03.642     chanid 1021 -> 6 programs
3342007-01-24 00:25:03.642     chanid 1041 -> 6 programs
3352007-01-24 00:25:03.642     chanid 1042 -> 6 programs
3362007-01-24 00:25:03.642     chanid 1051 -> 5 programs
3372007-01-24 00:25:03.642     chanid 1052 -> 5 programs
3382007-01-24 00:25:03.642     chanid 1091 -> 3 programs
3392007-01-24 00:25:03.642     chanid 1092 -> 3 programs
3402007-01-24 00:25:03.642     chanid 1093 -> 3 programs
3412007-01-24 00:25:03.642     chanid 1094 -> 3 programs
3422007-01-24 00:25:03.642     chanid 1111 -> 8 programs
3432007-01-24 00:25:03.642     chanid 1112 -> 8 programs
3442007-01-24 00:25:03.643     chanid 1301 -> 6 programs
3452007-01-24 00:25:03.643 Data is already present for Mon Jan 29 2007, skipping
3462007-01-24 00:25:03.643
3472007-01-24 00:25:03.643 Checking day @ offset 6, date: Tue Jan 30 2007
3482007-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;
3492007-01-24 00:25:03.649 Checking program counts for day 5
3502007-01-24 00:25:03.649     chanid 1021 -> 6 programs
3512007-01-24 00:25:03.649     chanid 1041 -> 6 programs
3522007-01-24 00:25:03.650     chanid 1042 -> 6 programs
3532007-01-24 00:25:03.650     chanid 1051 -> 5 programs
3542007-01-24 00:25:03.650     chanid 1052 -> 5 programs
3552007-01-24 00:25:03.650     chanid 1091 -> 3 programs
3562007-01-24 00:25:03.650     chanid 1092 -> 3 programs
3572007-01-24 00:25:03.650     chanid 1093 -> 3 programs
3582007-01-24 00:25:03.650     chanid 1094 -> 3 programs
3592007-01-24 00:25:03.650     chanid 1111 -> 8 programs
3602007-01-24 00:25:03.651     chanid 1112 -> 8 programs
3612007-01-24 00:25:03.651     chanid 1301 -> 6 programs
3622007-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;
3632007-01-24 00:25:03.657 Checking program counts for day 6
3642007-01-24 00:25:03.657     chanid 1021 -> 6 programs
3652007-01-24 00:25:03.657     chanid 1041 -> 5 programs
3662007-01-24 00:25:03.657     chanid 1042 -> 5 programs
3672007-01-24 00:25:03.657     chanid 1051 -> 5 programs
3682007-01-24 00:25:03.658     chanid 1052 -> 5 programs
3692007-01-24 00:25:03.658     chanid 1091 -> 4 programs
3702007-01-24 00:25:03.658     chanid 1092 -> 4 programs
3712007-01-24 00:25:03.658     chanid 1093 -> 4 programs
3722007-01-24 00:25:03.658     chanid 1094 -> 4 programs
3732007-01-24 00:25:03.658     chanid 1111 -> 7 programs
3742007-01-24 00:25:03.658     chanid 1112 -> 7 programs
3752007-01-24 00:25:03.658     chanid 1301 -> 7 programs
3762007-01-24 00:25:03.658 Data is already present for Tue Jan 30 2007, skipping
3772007-01-24 00:25:03.658
3782007-01-24 00:25:03.658 Checking day @ offset 7, date: Wed Jan 31 2007
3792007-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;
3802007-01-24 00:25:03.665 Checking program counts for day 6
3812007-01-24 00:25:03.665     chanid 1021 -> 6 programs
3822007-01-24 00:25:03.665     chanid 1041 -> 5 programs
3832007-01-24 00:25:03.665     chanid 1042 -> 5 programs
3842007-01-24 00:25:03.666     chanid 1051 -> 5 programs
3852007-01-24 00:25:03.666     chanid 1052 -> 5 programs
3862007-01-24 00:25:03.666     chanid 1091 -> 4 programs
3872007-01-24 00:25:03.666     chanid 1092 -> 4 programs
3882007-01-24 00:25:03.666     chanid 1093 -> 4 programs
3892007-01-24 00:25:03.666     chanid 1094 -> 4 programs
3902007-01-24 00:25:03.666     chanid 1111 -> 7 programs
3912007-01-24 00:25:03.666     chanid 1112 -> 7 programs
3922007-01-24 00:25:03.666     chanid 1301 -> 7 programs
3932007-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;
3942007-01-24 00:25:03.672 Checking program counts for day 7
3952007-01-24 00:25:03.672     chanid 1021 -> 6 programs
3962007-01-24 00:25:03.673     chanid 1041 -> 5 programs
3972007-01-24 00:25:03.673     chanid 1042 -> 5 programs
3982007-01-24 00:25:03.673     chanid 1051 -> 5 programs
3992007-01-24 00:25:03.673     chanid 1052 -> 5 programs
4002007-01-24 00:25:03.673     chanid 1091 -> 3 programs
4012007-01-24 00:25:03.673     chanid 1092 -> 3 programs
4022007-01-24 00:25:03.673     chanid 1093 -> 3 programs
4032007-01-24 00:25:03.673     chanid 1094 -> 3 programs
4042007-01-24 00:25:03.673     chanid 1111 -> 7 programs
4052007-01-24 00:25:03.673     chanid 1112 -> 7 programs
4062007-01-24 00:25:03.673     chanid 1301 -> 7 programs
4072007-01-24 00:25:03.673 Data is already present for Wed Jan 31 2007, skipping
4082007-01-24 00:25:03.674
4092007-01-24 00:25:03.674 Checking day @ offset 8, date: Thu Feb 1 2007
4102007-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;
4112007-01-24 00:25:03.680 Checking program counts for day 7
4122007-01-24 00:25:03.681     chanid 1021 -> 6 programs
4132007-01-24 00:25:03.681     chanid 1041 -> 5 programs
4142007-01-24 00:25:03.681     chanid 1042 -> 5 programs
4152007-01-24 00:25:03.681     chanid 1051 -> 5 programs
4162007-01-24 00:25:03.681     chanid 1052 -> 5 programs
4172007-01-24 00:25:03.681     chanid 1091 -> 3 programs
4182007-01-24 00:25:03.681     chanid 1092 -> 3 programs
4192007-01-24 00:25:03.681     chanid 1093 -> 3 programs
4202007-01-24 00:25:03.681     chanid 1094 -> 3 programs
4212007-01-24 00:25:03.681     chanid 1111 -> 7 programs
4222007-01-24 00:25:03.681     chanid 1112 -> 7 programs
4232007-01-24 00:25:03.681     chanid 1301 -> 7 programs
4242007-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;
4252007-01-24 00:25:03.688 Checking program counts for day 8
4262007-01-24 00:25:03.688     chanid 1021 -> 6 programs
4272007-01-24 00:25:03.688     chanid 1041 -> 5 programs
4282007-01-24 00:25:03.688     chanid 1042 -> 5 programs
4292007-01-24 00:25:03.688     chanid 1051 -> 6 programs
4302007-01-24 00:25:03.688     chanid 1052 -> 6 programs
4312007-01-24 00:25:03.688     chanid 1091 -> 4 programs
4322007-01-24 00:25:03.689     chanid 1092 -> 4 programs
4332007-01-24 00:25:03.689     chanid 1093 -> 4 programs
4342007-01-24 00:25:03.689     chanid 1094 -> 4 programs
4352007-01-24 00:25:03.689     chanid 1111 -> 7 programs
4362007-01-24 00:25:03.689     chanid 1112 -> 7 programs
4372007-01-24 00:25:03.689     chanid 1301 -> 6 programs
4382007-01-24 00:25:03.689 Data is already present for Thu Feb 1 2007, skipping
4392007-01-24 00:25:03.689
4402007-01-24 00:25:03.689 Checking day @ offset 9, date: Fri Feb 2 2007
4412007-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;
4422007-01-24 00:25:03.695 Checking program counts for day 8
4432007-01-24 00:25:03.696     chanid 1021 -> 6 programs
4442007-01-24 00:25:03.696     chanid 1041 -> 5 programs
4452007-01-24 00:25:03.696     chanid 1042 -> 5 programs
4462007-01-24 00:25:03.696     chanid 1051 -> 6 programs
4472007-01-24 00:25:03.696     chanid 1052 -> 6 programs
4482007-01-24 00:25:03.696     chanid 1091 -> 4 programs
4492007-01-24 00:25:03.696     chanid 1092 -> 4 programs
4502007-01-24 00:25:03.696     chanid 1093 -> 4 programs
4512007-01-24 00:25:03.696     chanid 1094 -> 4 programs
4522007-01-24 00:25:03.696     chanid 1111 -> 7 programs
4532007-01-24 00:25:03.696     chanid 1112 -> 7 programs
4542007-01-24 00:25:03.696     chanid 1301 -> 6 programs
4552007-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;
4562007-01-24 00:25:03.703 Checking program counts for day 9
4572007-01-24 00:25:03.703     chanid 1021 -> 6 programs
4582007-01-24 00:25:03.703     chanid 1041 -> 5 programs
4592007-01-24 00:25:03.703     chanid 1042 -> 5 programs
4602007-01-24 00:25:03.703     chanid 1051 -> 5 programs
4612007-01-24 00:25:03.704     chanid 1052 -> 5 programs
4622007-01-24 00:25:03.704     chanid 1091 -> 4 programs
4632007-01-24 00:25:03.704     chanid 1092 -> 4 programs
4642007-01-24 00:25:03.704     chanid 1093 -> 4 programs
4652007-01-24 00:25:03.704     chanid 1094 -> 4 programs
4662007-01-24 00:25:03.704     chanid 1111 -> 6 programs
4672007-01-24 00:25:03.704     chanid 1112 -> 6 programs
4682007-01-24 00:25:03.704     chanid 1301 -> 6 programs
4692007-01-24 00:25:03.704 Data is already present for Fri Feb 2 2007, skipping
4702007-01-24 00:25:03.704
4712007-01-24 00:25:03.704 Checking day @ offset 10, date: Sat Feb 3 2007
4722007-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;
4732007-01-24 00:25:03.712 Checking program counts for day 9
4742007-01-24 00:25:03.712     chanid 1021 -> 6 programs
4752007-01-24 00:25:03.712     chanid 1041 -> 5 programs
4762007-01-24 00:25:03.712     chanid 1042 -> 5 programs
4772007-01-24 00:25:03.712     chanid 1051 -> 5 programs
4782007-01-24 00:25:03.712     chanid 1052 -> 5 programs
4792007-01-24 00:25:03.713     chanid 1091 -> 4 programs
4802007-01-24 00:25:03.713     chanid 1092 -> 4 programs
4812007-01-24 00:25:03.713     chanid 1093 -> 4 programs
4822007-01-24 00:25:03.713     chanid 1094 -> 4 programs
4832007-01-24 00:25:03.713     chanid 1111 -> 6 programs
4842007-01-24 00:25:03.713     chanid 1112 -> 6 programs
4852007-01-24 00:25:03.713     chanid 1301 -> 6 programs
4862007-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;
4872007-01-24 00:25:03.719 Checking program counts for day 10
4882007-01-24 00:25:03.719     chanid 1021 -> 5 programs
4892007-01-24 00:25:03.719     chanid 1041 -> 5 programs
4902007-01-24 00:25:03.719     chanid 1042 -> 5 programs
4912007-01-24 00:25:03.720     chanid 1051 -> 4 programs
4922007-01-24 00:25:03.720     chanid 1052 -> 4 programs
4932007-01-24 00:25:03.720     chanid 1091 -> 4 programs
4942007-01-24 00:25:03.720     chanid 1092 -> 4 programs
4952007-01-24 00:25:03.720     chanid 1093 -> 4 programs
4962007-01-24 00:25:03.720     chanid 1094 -> 4 programs
4972007-01-24 00:25:03.720     chanid 1111 -> 5 programs
4982007-01-24 00:25:03.720     chanid 1112 -> 5 programs
4992007-01-24 00:25:03.720     chanid 1301 -> 4 programs
5002007-01-24 00:25:03.720 Data is already present for Sat Feb 3 2007, skipping
5012007-01-24 00:25:03.720
5022007-01-24 00:25:03.720 Checking day @ offset 11, date: Sun Feb 4 2007
5032007-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;
5042007-01-24 00:25:03.727 Checking program counts for day 10
5052007-01-24 00:25:03.727     chanid 1021 -> 5 programs
5062007-01-24 00:25:03.727     chanid 1041 -> 5 programs
5072007-01-24 00:25:03.727     chanid 1042 -> 5 programs
5082007-01-24 00:25:03.727     chanid 1051 -> 4 programs
5092007-01-24 00:25:03.728     chanid 1052 -> 4 programs
5102007-01-24 00:25:03.728     chanid 1091 -> 4 programs
5112007-01-24 00:25:03.728     chanid 1092 -> 4 programs
5122007-01-24 00:25:03.728     chanid 1093 -> 4 programs
5132007-01-24 00:25:03.728     chanid 1094 -> 4 programs
5142007-01-24 00:25:03.728     chanid 1111 -> 5 programs
5152007-01-24 00:25:03.728     chanid 1112 -> 5 programs
5162007-01-24 00:25:03.728     chanid 1301 -> 4 programs
5172007-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;
5182007-01-24 00:25:03.735 Checking program counts for day 11
5192007-01-24 00:25:03.735     chanid 1021 -> 4 programs
5202007-01-24 00:25:03.735     chanid 1041 -> 5 programs
5212007-01-24 00:25:03.735     chanid 1042 -> 5 programs
5222007-01-24 00:25:03.735     chanid 1051 -> 5 programs
5232007-01-24 00:25:03.735     chanid 1052 -> 5 programs
5242007-01-24 00:25:03.735     chanid 1091 -> 4 programs
5252007-01-24 00:25:03.735     chanid 1092 -> 4 programs
5262007-01-24 00:25:03.735     chanid 1093 -> 4 programs
5272007-01-24 00:25:03.735     chanid 1094 -> 4 programs
5282007-01-24 00:25:03.736     chanid 1111 -> 7 programs
5292007-01-24 00:25:03.736     chanid 1112 -> 7 programs
5302007-01-24 00:25:03.736     chanid 1301 -> 4 programs
5312007-01-24 00:25:03.736 Data is already present for Sun Feb 4 2007, skipping
5322007-01-24 00:25:03.736
5332007-01-24 00:25:03.736 Checking day @ offset 12, date: Mon Feb 5 2007
5342007-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;
5352007-01-24 00:25:03.742 Checking program counts for day 11
5362007-01-24 00:25:03.742     chanid 1021 -> 4 programs
5372007-01-24 00:25:03.743     chanid 1041 -> 5 programs
5382007-01-24 00:25:03.743     chanid 1042 -> 5 programs
5392007-01-24 00:25:03.743     chanid 1051 -> 5 programs
5402007-01-24 00:25:03.743     chanid 1052 -> 5 programs
5412007-01-24 00:25:03.743     chanid 1091 -> 4 programs
5422007-01-24 00:25:03.743     chanid 1092 -> 4 programs
5432007-01-24 00:25:03.743     chanid 1093 -> 4 programs
5442007-01-24 00:25:03.743     chanid 1094 -> 4 programs
5452007-01-24 00:25:03.743     chanid 1111 -> 7 programs
5462007-01-24 00:25:03.743     chanid 1112 -> 7 programs
5472007-01-24 00:25:03.743     chanid 1301 -> 4 programs
5482007-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;
5492007-01-24 00:25:03.750 Checking program counts for day 12
5502007-01-24 00:25:03.750     chanid 1021 -> 6 programs
5512007-01-24 00:25:03.750     chanid 1041 -> 6 programs
5522007-01-24 00:25:03.750     chanid 1042 -> 6 programs
5532007-01-24 00:25:03.750     chanid 1051 -> 5 programs
5542007-01-24 00:25:03.750     chanid 1052 -> 5 programs
5552007-01-24 00:25:03.750     chanid 1091 -> 4 programs
5562007-01-24 00:25:03.751     chanid 1092 -> 4 programs
5572007-01-24 00:25:03.751     chanid 1093 -> 4 programs
5582007-01-24 00:25:03.751     chanid 1094 -> 4 programs
5592007-01-24 00:25:03.751     chanid 1111 -> 8 programs
5602007-01-24 00:25:03.751     chanid 1112 -> 8 programs
5612007-01-24 00:25:03.751     chanid 1301 -> 6 programs
5622007-01-24 00:25:03.751 Data is already present for Mon Feb 5 2007, skipping
5632007-01-24 00:25:03.751
5642007-01-24 00:25:03.751 Checking day @ offset 13, date: Tue Feb 6 2007
5652007-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;
5662007-01-24 00:25:03.757 Checking program counts for day 12
5672007-01-24 00:25:03.757     chanid 1021 -> 6 programs
5682007-01-24 00:25:03.758     chanid 1041 -> 6 programs
5692007-01-24 00:25:03.763     chanid 1042 -> 6 programs
5702007-01-24 00:25:03.763     chanid 1051 -> 5 programs
5712007-01-24 00:25:03.763     chanid 1052 -> 5 programs
5722007-01-24 00:25:03.763     chanid 1091 -> 4 programs
5732007-01-24 00:25:03.763     chanid 1092 -> 4 programs
5742007-01-24 00:25:03.764     chanid 1093 -> 4 programs
5752007-01-24 00:25:03.764     chanid 1094 -> 4 programs
5762007-01-24 00:25:03.764     chanid 1111 -> 8 programs
5772007-01-24 00:25:03.764     chanid 1112 -> 8 programs
5782007-01-24 00:25:03.764     chanid 1301 -> 6 programs
5792007-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;
5802007-01-24 00:25:03.771 Checking program counts for day 13
5812007-01-24 00:25:03.771     chanid 1021 -> 0 programs
5822007-01-24 00:25:03.772     chanid 1041 -> 0 programs
5832007-01-24 00:25:03.772     chanid 1042 -> 0 programs
5842007-01-24 00:25:03.772     chanid 1051 -> 0 programs
5852007-01-24 00:25:03.772     chanid 1052 -> 0 programs
5862007-01-24 00:25:03.772     chanid 1091 -> 0 programs
5872007-01-24 00:25:03.772     chanid 1092 -> 0 programs
5882007-01-24 00:25:03.772     chanid 1093 -> 0 programs
5892007-01-24 00:25:03.772     chanid 1094 -> 0 programs
5902007-01-24 00:25:03.772     chanid 1111 -> 0 programs
5912007-01-24 00:25:03.772     chanid 1112 -> 0 programs
5922007-01-24 00:25:03.772     chanid 1301 -> 0 programs
5932007-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.
5942007-01-24 00:25:03.773 Refreshing data for Tue Feb 6 2007
5952007-01-24 00:25:03.773 MSqlQuery: UPDATE settings SET data ='2007-01-24 00:25' WHERE value='mythfilldatabaseLastRunStart'
5962007-01-24 00:25:03.773 Retrieving datadirect data.
5972007-01-24 00:25:03.773 Grabbing data for Wed Jan 24 2007 offset 13
5982007-01-24 00:25:03.773 From Tue Feb 6 06:00:00 2007 to Wed Feb 7 06:00:00 2007 (UTC)
5992007-01-24 00:25:03.774 Grabbing listing data
6002007-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));
6012007-01-24 00:25:05.774 MSqlQuery: TRUNCATE TABLE dd_genre;
6022007-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) );
6032007-01-24 00:25:05.775 MSqlQuery: TRUNCATE TABLE dd_lineup;
6042007-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) );
6052007-01-24 00:25:05.777 MSqlQuery: TRUNCATE TABLE dd_lineupmap;
6062007-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));
6072007-01-24 00:25:05.778 MSqlQuery: TRUNCATE TABLE dd_productioncrew;
6082007-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));
6092007-01-24 00:25:05.781 MSqlQuery: TRUNCATE TABLE dd_program;
6102007-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) );
6112007-01-24 00:25:05.783 MSqlQuery: TRUNCATE TABLE dd_schedule;
6122007-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) );
6132007-01-24 00:25:05.785 MSqlQuery: TRUNCATE TABLE dd_station;
6142007-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));
6152007-01-24 00:25:05.787 MSqlQuery: TRUNCATE TABLE dd_v_program;
6162007-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) );
6172007-01-24 00:25:05.789 MSqlQuery: TRUNCATE TABLE dd_v_station;
6182007-01-24 00:25:05.790 DataDirect: Your subscription expires on 03/05/07 18:16:22
6192007-01-24 00:25:05.791 MSqlQuery: UPDATE settings SET data ='Your subscription expires on 03/05/07 18:16:22' WHERE value='DataDirectMessage'
6202007-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')
6212007-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')
6222007-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')
6232007-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')
6242007-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')
6252007-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')
6262007-01-24 00:25:05.797 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '20506', '4', '1')
6272007-01-24 00:25:05.798 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '20513', '5', '1')
6282007-01-24 00:25:05.798 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '21237', '30', '1')
6292007-01-24 00:25:05.799 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '21300', '2', '1')
6302007-01-24 00:25:05.800 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '32057', '9', '1')
6312007-01-24 00:25:05.801 MSqlQuery: INSERT INTO dd_lineupmap      ( lineupid,  stationid,  channel,  channelMinor) VALUES      ('PC:63119', '34808', '11', '1')
6322007-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')
633productioncrew        ( programid,  role,  givenname,  surname,  fullname) VALUES ('MV0507670000', 'Executive_Producer', 'David L.', 'Wolper', 'David L. Wolper')
634
6352007-01-24 00:25:12.404 MSqlQuery: SELECT MAX(starttime),title,subtitle,description FROM program WHERE programid = '' GROUP BY title,subtitle,description;
6362007-01-24 00:25:12.404     Found 1447
6372007-01-24 00:25:12.428 MSqlQuery: SELECT count(previouslyshown) FROM program WHERE previouslyshown = 1;
6382007-01-24 00:25:12.428 MSqlQuery: UPDATE settings SET data = '1' WHERE value = 'HaveRepeats';
6392007-01-24 00:25:12.429 MSqlQuery: SELECT data FROM settings WHERE value = 'MythFillGrabberSuggestsTime' AND hostname = 'PVR' ;
6402007-01-24 00:25:12.430 MSqlQuery: SELECT data FROM settings WHERE value = 'MythFillGrabberSuggestsTime' AND hostname IS NULL;
6412007-01-24 00:25:12.430 Grabbing next suggested grabbing time
6422007-01-24 00:25:12.864 DataDirect: BlockedTime is: 2007-01-24T00:25:12
6432007-01-24 00:25:12.865 DataDirect: NextSuggestedTime is: 2007-01-24T14:09:59
6442007-01-24 00:25:12.866 MSqlQuery: SELECT data FROM settings WHERE value = 'MythFillPeriod' AND hostname = 'PVR' ;
6452007-01-24 00:25:12.867 MSqlQuery: SELECT data FROM settings WHERE value = 'MythFillPeriod' AND hostname IS NULL;
6462007-01-24 00:25:12.868 MSqlQuery: UPDATE settings SET data = '14' WHERE value = 'MythFillMinHour';
6472007-01-24 00:25:12.869 MSqlQuery: UPDATE settings SET data = '16' WHERE value = 'MythFillMaxHour';
6482007-01-24 00:25:12.870 MSqlQuery: UPDATE settings SET data = '2007-01-24T14:09:59' WHERE value = 'MythFillSuggestedRunTime';
6492007-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===============================================================
6552007-01-24 00:25:12.871 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname = 'PVR' ;
6562007-01-24 00:25:12.872 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerIP' AND hostname IS NULL;
6572007-01-24 00:25:12.873 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname = 'PVR' ;
6582007-01-24 00:25:12.873 MSqlQuery: SELECT data FROM settings WHERE value = 'MasterServerPort' AND hostname IS NULL;
6592007-01-24 00:25:12.874 MythSocket(8138368:11): new socket
6602007-01-24 00:25:12.875 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendReconnectWaitTime' AND hostname = 'PVR' ;
6612007-01-24 00:25:12.876 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendReconnectWaitTime' AND hostname IS NULL;
6622007-01-24 00:25:12.877 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendConnectRetry' AND hostname = 'PVR' ;
6632007-01-24 00:25:12.878 MSqlQuery: SELECT data FROM settings WHERE value = 'WOLbackendConnectRetry' AND hostname IS NULL;
6642007-01-24 00:25:12.878 Connecting to backend server: 192.168.0.10:6543 (try 1 of 5)
6652007-01-24 00:25:12.878 MythSocket(8144d98:12): new socket
6662007-01-24 00:25:12.878 MythSocket(8144d98:12): attempting connect() to (192.168.0.10:6543)
6672007-01-24 00:25:12.879 MythSocket(8144d98:12): state change Idle -> Connected
6682007-01-24 00:25:12.880 write -> 12 21      MYTH_PROTO_VERSION 32
6692007-01-24 00:25:12.881 read  <- 12 13      ACCEPT[]:[]32
6702007-01-24 00:25:12.881 Using protocol version 32
6712007-01-24 00:25:12.881 write -> 12 17      ANN Monitor PVR 0
6722007-01-24 00:25:12.914 read  <- 12 2       OK
6732007-01-24 00:25:12.914 MythSocket(8138368:11): attempting connect() to (192.168.0.10:6543)
6742007-01-24 00:25:12.914 MythSocket(8138368:11): state change Idle -> Connected
6752007-01-24 00:25:12.915 write -> 11 17      ANN Monitor PVR 1
6762007-01-24 00:25:12.918 read  <- 11 2       OK
6772007-01-24 00:25:12.919 MythSocket(8138368:11): UpRef: 1
6782007-01-24 00:25:12.919 write -> 12 24      RESCHEDULE_RECORDINGS -1
6792007-01-24 00:25:12.920 read  <- 12 1       1
6802007-01-24 00:25:12.921 write -> 12 32      MESSAGE[]:[]CLEAR_SETTINGS_CACHE
6812007-01-24 00:25:12.921 read  <- 12 2       OK
6822007-01-24 00:25:12.921 MythSocket(8144d98:12): DownRef: -1
6832007-01-24 00:25:12.922 MythSocket(8144d98:12): state change Connected -> Idle
6842007-01-24 00:25:12.922 MythSocket(8144d98:-1): delete socket
6852007-01-24 00:25:12.922 MythSocket(8138368:11): DownRef: 0
6862007-01-24 00:25:12.923 MythSocket: readyread thread start
6872007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable
6882007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable
6892007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable
6902007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable
6912007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable
6922007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable
6932007-01-24 00:25:12.924 MythSocket(8138368:11): socket is readable
6942007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
6952007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
6962007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
6972007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
6982007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
6992007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
7002007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
7012007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
7022007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
7032007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
7042007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
7052007-01-24 00:25:12.925 MythSocket(8138368:11): socket is readable
7062007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable
7072007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable
7082007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable
7092007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable
7102007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable
7112007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable
7122007-01-24 00:25:12.926 MythSocket(8138368:11): socket is readable
7132007-01-24 00:25:12.928 mythfilldatabase run complete.
7142007-01-24 00:25:12.934 MythSocket: readyread thread exit