[mythtv] Error w/ MythFillDatabase

Jamie Richard myth at jttechnology.com
Sun Mar 16 17:50:10 EST 2003


My MythTV hasn't worked in weeks, since I haven't had time to fix it.  I pulled a chunk of the error that I get when I run mythfilldatabase.

It runs through and downloads the data, then gives me many errors like these:

Query was:
INSERT INTO program (chanid,starttime,endtime,title,subtitle,description,category,airdate,stars) VALUES(1037,"20030317120000","20030317130000","Unsolved Mysteries","", "","Doc","0","0");
Driver error was:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'airdate' in 'field list'
DB Error (programrating insert):
Query was:
INSERT INTO programrating (chanid,starttime,system,rating) VALUES (1037, "20030317120000", "VCHIP", "PG");
Driver error was:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.programrating' doesn't exist
DB Error (program insert):
Query was:
INSERT INTO program (chanid,starttime,endtime,title,subtitle,description,category,airdate,stars) VALUES(1037,"20030317130000","20030317150000","Blood on Her Hands","", "A woman convinces her lover to kill her husband, then tries to frame him.","Mystery","1998","0.5");
Driver error was:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'airdate' in 'field list'
DB Error (programrating insert):
Query was:
INSERT INTO programrating (chanid,starttime,system,rating) VALUES (1037, "20030317130000", "VCHIP", "14");
Driver error was:

On, and On.

What Can I Do?

-Jamie


-------------- next part --------------
An HTML attachment was scrubbed...
URL: /pipermail/attachments/20030316/2ef0a88d/attachment.htm


More information about the mythtv-dev mailing list