[mythtv-users] MySQL upgrade error
Saul A. Peebsen
jaglover at gmail.com
Tue Nov 27 22:32:57 UTC 2012
2012-11-27 16:30:22.225494 C Upgrading to MythTV schema version 1303
2012-11-27 16:30:25.303352 E DB Error (Performing database upgrade):
Query was: UPDATE recorded SET starttime = CONVERT_TZ(starttime,
'SYSTEM', 'UTC'), endtime = CONVERT_TZ(endtime, 'SYSTEM',
'UTC') ORDER BY -starttime Error was: Driver error was [2/1062]:
QMYSQL: Unable to execute query Database error was:
Duplicate entry '1063-0000-00-00 00:00:00' for key 'PRIMARY'
new version: 1303
2012-11-27 16:30:25.303388 E Database schema upgrade failed.
2012-11-27 16:30:25.303609 E Couldn't upgrade database to new schema.
How to fix it?
--
Cheers, Saul
More information about the mythtv-users
mailing list