[mythtv-users] DB Error after backport of tv_grab_na_dd

[Bill Bradley]

Hello All,

I followed the directions on the list for setting up DataDirect,
tv_grab_na_dd, and the mythfilldatabasecron_dd.  I am not having any
problems getting the listings, but mythfilldatabase fails following tons
of these insert errors :


> DB Error (programrating insert):
> Query was:
> INSERT INTO programrating (chanid,starttime,system,rating) VALUES (1008, "200405
> 22233000", "VCHIP", "TV-PG");
> Driver error was [2/-1]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate entry '1008-20040522233000-VCHIP-TV-PG' for key 1
> 
> DB Error (program insert):
> Query was:
> INSERT INTO program (chanid,starttime,endtime,title,subtitle,description,categor
> y,category_type,airdate,stars,previouslyshown) VALUES(1009,"20040522230600","200
> 40523000500","She Spies","Remember When","Shane suffers acute memory loss after
> being injected with a drug while under cover, and the spies team up with an ex-c
> on to find an antidote.","Action","","2004","0","0");
> Driver error was [2/-1]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate entry '1009-20040522230600' for key 1
> 
> ### bypassing grabbers, reading directly from file
> Adjusting program database end times...
> 0 replacements made

I have the script set to "offset=-1" to replace data.  I have also tried dumping and 
restoring the mythconverg DB and still get the same problem.  Is this happening to anyone else?
ANy help would be appreciated.

Thanks,
Bill Bradley