Opened 14 years ago

Closed 14 years ago

Last modified 14 years ago

#878 closed defect (wontfix)

Problems with Mythfilldatabase

Reported by: locutus233ca@… Owned by: Isaac Richards
Priority: major Milestone: unknown
Component: mythtv Version: 0.18.1
Severity: medium Keywords:
Cc: Ticket locked: no

Description

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,closecaptioned,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....

Change History (3)

comment:1 Changed 14 years ago by Anduin Withers <awithers@…>

Version: 0.18.1

comment:2 Changed 14 years ago by bjm <bjm@…>

Resolution: wontfix
Status: newclosed

Change repeat to isrepeat in ./libs/libmythtv/datadirect.cpp or use an earlier version of MySQL or a later version of MythTV.

comment:3 Changed 14 years ago by pkahle

This seems to actually be fixed in code, as of revision 8389. Is it worth changing this report to reflect that?

Note: See TracTickets for help on using tickets.