[mythtv] Recent change causes schema upgrade failure?
Chris Pinkham
cpinkham at bc2va.org
Mon Jan 29 04:07:28 UTC 2007
* On Mon Jan 29, 2007 at 02:03:08PM +1100, Nigel Pearson wrote:
> 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
> 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.
This matches mine, I don't have a 'sourceid' index.
I just committed a patch to remove that drop index line.
--
Chris
More information about the mythtv-dev
mailing list