[mythtv-users] Database error

[Mike Perkins]

On 02/12/12 15:19, R KANNAN wrote:
> Hello,
>
> I have a persistent database error from mythtv backend the recent occurence
> of which says...
>
> DB Error (change_program): Query was: UPDATE program SET starttime = ?,
> endtime = ? WHERE chanid = ? AND starttime = ? Bindings were: :CHANID=1202,
> :NEWEND=2012-12-02T08:30:00, :NEWSTART=2012-12-02T07:30:00,
> :OLDSTART=2012-12-02T07:00:00 Driver error was [2/1062]: QMYSQL3: Unable to
> execute statement Database error was: Duplicate entry '1202-2012-12-02
> 07:30:00-0' for key 'PRIMARY'
>
>
> The channel ID 1202 is a local channel here and I do not have a recording
> rule for recording anything on that channel. How can I eleminate this?
>
I'd suspect a database error if this keeps repeating. Have you run 
optimize_mythdb.pl recently?

-- 

Mike Perkins