[mythtv-users] MySQL upgrade error

[Michael T. Dean]

On 11/27/2012 05:32 PM, Saul A. Peebsen wrote:
> 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?
>

You've got invalid data in your database showing a recording that 
started at 00:00:00 on 0000-00-00 or broken MySQL install whose 
CONVERT_TZ() function isn't working...

Mike