[mythtv-users] DB Error after backport of tv_grab_na_dd

Bill Bradley wbradley at bham.rr.com
Sun May 23 08:54:33 EDT 2004


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



More information about the mythtv-users mailing list