[mythtv-users] sanity check or repairing DB for 0.22 upgrade.
andersonas at comcast.net
Fri Nov 20 23:28:24 UTC 2009
On Thursday 19 November 2009 18:58:11 Michael T. Dean wrote:
> On 11/19/2009 06:41 PM, Alan Anderson wrote:
> > I have tried a full backup/restore under 0.21. it still fails if I try
> > to use the restored DB under mythtv 0.22..
> > But only on the mythvideo schema update. The rest appear to update OK.
> > 2009-11-19 15:27:24.012 Upgrading to MythVideo schema version 1017
> > 2009-11-19 15:27:24.240 DB Error (performActualUpdate):
> > Query was:
> > ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
> > Driver error was [2/1283]:
> > QMYSQL3: Unable to execute statement
> > Database error was:
> > Column 'filename' cannot be part of FULLTEXT index
> > 2009-11-19 15:27:24.241 Couldn't upgrade video database schema, exiting.
> > 2009-11-19 15:27:24.241 Unable to initialize plugin 'mythvideo'.
> > Or can I drop just the mythvideo portion and reset that part?
> That's really probably the fastest/easiest way to fix it. See
> mythtv-users mailing list
> mythtv-users at mythtv.org
That appear to take care of it So not exactly DB corruption just a
particular upgrade path over the years. Easy enough to fix once you know
More information about the mythtv-users