MythTV
Mon, 26 Dec 2005 10:26:18 -0800
#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,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....
--
Ticket URL: <http://svn.mythtv.org/trac/ticket/878>
MythTV <http://www.mythtv.org/>
MythTV_______________________________________________ mythtv-commits mailing list mythtv-commits@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-commits