<p><br>
On 31 Dec 2010 18:19, "Nick Morrott" <<a href="mailto:knowledgejunkie@gmail.com">knowledgejunkie@gmail.com</a>> wrote:<br>
><br>
> On 31 December 2010 15:53, Richard Morton <<a href="mailto:richard.e.morton@gmail.com">richard.e.morton@gmail.com</a>> wrote:<br>
> > Hi There,<br>
> ><br>
> > Thanks for the email however I have no issues with restoring the 0.23<br>
> > database. I have an issue with mythbackend not upgrading it to 0.24<br>
> > successfully.<br>
><br>
> The upgrade is failing due to the presence of a(t least one) table<br>
> that should not exist at the reported schema version of 1257. Checking<br>
> the relevant source [1] shows that the schema upgrade from 1257 to<br>
> 1258 creates 2 new tables, so can delete them (but keep that backup<br>
> handy):<br>
><br>
> $ mysql -u <username> -p mythconverg<br>
><br>
> mysql> DROP TABLE IF EXISTS internetcontent;<br>
> mysql> DROP TABLE IF EXISTS internetcontentarticles;<br>
> mysql> exit;<br>
><br>
> This should permit this particular schema upgrade to succeed, but<br>
> without knowing how far the broken upgrade got it's difficult to say<br>
> how much more poking will be required. However, there are no more<br>
> table creates/drops in the schema update process.<br>
><br>
> [1] <a href="http://code.mythtv.org/fisheye/browse/~raw,r=81f3a7e0586df4ca9c0880480a30f9b3faa1036b/mythtv/mythtv/libs/libmythtv/dbcheck.cpp">http://code.mythtv.org/fisheye/browse/~raw,r=81f3a7e0586df4ca9c0880480a30f9b3faa1036b/mythtv/mythtv/libs/libmythtv/dbcheck.cpp</a><br>
><br>
> Cheers,<br>
> Nick</p>
<p>Thanks but the problem is that they dont exist and yet it is failing. I can copy the command stated as being the failure point and paste it into a mysql terminalbusing the same credentials and the table is created with no errors.</p>
<p>R<br></p>
<p>><br>
> --<br>
> Nick Morrott<br>
><br>
> MythTV Official wiki: <a href="http://mythtv.org/wiki/">http://mythtv.org/wiki/</a><br>
> MythTV users list archive: <a href="http://www.gossamer-threads.com/lists/mythtv/users">http://www.gossamer-threads.com/lists/mythtv/users</a><br>
><br>
> "An investment in knowledge always pays the best interest." - Benjamin Franklin<br>
> _______________________________________________<br>
> mythtv-users mailing list<br>
> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
> <a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</p>