Reply to thread

Maybe the builded version of installer was not the latest : (i just push the change but in between start to generate installer so maybe the source was not yet updated)

On MySQLWorkbench, i execute this command : SHOW TABLE STATUS FROM `mptvdb`; and it show all db as InnoDB, i have the Table 'mptvdb.server' but not  Table 'mptvdb.tvmovieprogram'.

 

Result of the command :

 

[code]'canceledschedule', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '16384', '0', '1', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'card', 'InnoDB', '10', 'Compact', '3', '5461', '16384', '0', '16384', '0', '4', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'cardgroup', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '0', '0', '1', '2013-02-27 19:04:23', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'cardgroupmap', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '32768', '0', '1', '2013-02-27 19:04:23', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'channel', 'InnoDB', '10', 'Compact', '3338', '78', '262144', '0', '163840', '0', '3339', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'channelgroup', 'InnoDB', '10', 'Compact', '3', '5461', '16384', '0', '16384', '0', '4', '2013-02-27 19:04:23', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'channellinkagemap', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '0', '0', '1', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'channelmap', 'InnoDB', '10', 'Compact', '3338', '44', '147456', '0', '163840', '0', '3339', '2013-02-27 19:04:23', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'conflict', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '49152', '0', '1', '2013-02-27 19:04:23', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'diseqcmotor', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '32768', '0', '1', '2013-02-27 19:04:23', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'favorite', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '16384', '0', '1', '2013-02-27 19:04:23', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'groupmap', 'InnoDB', '10', 'Compact', '5628', '40', '229376', '0', '212992', '0', '5629', '2013-02-27 19:04:23', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'history', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '16384', '0', '1', '2013-02-27 19:04:23', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'keyword', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '0', '0', '1', '2013-02-27 19:04:23', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'keywordmap', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '0', '0', '1', '2013-02-27 19:04:23', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'pendingdeletion', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '0', '0', '1', '2013-02-27 19:04:27', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'personaltvguidemap', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '0', '0', '1', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'program', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '16384', '0', '1', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'radiochannelgroup', 'InnoDB', '10', 'Compact', '3', '5461', '16384', '0', '16384', '0', '4', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'radiogroupmap', 'InnoDB', '10', 'Compact', '1048', '62', '65536', '0', '49152', '0', '1049', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'recording', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '49152', '0', '1', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'satellite', 'InnoDB', '10', 'Compact', '152', '323', '49152', '0', '0', '0', '153', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'schedule', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '81920', '0', '1', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'server', 'InnoDB', '10', 'Compact', '1', '16384', '16384', '0', '0', '0', '2', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'setting', 'InnoDB', '10', 'Compact', '104', '157', '16384', '0', '16384', '0', '105', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'softwareencoder', 'InnoDB', '10', 'Compact', '2', '8192', '16384', '0', '0', '0', '24', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'timespan', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '0', '0', '1', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'tuningdetail', 'InnoDB', '10', 'Compact', '3339', '475', '1589248', '0', '245760', '4194304', '3339', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'tvmoviemapping', 'InnoDB', '10', 'Compact', '0', '0', '16384', '0', '16384', '0', '1', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

'version', 'InnoDB', '10', 'Compact', '1', '16384', '16384', '0', '0', '0', '2', '2013-02-27 19:04:24', NULL, NULL, 'utf8_general_ci', NULL, 'row_format=DYNAMIC', ''

[/code]

 

I need to look if  Table 'mptvdb.tvmovieprogram'.  was created on MySQL 5.1 too.

 

BTW, if i execute : mysqlcheck mptvdb --auto-repair -e -u root -p, i get that :

 

[code]Enter password: ***********

mptvdb.canceledschedule                            OK

mptvdb.card                                        OK

mptvdb.cardgroup                                  OK

mptvdb.cardgroupmap                                OK

mptvdb.channel                                    OK

mptvdb.channelgroup                                OK

mptvdb.channellinkagemap                          OK

mptvdb.channelmap                                  OK

mptvdb.conflict                                    OK

mptvdb.diseqcmotor                                OK

mptvdb.favorite                                    OK

mptvdb.groupmap                                    OK

mptvdb.history                                    OK

mptvdb.keyword                                    OK

mptvdb.keywordmap                                  OK

mptvdb.pendingdeletion                            OK

mptvdb.personaltvguidemap                          OK

mptvdb.program                                    OK

mptvdb.radiochannelgroup                          OK

mptvdb.radiogroupmap                              OK

mptvdb.recording                                  OK

mptvdb.satellite                                  OK

mptvdb.schedule                                    OK

mptvdb.server                                      OK

mptvdb.setting                                    OK

mptvdb.softwareencoder                            OK

mptvdb.timespan                                    OK

mptvdb.tuningdetail                                OK

mptvdb.tvmoviemapping                              OK

mptvdb.version                                    OK

 

C:\Program Files\MySQL\MySQL Server 5.6\bin>[/code]

 

TvService surely failed to start because db was not ok.

 

So I will generate a new installer and you can try full upgrade or just delete the db + execute NSIS installer from : '%temp%\MediaPortal Installation\deploy\package-tvengine.exe' after after try to start installer and quit it

 

Thanks