Lost configuration after database upgrade (during upgrade to 1.8) (1 Viewer)

[alexeix]

Sorry for delayed reply - I don't have a lot of time at the moment, due to a new addition to the family!
...Which is really why I don't want to go through the pain of having to completely reconfigure Media Portal from scratch.

After many hours spent on this issue tonight, I thought I had finally got MP working with my old set-up, but no....

Now, using the Media Portal client on my server, I can watch TV, I can see my channel names and I can see my recordings, but when I try to start the TV-Server Configuration, I get: "Failed to upgrade the database".

I don't understand that, since the client seems to be able to see the data, e.g. recordings, channels, etc.
I researched the error and followed instructions for "Repairing database (MySQL)", but after the repair completed, I got the same problem.
I correctly ran the repair for version 5.6.

Does anyone have any ideas what's next???

One BIG question which I have, is why version 1.8 was not pulled, as soon as it became known that it had this effect?
I would NEVER have installed it if I had known I would have to waste hours recovering my set-up!
In my opinion, this is quite a major issue.

It is really disheartening to go through all this pain (not to mention unnecessary!), even if you love Media Portal.

Thanks in advance for your help.

 

[Sebastiii]

Hi
Congrats for addition family

Testing based on 1.8 (internally) and from published version works good, except that it seems there is some bug
Could you try to post log to see what failed again ?

My time is limited too but we can try IRC chat on #mediaportal channel, i don't have all information on hand right now, but all is describe on Wiki
http://wiki.team-mediaportal.com/1_MEDIAPORTAL_1/16_Support/IRC_Channel

There is a webchat somewhere : http://webchat.freenode.net/

 

[alexeix]

Thanks for the quick reply.
Here are the log files...

 

[Sebastiii]

Thanks

Ok :

[2014-10-08 01:00:06,957] [Log ] [SetupTv ] [INFO ] - ---- upgrade database schema ----
[2014-10-08 01:00:06,973] [Log ] [SetupTv ] [INFO ] - Exec SQL: USE MpTvDb;ALTER TABLE canceledschedule ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE card ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE cardgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE cardgroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channel ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channellinkagemap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channelmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE conflict ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE diseqcmotor ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE favorite ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE groupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE history ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE keyword ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE keywordmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE pendingdeletion ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE personaltvguidemap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE program ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE radiochannelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE radiogroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE recording CHANGE COLUMN fileName fileName VARCHAR(255) NOT NULL;ALTER TABLE recording ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE satellite ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE schedule CHANGE COLUMN programName programName VARCHAR(255) NOT NULL;ALTER TABLE schedule ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE server ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE setting ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE softwareencoder ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE timespan ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE tuningdetail ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE tvmoviemapping ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE version ENGINE=InnoDB ROW_FORMAT=COMPACT;UPDATE version SET versionNumber=62 WHERE idVersion=1;
[2014-10-08 01:00:08,426] [Log ] [SetupTv ] [INFO ] - ********* SQL statement failed! *********
[2014-10-08 01:00:08,426] [Log ] [SetupTv ] [INFO ] - ********* Error reason: Table '.\mptvdb\canceledschedule' already exists
[2014-10-08 01:00:08,426] [Log ] [SetupTv ] [INFO ] - ********* Error code: 1050 *********
[2014-10-08 01:05:07,641] [Log ] [SetupTv ] [INFO ] - ---- SetupTv v1.8.0.0 is starting up on Windows 7 ( Service Pack 1 ) [6.1.7601.65536]
[2014-10-08 01:05:07,719] [Log ] [SetupTv ] [INFO ] - ---- check connection with database ----
[2014-10-08 01:05:08,920] [Log ] [SetupTv ] [INFO ] - SetupDatabaseForm: Added dependency for TvService - MySQL
[2014-10-08 01:05:08,936] [Log ] [SetupTv ] [INFO ] - ---- check if database needs to be updated/created ----
[2014-10-08 01:05:09,138] [Log ] [SetupTv ] [INFO ] - ---- upgrade database schema ----
[2014-10-08 01:05:09,232] [Log ] [SetupTv ] [INFO ] - Exec SQL: USE MpTvDb;ALTER TABLE canceledschedule ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE card ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE cardgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE cardgroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channel ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channellinkagemap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channelmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE conflict ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE diseqcmotor ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE favorite ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE groupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE history ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE keyword ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE keywordmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE pendingdeletion ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE personaltvguidemap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE program ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE radiochannelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE radiogroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE recording CHANGE COLUMN fileName fileName VARCHAR(255) NOT NULL;ALTER TABLE recording ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE satellite ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE schedule CHANGE COLUMN programName programName VARCHAR(255) NOT NULL;ALTER TABLE schedule ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE server ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE setting ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE softwareencoder ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE timespan ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE tuningdetail ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE tvmoviemapping ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE version ENGINE=InnoDB ROW_FORMAT=COMPACT;UPDATE version SET versionNumber=62 WHERE idVersion=1;
[2014-10-08 01:05:15,722] [Log ] [SetupTv ] [INFO ] - ********* SQL statement failed! *********
[2014-10-08 01:05:15,722] [Log ] [SetupTv ] [INFO ] - ********* Error reason: Table '.\mptvdb\canceledschedule' already exists
[2014-10-08 01:05:15,722] [Log ] [SetupTv ] [INFO ] - ********* Error code: 1050 *********

It failed, we really need to take remote assistance or something and test the installer without the upgrade myisam to innodb for existing db

 

[alexeix]

Thanks for the offer (very kind!), but I wouldn't be able to do a remote assistance session before the weekend.
Do you think it's likely that the original configuration can be recovered though?
I wonder if it might be quicker for me to just do a full re-install and then reconfigure Media Portal?

 

[Sebastiii]

You can try re-install with the supplied installer Maybe it can work and if i'm not wrong you have backup mysql data right ?

https://forum.team-mediaportal.com/...de-during-upgrade-to-1-8.127718/#post-1101961

 

[alexeix]

I tried running the installer from the link (https://issues.team-mediaportal.com/browse/MP1-4572),.
Firstly Windows7 advised me not to install it, because it was unsigned.
I then went ahead anyway, but it would not install and I got the following error:
"Installer integrity check has failed. Common causes include incomplete download and damaged media. Contact the installer's author to obtain a new copy."

I downloaded it separately twice, so I don't know what the problem is.

I think I'll just go ahead and do a complete re-install now and try to reconfigure Media Portal over the coming weeks, as and when I have time.
I still have the MySQL 5.1 data directory, but it seems that there's no straightforward way to get my configuration data back.

I've learned a valuable lesson here and I'll be a lot more cautious about upgrading in future.

 

[Sebastiii]

We can try remote session today if you want
Maybe the installer was not uploaded correctly

 

[alexeix]

Sorry - I've only just checked my email.

One question - if I shared the backed up 'data' directory, from my original MySQL 5.1 installation, would you be able to import it and then make a back-up of the configuration?
I could then just reinstall Media Portal 1.8 (along with MySQL 5.6), and import the configuration set-up, etc..
Would that be the quickest, surest solution?

If not, or if you don't have time to do that, I'm free for the next half hour or so, so could do a screen share.
I realise that might not be convenient for you though...

Can you explain a bit about what this customised installation file does and why it might allow me to use my backed up data directory?

 

[Sebastiii]

Hi,

I will be able to help tomorrow morning if you are available you can backup your setting here but not sure i can do something with it but you can always post it