[mythtv-users] MySQL upgrade error
Saul A. Peebsen
jaglover at gmail.com
Wed Nov 28 12:27:06 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...
Got it working ... found two invalid entries in database, removed them
by hand, and voila!
More information about the mythtv-users