[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