[mythtv-users] Database error

clemens at dwf.com clemens at dwf.com
Thu May 21 18:12:17 UTC 2009


I am seeing the following database error in the log file from mythbackend.
Is there some program to preen the database???

---

2009-05-21 12:00:55.686 New DB connection, total: 4
2009-05-21 12:00:55.928 Connected to database 'mythconverg' at host: localhost
2009-05-21 12:01:03.542 MainServer::HandleAnnounce Monitor
2009-05-21 12:01:03.726 adding: mythtv.dwf.com as a client (events: 0)
2009-05-21 12:01:03.729 MainServer::HandleAnnounce Monitor
2009-05-21 12:01:03.730 adding: mythtv.dwf.com as a client (events: 1)
2009-05-21 12:01:32.342 Reschedule requested for id -1.
2009-05-21 12:01:32.740 Scheduled 22 items in 0.4 = 0.17 match + 0.21 place
2009-05-21 12:01:38.911 DB Error (change_program):
Query was:
UPDATE program SET starttime = '2009-05-23T13:00:10',     endtime   = 
'2009-05-23T13:30:00' WHERE ch
anid    = 1235 AND       starttime = '2009-05-23T13:00:00'
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry '1235-2009-05-23 13:00:10-0' for key 1

---

                                        Reg.Clemens
                                        reg at dwf.com




More information about the mythtv-users mailing list