[mythtv-users] future duplicate recordings???

Michael T. Dean mtdean at thirdcontact.com
Sat Nov 14 18:27:43 UTC 2009


On 11/14/2009 10:36 AM, Yan Seiner wrote:
> I keep getting this in my logs:
>
> 2009-11-14 07:34:30.146 DB Error (change_program):
> Query was:
> UPDATE program SET starttime = ?,     endtime   = ? WHERE chanid    =
> ? AND       starttime = ?
> Bindings were:
> :CHANID=1342, :NEWEND=2009-11-21T05:30:00, :NEWSTART=2009-11-21T02:30:00,
> :OLDSTART=2009-11-21T02:00:00
> Driver error was [2/1062]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Duplicate entry '1342-2009-11-21 02:30:00-0' for key 1
>
> I have duplicate recordings in the future????  And how do I fix this? 

Sounds like EIT doing bad things.

mysql -umythtv -p mythconverg -e 'TRUNCATE TABLE program;'

perhaps?  (And let it refill the listings with the updated data.)

Mike


More information about the mythtv-users mailing list