[mythtv-users] Can no longer schedule recordings

[Michael T. Dean]

On 06/22/2008 08:19 AM, The GUIGuy wrote:
> Brad DerManouelian wrote
>> Run mythfilldatabase and check your logs to see why it's not inserting  
>> data into the database.
> I'm getting a bunch of duplicate key errors:
>
> Query was:
> 2008-06-22 22:10:28.198 New DB connection, total: 4
> 2008-06-22 22:10:28.199 Connected to database 'mythconverg' at host: 
> localhost
> 2008-06-22 22:10:29.733 DB Error (programrating insert):
>
> INSERT INTO programrating (chanid,starttime,system,rating) VALUES 
> (1022,'2008-06-22T17:45:00','ABA','G');
> Driver error was [2/1062]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate entry '1022-2008-06-22 17:45:00-ABA-G' for key 1

Assuming your database isn't broken (and that it's purely a broken data 
/in/ the database thing), 
http://www.gossamer-threads.com/lists/mythtv/users/264034#264034 should 
work.  I recommend doing both the video source and capture card part.

Mike