[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