[mythtv] RE: [mythtv-commits] Ticket #878: Problems with Mythfilldatabase

[Anduin Withers]

This is fixed in SVN, though maybe someone should push it to 0.18.1.

-- 
Anduin Withers

> -----Original Message-----
> From: mythtv-commits-bounces at mythtv.org [mailto:mythtv-commits-
> bounces at mythtv.org] On Behalf Of MythTV
> Sent: Monday, December 26, 2005 10:26 AM
> To: mythtv-commits at mythtv.org
> Subject: [mythtv-commits] Ticket #878: Problems with Mythfilldatabase
> 
> #878: Problems with Mythfilldatabase
> -----------------------------------+--------------------------------------
> --
>  Reporter:  locutus233ca at yahoo.ca  |       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