[mythtv-users] sanity check or repairing DB for 0.22 upgrade.

Alan Anderson 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
>
> http://www.gossamer-threads.com/lists/mythtv/users/406462#406462
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


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 
about it.

Thanks Mike


Alan


More information about the mythtv-users mailing list