I am having a problem with the upgrade of mythtv 0.21 to 0.22 running
FC11. Both mythtv-setup and mythbackend request an upgrade of the
database and even if selinux is turned off it fails to upgrade existing
databases from 0.21. So I tried to DROP the existing database and use
mc.sql to create the default 0.22 database which one would think would
not require an upgrade. But it tries to upgrade it with the diagnostic
Newest MythTV Schema Version : 1244
2010-01-02 15:51:02.781 Upgrading to MythTV schema version 1231
2010-01-02 15:51:02.804 DB Error (Performing database upgrade):
Query was: ALTER TABLE dtv_multiplex ADD COLUMN default_authority
varchar(32) CHARACTER SET utf8 NOT NULL default '';
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate column name 'default_authority'
new version: 1231
2010-01-02 15:51:02.805 Database Schema upgrade FAILED, unlocking.
2010-01-02 15:51:02.805 Couldn't upgrade database to new schema.
Can anyone see what I am doing wrong ?
Thanks..
Allen
**************mail from:
Prof. C. Allen Bush, Dept. of Chemistry, Univ. Maryland Baltimore County,
1000 Hilltop Circle; Baltimore, MD 21250. e-mail: [email protected]
website: http://userpages.umbc.edu/~bush/
phone: (410) 455-2506 fax: (410) 455-2608
**************
_______________________________________________
atrpms-users mailing list
[email protected]
http://lists.atrpms.net/mailman/listinfo/atrpms-users