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?

I don't know enough about SQL to remove the column from the table so
that it can add it back in, and I'm not sure that I really want to do
that anyway.  My other thought is to tell it that the database is
already in the right format or to hack the code to ignore that error and
continue.

--PC

_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Reply via email to