[mythtv-users] 0.23 to 0.24 upgrade; database wont upgrade

[Richard Morton]

On 31 Dec 2010 18:19, "Nick Morrott" <knowledgejunkie at gmail.com> wrote:
>
> On 31 December 2010 15:53, Richard Morton <richard.e.morton at gmail.com>
wrote:
> > Hi There,
> >
> > Thanks for the email however I have no issues with restoring the 0.23
> > database. I have an issue with mythbackend not upgrading it to 0.24
> > successfully.
>
> The upgrade is failing due to the presence of a(t least one) table
> that should not exist at the reported schema version of 1257. Checking
> the relevant source [1] shows that the schema upgrade from 1257 to
> 1258 creates 2 new tables, so can delete them (but keep that backup
> handy):
>
> $ mysql -u <username> -p mythconverg
>
> mysql> DROP TABLE IF EXISTS internetcontent;
> mysql> DROP TABLE IF EXISTS internetcontentarticles;
> mysql> exit;
>
> This should permit this particular schema upgrade to succeed, but
> without knowing how far the broken upgrade got it's difficult to say
> how much more poking will be required. However, there are no more
> table creates/drops in the schema update process.
>
> [1]
http://code.mythtv.org/fisheye/browse/~raw,r=81f3a7e0586df4ca9c0880480a30f9b3faa1036b/mythtv/mythtv/libs/libmythtv/dbcheck.cpp
>
> Cheers,
> Nick

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.

R

>
> --
> Nick Morrott
>
> MythTV Official wiki: http://mythtv.org/wiki/
> MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users
>
> "An investment in knowledge always pays the best interest." - Benjamin
Franklin
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20101231/3dd9a139/attachment.htm>