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

[Michael T. Dean]

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