Arch Linux

timm

Member

From: Wisconsin

Registered: 2004-02-25

Posts: 417

Mythtv schema update fails

Upgrading mythtv to the latest version via pacman, all installs, apparently correctly.  You need to run mythtv-setup to update the schema, when I did this it failed.  There is a backup database created, so I dropped the new one, created mythconverg again, imported the backup database into it, and ran it from the command line.  The schema updates go fine until it gets to 1181, at which point it errors out.

Error was: Driver error was [2/1062]

Database error was: Duplicate entry '1045 -2008-04-02 17:00:00-5-0' for key 1

There is a script in contrib to optimize the database, I've tried that.  It complains at first but runs without intervention, this does not change the upgrade result.

Is this fixable?  I don't know enough mysql to dig into the guts of the thing.

sash

Member

Registered: 2005-10-16

Posts: 155

Re: Mythtv schema update fails

Error was: Driver error was [2/1062]

Database error was: Duplicate entry '1045 -2008-04-02 17:00:00-5-0' for key 1

Can you also post the name of the table for which this error is happening?