I upgraded to .17 and get this error. I had a power failure yesterday. Is it possible to fix without deleting the database. I have no viable backup. If not how do I delete the database? Thanks.
2005-02-16 10:01:21.447 Upgrading to schema version 1069 2005-02-16 10:01:21.448 DB Error (Performing database upgrade): Query was: ALTER TABLE recorded ADD COLUMN deletepending TINYINT(1) NOT NULL DEFAULT 0; Error was: Driver error was [2/1060]: QMYSQL3: Unable to execute query Database error was: Duplicate column name 'deletepending'
new version: 1069 2005-02-16 10:01:21.449 Couldn't upgrade database to new schema [EMAIL PROTECTED] ~]$
1)
mysql -u mythtv -pmythtv mythconverg
2)
ALTER TABLE recorded DROP COLUMN deletepending; quit
3)
mythbackend
-- bjm
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
