<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello Mythgroup,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I recently tried to upgrade my installation of myth
cause I noticed that the new stuff is all packaged nice (in three
packages). Anyway, I built it from CVS like normal... uninstalled my old
one first and install the new one. When I run mythbackend I get the
following error:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>2005-04-13 20:23:58.545 New DB connection, total:
1<BR>2005-04-13 20:23:58.547 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.<BR>2005-04-13 20:23:58.548 New DB connection,
total: 2<BR>2005-04-13 20:23:58.549 Upgrading to schema version
1079<BR>2005-04-13 20:23:58.549 DB Error (Performing database upgrade):<BR>Query
was: ALTER TABLE capturecard ADD COLUMN dvb_hw_decoder INT DEFAULT '0';<BR>Error
was: Driver error was [2/1060]:<BR>QMYSQL3: Unable to execute query<BR>Database
error was:<BR>Duplicate column name 'dvb_hw_decoder'</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>new version: 1079<BR>2005-04-13 20:23:58.550
Database Schema upgrade FAILED, unlocking.<BR>2005-04-13 20:23:58.550 Couldn't
upgrade database to new schema<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I'm brand new to mysql and learned a little off the
web (basically how to look at tables). I checked out the capturecard table
and it looks like that dvb_hw_decoder does exist. Any idea how I can fix
it without trashing my DB?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>-Greg</DIV></FONT></BODY></HTML>