After emerging mythtv-0.17, running mythbackend fails with the error shown under "Actual results". Also, the init script doesn't notice this failure. Reproducible: Always Steps to Reproduce: Add media-tv/mythtv ~amd64 to /etc/package.keywords emerge mythtv (0.17) run mythbackend Actual Results: mythbackend gives the following output. 2005-02-13 16:51:40.118 Upgrading to schema version 1066 2005-02-13 16:51:40.118 DB Error (Performing database upgrade): Query was: ALTER TABLE capturecard ADD COLUMN firewire_port INT UNSIGNED NOT NULL DEFAULT 0; Error was: Driver error was [2/1060]: QMYSQL3: Unable to execute query Database error was: Duplicate column name 'firewire_port' new version: 1066 2005-02-13 16:51:40.118 Couldn't upgrade database to new schema, exiting. Expected Results: mythbackend should start normally. Also, if it doesn't, the init script should give me scary red exclamation points instead of a happy green OK. $ emerge -pv mythtv These are the packages that I would merge, in order: Calculating dependencies ...done! [ebuild R ] media-tv/mythtv-0.17 +alsa +arts -cle266 -debug -dvb -ieee1394 -lcd +lirc (-mmx) +nls -nvidia* +opengl +xv0 kB
OK, I was able to work around it, basically by deleting all the firewire* columns from the capturecard table in mythconverge. Later I got a similar error, and so I had to delete the column deletepending from recorded. For those of you who know as little about databases as me, the commands are... mysql > connect > use mythconverg; > select * from capturecard; # Then, for each column in that output that has to do with firewire, run > alter table capturecard drop column firewire_whatever # On another console, run mythbackend again, it should get farther... > alter table recorded drop column deletepending # and now mythbackend should work.
This is why CVS is not supported. Install CVS at any point and you get to keep the pieces. The Myth developers didn't provide a clean upgrade path for the database in CVS.. and I'm not about to correct CVS issues.