[mythtv-users] sanity check or repairing DB for 0.22 upgrade.
Michael T. Dean
mtdean at thirdcontact.com
Fri Nov 20 01:58:11 UTC 2009
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
More information about the mythtv-users