kraut@hooligan:/mnt/exodus/share$ mythfilldatabase --manual ### ### Running in manual channel configuration mode. ### This will ask you questions about every channel. ### 2006-10-03 21:57:17.505 New DB connection, total: 1 2006-10-03 21:57:17.537 New DB connection, total: 2 Refreshing Tomorrow's data ----------------- Start of XMLTV output ----------------- 2006-10-03 21:57:17.557 New DB connection, total: 3 getting list of channels grabbing cannot find date on requested page at /usr/bin/tv_grab_de_tvtoday line 473. ------------------ End of XMLTV output ------------------ Error in 4:201: unexpected end of file Updating icons for sourceid: 1 2006-10-03 21:57:21.276 New DB connection, total: 4 Updated programs: 0 Unchanged programs: 0 Data is already present for Di Okt 3 2006, skipping Data is already present for Do Okt 5 2006, skipping Data is already present for Fr Okt 6 2006, skipping Data is already present for Sa Okt 7 2006, skipping Data is already present for So Okt 8 2006, skipping Data is already present for Mo Okt 9 2006, skipping Refreshing Tomorrow's data 2006-10-03 21:57:21.307 New DB DataDirect connection Retrieving datadirect data... Grabbing data for Di Okt 3 2006 offset 1 From : Di Okt 3 22:00:00 2006 To : Mi Okt 4 22:00:00 2006 (UTC) --21:57:21-- http://datadirect.webservices.zap2it.com/tvlistings/xtvdService => `-' Auflösen des Hostnamen »datadirect.webservices.zap2it.com«.... 206.18.98.160 Verbindungsaufbau zu datadirect.webservices.zap2it.com|206.18.98.160|:80... verbunden. HTTP Anforderung gesendet, warte auf Antwort... 401 Unauthorized Verbindungsaufbau zu datadirect.webservices.zap2it.com|206.18.98.160|:80... verbunden. HTTP Anforderung gesendet, warte auf Antwort... 401 Unauthorized Authorisierung fehlgeschlagen. DB Error (Creating temporary table): Query was: CREATE TEMPORARY TABLE IF NOT EXISTS dd_schedule ( programid char(12), stationid char(12), scheduletime datetime, duration time, repeat bool, stereo bool, subtitled bool, hdtv bool, closecaptioned bool, tvrating char(5), partnumber int, parttotal int, endtime datetime, INDEX progidx (programid) ); Driver error was [2/1064]: QMYSQL3: Unable to execute query Database error was: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'repeat bool, stereo bool, subtitled bool, hdtv bool, closecaptioned bool, tvrati' at line 1 DB Error (Truncating temporary table): Query was: TRUNCATE TABLE dd_schedule; Driver error was [2/1146]: QMYSQL3: Unable to execute query Database error was: Table 'mythtv.dd_schedule' doesn't exist DB Error (Creating temporary table): Query was: 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, repeat 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)); Driver error was [2/1064]: QMYSQL3: Unable to execute query Database error was: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'repeat bool, stereo bool, subtitled bool, hdtv bool, closecaptioned bool, partn' at line 1 DB Error (Truncating temporary table): Query was: TRUNCATE TABLE dd_v_program; Driver error was [2/1146]: QMYSQL3: Unable to execute query Database error was: Table 'mythtv.dd_v_program' doesn't exist Grab complete. Actual data from DB Error (Truncating temporary table dd_v_program): Query was: TRUNCATE TABLE dd_v_program; Driver error was [2/1146]: QMYSQL3: Unable to execute query Database error was: Table 'mythtv.dd_v_program' doesn't exist DB Error (Populating temporary table dd_v_program): Query was: 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, repeat, 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 = 2 )); Driver error was [2/1064]: QMYSQL3: Unable to execute query Database error was: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' stereo, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, origi' at line 1 DB Error (Inserting into program table): Query was: 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 chanid, starttime, endtime, 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 LEFT JOIN dd_genre ON (dd_v_program.programid = dd_genre.programid AND dd_genre.relevance = '0'); Driver error was [2/1146]: QMYSQL3: Unable to execute query Database error was: Table 'mythtv.dd_v_program' doesn't exist DB Error (Inserting into programrating table): Query was: INSERT IGNORE INTO programrating (chanid, starttime, system, rating) SELECT chanid, starttime, 'MPAA', mpaarating FROM dd_v_program WHERE mpaarating != ''; Driver error was [2/1146]: QMYSQL3: Unable to execute query Database error was: Table 'mythtv.dd_v_program' doesn't exist DB Error (Inserting into programrating table): Query was: INSERT IGNORE INTO programrating (chanid, starttime, system, rating) SELECT chanid, starttime, 'VCHIP', tvrating FROM dd_v_program WHERE tvrating != ''; Driver error was [2/1146]: QMYSQL3: Unable to execute query Database error was: Table 'mythtv.dd_v_program' doesn't exist DB Error (Inserting into credits table): Query was: INSERT IGNORE INTO credits (chanid, starttime, person, role) SELECT chanid, starttime, person, role FROM dd_productioncrew, dd_v_program, people WHERE ((dd_productioncrew.programid = dd_v_program.programid) AND (dd_productioncrew.fullname = people.name)); Driver error was [2/1146]: QMYSQL3: Unable to execute query Database error was: Table 'mythtv.dd_v_program' doesn't exist DB Error (Inserting into programgenres table): Query was: INSERT IGNORE INTO programgenres (chanid, starttime, relevance, genre) SELECT chanid, starttime, relevance, class FROM dd_v_program, dd_genre WHERE (dd_v_program.programid = dd_genre.programid); Driver error was [2/1146]: QMYSQL3: Unable to execute query Database error was: Table 'mythtv.dd_v_program' doesn't exist Failed to fetch some program info