Mailing List Archive: mythfilldatabase / insert errors..

I'm stumped on this one:

INSERT INTO program
(chanid,starttime,endtime,title,subtitle,description,category,airdate,stars)
VALUES(1358,"20030324233000","20030325000000","Lou Dobbs Moneyline","",
"Financial news and features.","Talk","0","0");
Driver error was:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1358-20030324233000' for key 1
Adjusting program database end times...

I can't seem to get mythfilldatabase to work lately. I'm using CVS from
Saturday. When I run mythfilldatabase with no parameters I get the above
error for tomorrow and the program stops. I tried downloading the program
listings to a file with tv_grab_na and then running mythfilldatabase
--file and it produced an error like above for each day. It seems like
it's always channel 358 too.

On a side note, does anyone know of a description of how the tables relate
to one another? Maybe a diagram of some sort?

...Kevin

Sounds like you have a duplicate channel defined in your xmltv configuration;
edit ~mythuser/*.xmltv and comment out all but one "channel: 358" line.
Make sure you also
delete from program where chanid = 1358;
before running mythfilldatabase so that your database has consistent data.

#if Kevin J. Slater /* Mar 18, 07:04 */
> I'm stumped on this one:
>
> INSERT INTO program
> (chanid,starttime,endtime,title,subtitle,description,category,airdate,stars)
> VALUES(1358,"20030324233000","20030325000000","Lou Dobbs Moneyline","",
> "Financial news and features.","Talk","0","0");
> Driver error was:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate entry '1358-20030324233000' for key 1
> Adjusting program database end times...
#endif /* kslater@pobox.com */