[mythtv] Recent change causes schema upgrade failure?

Nigel Pearson nigel at ind.tansu.com.au
Mon Jan 29 03:03:08 UTC 2007


...
2007-01-29 12:02:46.066 Upgrading to schema version 1177
2007-01-29 12:02:46.090 Upgrading to schema version 1178
2007-01-29 12:02:46.091 DB Error (Performing database upgrade):
Query was: ALTER TABLE channel           DROP INDEX sourceid;
Error was: Driver error was [2/1091]:
QMYSQL3: Unable to execute query
Database error was:
Can't DROP 'sourceid'. Check that column/key exists
new version: 1178
2007-01-29 12:02:46.091 Database Schema upgrade FAILED, unlocking.
2007-01-29 12:02:46.091 Couldn't upgrade database to new schema,  
exiting.


I'm not familiar with SQL, but my DB seems to
have a named index channel_src(channum,srcid),
and a PRIMARY index on chanid.

Is that the case with everyone elses'?

Or is mine somehow specially screwed up?

--
Nigel Pearson, nigel at ind.tansu.com.au|"I haven't tested it yet, but
Telstra Net. Eng., Sydney, Australia | it should be perfectly safe."
Office: 9202 3900    Fax:  9261 3912 |"Just a bit or harmless brain
Mobile: 0408 664435  Home: 9792 6998 | manipulation, that's all" -  
Wallace



More information about the mythtv-dev mailing list