<br><br><div class="gmail_quote">On Sat, Nov 7, 2009 at 9:08 PM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im"><br></div>
Backup your database ( <a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore" target="_blank">http://www.mythtv.org/wiki/Database_Backup_and_Restore</a> ).<br>
<br>
Then:<br>
<br>
cat << "EOF" | mysql -umythtv -p mythconverg<br>
DROP TABLE IF EXISTS videocast;<br>
DROP TABLE IF EXISTS videocategory;<br>
DROP TABLE IF EXISTS videocountry;<br>
DROP TABLE IF EXISTS videogenre;<br>
DROP TABLE IF EXISTS videometadata;<br>
DROP TABLE IF EXISTS videometadatacast;<br>
DROP TABLE IF EXISTS videometadatacountry;<br>
DROP TABLE IF EXISTS videometadatagenre;<br>
DROP TABLE IF EXISTS videotypes;<br>
DROP TABLE IF EXISTS filemarkup;<br>
DROP TABLE IF EXISTS dvdinput;<br>
DROP TABLE IF EXISTS dvdtranscode;<br>
DELETE FROM settings WHERE value<br>
IN ('mythvideo.DBSchemaVer',<br>
'VideoDBSchemaVer',<br>
'DVDDBSchemaVer');<br>
EOF<br>
<br>
Then start mythfrontend and it should re-create the video/DVD schema for you.<br>
<br>
I'm guessing at one point in the past you had only MythDVD or MythVideo installed back when they were separate plugins.<br>
<br>
Mike</blockquote><div><br></div><div>I was having a similar problem after going from Ubuntu 9.04 to Ubuntu 9.10 (and Myth 0.21 to 0.22). I cleared the database per the commands above, and now mythfrontend starts without a segfault!</div>
<div><br></div><div>The problem now is that the Video Manager doesn't find any files when I try to scan for them. I get the following on the terminal:</div><div>Database error was:</div><div>Table 'mythconverg.videometadata' doesn't exist</div>
<div><br></div><div>So it looks like the video/DVD schema was not re-created correctly. How can I do it manually so I can watch videos again? (at least I can watch recordings on 0.22 now, yay!)</div><div><br></div><div>Mariano </div>
</div>