[mythtv-users] DB schema upgrade failing for .18

[Henrik Bentel]

Hi

I'm having trouble upgrading to .18. Rather I upgrade (from .17 to .18
, using atrpms ) and mythtvbackend process keeps dying.
It attempts to upgrade the DB schema but this fails and the 
process dies. Log below.

Hope someone can help

-Henrik


2005-04-23 15:05:21.396 New DB connection, total: 1
2005-04-23 15:05:21.437 Setting Lock for Database Schema upgrade. If
you see a long pause here it means the Schema is already locked and is
being up
graded by another Myth process.
2005-04-23 15:05:21.439 New DB connection, total: 2
2005-04-23 15:05:21.441 Upgrading to schema version 1072
2005-04-23 15:05:21.443 DB Error (Performing database upgrade):
Query was: ALTER TABLE program ADD COLUMN manualid INT UNSIGNED NOT
NULL DEFAULT 0;
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'manualid'

new version: 1072
2005-04-23 15:05:21.445 Database Schema upgrade FAILED, unlocking.
2005-04-23 15:05:21.446 Couldn't upgrade database to new schema