[mythtv] Bug: db upgrade 1038

[Hamish Moffatt]

Hi,

I've just tried to upgrade my CVS install from over a month ago (April
8) to current. The upgrade failed converting the database. The backend
started and failed with the following:

2004-05-12 22:57:09 Upgrading to schema version 1036
2004-05-12 22:57:09 Upgrading to schema version 1037
2004-05-12 22:57:10 Upgrading to schema version 1038
DB Error (Performing database upgrade):
Query was:
ALTER TABLE people ADD UNIQUE name (name(41));
Driver error was [2/1062]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate entry 'Academy Award Winner Nicolas Cage As A Pa' for key 2

Starting it again fails:

2004-05-12 23:04:09 Upgrading to schema version 1038
DB Error (Performing database upgrade):
Query was:
ALTER TABLE videosource ADD lineupid VARCHAR(64) NULL;
Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'lineupid'

I suppose the solution is to try to undo the change, delete all the
records in the people table, and try again.


Thanks,

Hamish
-- 
Hamish Moffatt VK3SB <hamish at debian.org> <hamish at cloud.net.au>