[mythtv-users] MySQL upgrade error
Michael T. Dean
mtdean at thirdcontact.com
Tue Nov 27 22:41:30 UTC 2012
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...
More information about the mythtv-users