Upgrade of 1.5 with 1.6 does not upgrade MySQL 5.1 to 5.6 (1 Viewer)

Iwen

Portal Pro
August 14, 2007
464
32
Germany Germany
Country flag
I'm curious. Are your database tables now in InnoDB format? I would bet they are still all MyISAM.
Following the steps at http://wiki.team-mediaportal.com/1_..._Tool)/Update_to_MySQL_5.6#Useful_information, I do have InnoDB.
Default will be set as InnoDB for MySQL 5.6. AFAIK the same was true for MySQL 5.1. However, that doesn't mean that the tables themselves will be in InnoDB format. Before MP 1.6, we explicitly set the table format to MyISAM.
That is exactly what I was thinking.

You installed MySQL 5.6 but configured the database connection with MP1.5. So, in this case MP creates 'mptvdb' with MyISAM format.
After that you updated MP to 1.6. The installer found an existing database and left it unchanged. That means, that your tables remain in the same format as before.
To overcome this situation you have to delete the 'mptvdb' database (use the Workbench) and configure the TV-Server database connection again. In your tutorial these are the steps 6-9. After that MP1.6 will create a new database with the new InnoDB format.

To check the format you can use this sql command (also in the Workbench, when you have connected to your database):
Code:
SELECT `TABLE_NAME`, `ENGINE` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA` = 'mptvdb';
 

mrspock

Portal Pro
September 14, 2008
124
32
Madrid
Spain Spain
Thanks a lot to both, @mm1352000 and @Iwen, for your great help. :D

I checked the format, with the sql command, and you both were right (I was not aware when the db is created and that it was in the old format). I did as Iwen told, and now is InnoDB format. (y)

I will edit my original post to modify step 1 and to remove the idea of installing MP 1.6 after that. This will help other users, as well.

I suggest you read the MySQL documentation if you want to customise.
The screenshots shows that there should be information about the choice on the right hand side.
That documentation does not provide further information to me, as the main things are explained in the screenshots. Reading that screenshots is why I decided my installation options, as I was not able to find recommendations for MP.
It is completely personal choice. There is no "best for MP"; it is "best for you".
The "best for me" is what is "best for MP" and the performance of my HTPC (99% dedicated to MP). I do not have an especial interest of customising it as far as MP works ok, but just wanted to use the same options used in the MP 1.6 installer when doing a fresh install (I trust on the dev team knowledge).
 
Last edited:

Sigpi007

Portal Pro
November 14, 2012
104
38
Chicago, IL
United States of America United States of America
Hope this could be useful to somebody. (y)
Thanks Mrspock for the detailed walk through. It was very helpful this evening. Much appreciated.

One thing I noticed... Specific to functionality related to Cablecards... Is the the "CAM enabled" flags and "simultaneous streams" values were not backed up in the TV server settings export. As it's newer functionality, I can understand why this would be the case. Anyone using Cablecards following this upgrade process will need to re-enable those settings or they'll get an "all cards busy" error message when they test channels after upgrading.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

OP Similar threads Forum Replies Date
A [solved] DiseqC problems after upgrade to 1.25 General Support 1
DHosein 1.25 Upgrade and movie covers/backdrops General Support 9
cerberus Erfahrungsbericht Upgrade Win 10.1909 MP 1.24 Installationsprobleme? 2
G [solved] Black Screen on all videos after upgrading to either 1.23 or 1.24 from 1.22 General Support 4
404 [solved] EPG problem after Win10 'upgrade' General Support 1
F [solved] Could not find the MediaPortal.Common.Logging.ILogger service after upgrading from 2.2.2 to 2.2.3 General 2
G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
T Upgrading HTPC for 4K General 5
joecrow Online Videos fails after MP 1.23 upgrade. 1.23 Pre Release 37
johns11 Multiple programs responding to IR commands since upgrade from 1.12 Remotes 3
D PC rebuild & MP2 upgrade - how to preserve database and settings? General 1
W Playback stuttering after upgrade from MP1 on Windows 7 to MP2 on Windows 10 General 2
R [solved] TV Server after upgrading from MP 1.18 to MP 2.2 General 14
caveman Upgrade from Mediaportal 1.X to 2.2 General 6
B Is it Feasible to upgrade a working Mediaportal 1.20.100.0 to V2? Newcomers Forum 1
T [further infos missing] MP2.2 client crashes on open (after upgrade) 2.2 Archive 34
J Things I noticed with MP2.2 almost within minutes after upgrading it over the 2.13 version General 6
D Upgrade to MP2.2 pre release fails with failure to start service 2.2 Archive 32
C Upgrade from ancient MP Installation, configuration support 12
Steve.Rayner61 TV "Unable to play" on Client - Working until Win 10 Server upgraded to Version 1803 Television (MyTV frontend and TV-Server) 5
J upgraded to mp2 but have a few queries! General 17
Undel MediaPortal 1.1 upgrade Installation, configuration support 3
M WTV Files does not play on client, MPEG files works well General 0
D Does Schedules Direct work with mp 1.24? General Support 3
J [solved] Blu-ray disc playback does not work. Bugreports 13
Similar threads

























Top Bottom