[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