[mythtv-users] Database issue after upgrade to 0.20

Beny Spensieri Jr benyjr at yahoo.ca
Wed Nov 15 00:25:58 UTC 2006


Hi I updated to MythTV 0.20 using yum on FC4 x86_64.

The install is pretty standard following Jarod's
HowTo.

Now I am getting the following error when launching
mythfrontend or mythbackend:

2006-11-14 19:18:41.436 Using runtime prefix = /usr
2006-11-14 19:18:41.517 New DB connection, total: 1
2006-11-14 19:18:41.522 Connected to database
'mythconverg' at host: localhost
2006-11-14 19:18:41.525 Current Schema Version: 1153
2006-11-14 19:18:41.525 Newest Schema Version : 1160
2006-11-14 19:18:41.526 New DB connection, total: 2
2006-11-14 19:18:41.526 Connected to database
'mythconverg' at host: localhost
2006-11-14 19:18:41.527 Setting Lock for Database
Schema upgrade. If you see a long pause here it means
the Schema is already locked and is being upgraded by
another Myth process.
2006-11-14 19:18:41.528 New DB connection, total: 3
2006-11-14 19:18:41.528 Connected to database
'mythconverg' at host: localhost
2006-11-14 19:18:41.529 Upgrading to schema version
1154
2006-11-14 19:18:41.529 DB Error (Performing database
upgrade):
Query was: ALTER TABLE capturecard ADD diseqcid
INT(10) UNSIGNED default NULL;
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'diseqcid'

new version: 1154
2006-11-14 19:18:41.530 Database Schema upgrade
FAILED, unlocking.
2006-11-14 19:18:41.530 Couldn't upgrade database to
new schema

Does anyone know what went wrong and what I need to do
to relove this issue?  My system is pretty much down
until then.

Thanks,

Beny

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the mythtv-users mailing list