[mythtv] mythfilldatabase --file complains on old data

Oscar Carlsson webmaster at trekotor.se
Thu Jan 27 11:38:47 EST 2005


Scott RoLanD wrote, On 2005-01-27 15:29:
<snip>
> Updating icons for sourceid: 1
> DB Error (program insert):
> Query was:
> INSERT INTO program (chanid,starttime,endtime,title,title_pronounce,subtitle,description,category,category_type,airdate,stars,previouslyshown) VALUES(1127,'20050126174500','20050127000000','Videiamo','','','Fascia di programmazione di video musicali.','Musica','','2005','0',0);
> Driver error was [2/1062]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate entry '1127-2005-01-26 17:45:00' for key 1

I've got an update to mythfilldatabase that'll probably go into cvs soon 
that amongst other things addresses this. In the meantime, just truncate 
the program table manually before updating.

/O


More information about the mythtv-dev mailing list