[mythtv-users] Fresh install, struggling to change imported db schema

[Michael T. Dean]

On 05/27/2012 05:42 AM, Damian wrote:
> Hello all,
>
> Here's my story :-)
>
> I've had MythTV running on Ubuntu (via the addition of Mythbuntu) for 
> a few years. It's been fine for most of that time.
>
> Upgrading to 0.25 broke things (it did a 'partial upgrade') and 
> upgrading to Ubuntu 12.04 didn't fix them.
>
> I then formatted the file system and home partitions and installed a 
> pure Mythbuntu system. However, I came across the same problem I am 
> about to describe below, and also wasn't keen on a couple of things 
> about XFCE. So, yesterday I installed a fresh Ubuntu 12.04 system.
>
> I have added the Mythbuntu packages and managed to import my old 
> database.
>
> The problem I'm having is when I click to launch the backend set up, 
> I'm told:
>
> "MythTV wants to upgrade your database for the TV schema, from 1276 to 
> 1299".
>
> I click the relevant buttons to allow this, but it doesn't seem to 
> work, as the next time I click on the back end set up it tells me the 
> same thing.
>
> If it helps at all, I'm also seeing this message inside pypmyadmin:
>
> "connection for controluser as defined in your configuration failed".
>
> Any tips?

Need backend log files showing the failed upgrade.

However, I recommend using mythtv-setup to upgrade the database, instead 
of mythtv-setup.

That said, the failure at, specifically, 1277 is almost definitely:

http://www.gossamer-threads.com/lists/mythtv/users/517981#517981

which means you need to go back to the pre-upgrade database backup (the 
1264 schema version backup) and restore it properly.  If you don't have 
the 1264 database backup, there will be /much/ more work involved in 
fixing things properly.

Mike