[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