This is fixed in SVN, though maybe someone should push it to 0.18.1. -- Anduin Withers
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:mythtv-commits- > [EMAIL PROTECTED] On Behalf Of MythTV > Sent: Monday, December 26, 2005 10:26 AM > To: [email protected] > Subject: [mythtv-commits] Ticket #878: Problems with Mythfilldatabase > > #878: Problems with Mythfilldatabase > -----------------------------------+-------------------------------------- > -- > Reporter: [EMAIL PROTECTED] | Owner: ijr > Type: defect | Status: new > Priority: major | Milestone: > Component: mythtv | Version: > Severity: medium | > -----------------------------------+-------------------------------------- > -- > I'm running mysql "Ver 8.41 Distrib 5.0.15, for pc-linux-gnu on i686" and > when i attempt to run mythfilldatabase i get a ton of database errors as > follows: > > 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,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber, > > DB Error (Inserting into dd_schedule): > Query was: > INSERT INTO dd_schedule > > (programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,cl > osecaptioned,tvrating,partnumber,parttotal,endtime) > VALUES('EP7729650001','16320','2006-01-08T15:30:00','00:30:00',0,1,0,0,1 > ,'TV-Y7',0,0,'2006-01-08T16:00:00'); > 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,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber, > > Grab complete. Actual data from Sun Jan 8 08:00:00 2006 to Mon Jan 9 > 08:00:00 2006 (UTC) > Clearing data for source... > Clearing from Sun Jan 8 00:00:00 2006 to Mon Jan 9 00:00:00 2006 > (localtime) > Data for source cleared... > Main temp tables populated. Updating myth channels... > Updating icons for sourceid: 1 > Channels updated.. Updating programs... > 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 'mythconverg.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 = 1 > )); > 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, > > 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 'mythconverg.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 'mythconverg.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 'mythconverg.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 'mythconverg.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 'mythconverg.dd_v_program' doesn't exist > > Adjusting program database end times... > 0 replacements made. > 2005-12-26 10:23:19.066 mythfilldatabase: Listings Download Finished > Marking repeats...found 0 > Unmarking repeats from grabber that fall within our new episode > window...found 0 > 2005-12-26 10:23:19.305 Connecting to backend server: 127.0.0.1:6543 (try > 1 of 5) > 2005-12-26 10:23:19.348 Using protocol version 15 > > -I believe this is a problem that is specific to the syntax used with the > mysql statements in the grabbers.... > > -- > Ticket URL: <http://svn.mythtv.org/trac/ticket/878> > MythTV <http://www.mythtv.org/> > MythTV
_______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
