Preston wrote: > > > I just upgraded from slightly pre-0.17 CVS code to today's > CVS code, and when I try to start mythbackend, it tells me: > > 2005-02-23 23:51:29.651 New DB connection, total: 1 > 2005-02-23 23:51:29.656 Upgrading to schema version 1072 > 2005-02-23 23:51:29.658 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-02-23 23:51:29.662 Couldn't upgrade database to new schema > > Any suggestions?
Yes. First backup your database. Then remove the manualid column from the program table either by using something like webmin or remove it from the backup and restore (you may want to add the --add-drop-tables line to the mysqldump if you go down that route) I had to go through that for a few tables going from CVS to 0.17 HTH Druid
_______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
