[mythtv-users] MySQL upgrade error

Saul A. Peebsen jaglover at gmail.com
Tue Nov 27 23:13:42 UTC 2012


On Tue, 27 Nov 2012 17:41:30 -0500
"Michael T. Dean" <mtdean at thirdcontact.com> wrote:

> 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...

Thanks, how can I find and delete this invalid entry?

-- 
Cheers, Saul


More information about the mythtv-users mailing list