[mythtv-users] mythfilldatabase / insert errors..
Andy Davidoff
dert at pobox.com
Tue Mar 18 16:24:38 UTC 2003
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 at pobox.com */
More information about the mythtv-users
mailing list