[mythtvnz] Daylight Saving Reversion

Tortise tortise at paradise.net.nz
Sun Apr 4 01:34:45 BST 2010


I don't think my box has coped with daylight saving reversion, with program listings being an hour out today.
OK, reboot.  Same.  Hmmm  Run mythfilldatabase again as it last ran at 0204am.

I get 

2010-04-04 12:28:24.164 IconData: Updating icons for sourceid: 1
2010-04-04 12:28:25.415 DB Error (programrating insert):
Query was:
INSERT INTO programrating        ( chanid, starttime, system, rating) VALUES (?, ?,    ?,  ?)
Bindings were:
:CHANID=1006, :RATING=G, :START=2010-04-04T14:35:00, :SYS=Freeview
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1006-2010-04-04 14:35:00-Freeview-G' for key 'chanid'

2010-04-04 12:28:26.197 Updated programs: 4 Unchanged programs: 2051

Also makes me wonder if its anything to do with Robin's problem?



More information about the mythtvnz mailing list