[mythtv-users] DB Error after backport of tv_grab_na_dd

[Mark J. Small]

On Sunday 23 May 2004 09:54, Bill Bradley wrote:
> 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


Yes this is happening to me as well.  I've been ignoring it for now.  I 
switched to tv_grab_na_dd last Wednesday.  

Sorry that I can't give any help, but at least you know that you are not 
alone.

Mark