[mythtv-users] 0.23 to 0.24 upgrade; database wont upgrade
richard.e.morton at gmail.com
Fri Dec 31 18:42:17 UTC 2010
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>
> > 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  shows that the schema upgrade from 1257 to
> 1258 creates 2 new tables, so can delete them (but keep that backup
> $ 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.
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.
> Nick Morrott
> MythTV Official wiki: http://mythtv.org/wiki/
> MythTV users list archive:
> "An investment in knowledge always pays the best interest." - Benjamin
> mythtv-users mailing list
> mythtv-users at mythtv.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users