[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,
> 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.)
More information about the mythtv-users