[mythtv] mythtv database schema upgrade 1108->1109: Duplicate column name 'generic' (was: Upgrade problems)

[Axel Thimm]

On Wed, Feb 22, 2006 at 08:04:13PM -0800, Merlisk wrote:
> 2006-02-22 21:31:43.581 Current Schema Version: 1108
> 2006-02-22 21:31:43.590 Newest Schema Version : 1123
> [...]
> 2006-02-22 21:31:43.606 Upgrading to schema version
> 1109
> 2006-02-22 21:31:43.608 DB Error (Performing database
> upgrade): 
> Query was: ALTER TABLE oldrecorded ADD COLUMN generic
> TINYINT(1) DEFAULT 0; 
> Error was: Driver error was [2/1060]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate column name 'generic'
>  
> new version: 1109
> 2006-02-22 21:31:43.608 Database Schema upgrade
> FAILED, unlocking.
> 2006-02-22 21:31:43.609 Couldn't upgrade database to
> new schema

This was mentioned here before

http://lists.atrpms.net/pipermail/atrpms-users/2006-February/004540.html

and was also discussed upstream

http://mythtv.org/pipermail/mythtv-dev/2006-February/045366.html

which also contains a solution.
-- 
Axel.Thimm at ATrpms.net
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 191 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-dev/attachments/20060223/ca41ae23/attachment.pgp