[mythtv-users] Can no longer schedule recordings

[The GUIGuy]

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

2008-06-22 22:10:30.312 DB Error (programrating insert):
Query was:
INSERT INTO programrating (chanid,starttime,system,rating) VALUES 
(1023,'2008-06-22T17:45:00','ABA','G');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1023-2008-06-22 17:45:00-ABA-G' for key 1

2008-06-22 22:10:30.349 DB Error (programrating insert):
Query was:
INSERT INTO programrating (chanid,starttime,system,rating) VALUES 
(1023,'2008-06-22T21:25:00','ABA','G');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1023-2008-06-22 21:25:00-ABA-G' for key 1

2008-06-22 22:10:30.384 DB Error (programrating insert):
Query was:
INSERT INTO programrating (chanid,starttime,system,rating) VALUES 
(1023,'2008-06-22T21:58:00','ABA','G');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1023-2008-06-22 21:58:00-ABA-G' for key 1

2008-06-22 22:10:30.394 DB Error (programrating insert):
Query was:
INSERT INTO programrating (chanid,starttime,system,rating) VALUES 
(1023,'2008-06-22T22:35:00','ABA','G');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1023-2008-06-22 22:35:00-ABA-G' for key 1

2008-06-22 22:10:35.083 DB Error (programrating insert):
Query was:
INSERT INTO programrating (chanid,starttime,system,rating) VALUES 
(1003,'2008-06-22T20:30:00','ABA','M');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1003-2008-06-22 20:30:00-ABA-M' for key 1

2008-06-22 22:10:35.878 DB Error (programrating insert):
Query was:
INSERT INTO programrating (chanid,starttime,system,rating) VALUES 
(1030,'2008-06-22T20:30:00','ABA','M');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1030-2008-06-22 20:30:00-ABA-M' for key 1

2008-06-22 22:10:40.116 DB Error (programrating insert):
Query was:
INSERT INTO programrating (chanid,starttime,system,rating) VALUES 
(1080,'2008-06-22T18:30:00','ABA','PG');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1080-2008-06-22 18:30:00-ABA-PG' for key 1

2008-06-22 22:10:40.123 DB Error (programrating insert):
Query was:
INSERT INTO programrating (chanid,starttime,system,rating) VALUES 
(1080,'2008-06-22T20:30:00','ABA','M l');
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1080-2008-06-22 20:30:00-ABA-M l' for key 1

2008-06-22 22:10:40.682 Updated programs: 146 Unchanged programs: 6400
/END


Thanks


GuiGuy