[mythtv-users] upgrading database from ATRPMS

[Jackie Meese]

> How do I upgrade the database from ATRPMS latest to source?
>
> Currently I'm getting the following error:
>
> 2007-01-16 22:00:57.683 Upgrading to schema version 1165
> 2007-01-16 22:00:57.685 DB Error (Performing database upgrade):
> Query was: CREATE INDEX program_manualid ON program (manualid);
> Error was: Driver error was [2/1061]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate key name 'program_manualid'
>
>
> and trying to restart after that gave me
>
> new version: 1165
> 2007-01-16 22:00:57.685 Database Schema upgrade FAILED, unlocking.
> 2007-01-16 22:00:57.686 Couldn't upgrade database to new schema,  
> exiting.

To fix this problem (which just moved at stable with the new relesase,  
I ran the following mysql command:
  ALTER TABLE `program` DROP INDEX `program_manualid`

The auto update script put this index back.

j.