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

[Henrik Bentel]

Tried running mythtv-setup first, no change. The setup prints the same
error message to stdout(see below).
starting mythbackend afterwards still gives same error message.

help!

-Henrik



[root at mythtvbox mythtv]# mythtv-setup
2005-04-23 20:49:15.571 New DB connection, total: 1
Total desktop width=1024, height=768, numscreens=1
2005-04-23 20:49:15.576 Using screen 0, 1024x768 at 0,0
2005-04-23 20:49:15.579 Setting Lock for Database Schema upgrade. If
you see a long pause here it means t
he Schema is already locked and is being upgraded by another Myth process.
2005-04-23 20:49:15.580 New DB connection, total: 2
2005-04-23 20:49:15.581 Upgrading to schema version 1072
2005-04-23 20:49:15.582 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 20:49:15.582 Database Schema upgrade FAILED, unlocking.
2005-04-23 20:49:15.621 Switching to square mode (G.A.N.T.)
mythtv: could not open config file /root/.mythtv/lircrc
mythtv: No such file or directory
Failed to read lirc config /root/.mythtv/lircrc for mythtv
2005-04-23 20:49:16.078 Joystick disabled.



On 4/23/05, Henrik Bentel <hbentel at gmail.com> wrote:
> 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
>