home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
HTPC Projects
Software
Tools and other software
[How To] [User Exp] Update MySQL
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Sebastiii" data-source="post: 970619" data-attributes="member: 60104"><p>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)</p><p>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'. </p><p> </p><p>Result of the command : </p><p> </p><p>[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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>'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', ''</p><p>[/code]</p><p> </p><p>I need to look if Table 'mptvdb.tvmovieprogram'. was created on MySQL 5.1 too.</p><p> </p><p>BTW, if i execute : mysqlcheck mptvdb --auto-repair -e -u root -p, i get that :</p><p> </p><p>[code]Enter password: ***********</p><p>mptvdb.canceledschedule OK</p><p>mptvdb.card OK</p><p>mptvdb.cardgroup OK</p><p>mptvdb.cardgroupmap OK</p><p>mptvdb.channel OK</p><p>mptvdb.channelgroup OK</p><p>mptvdb.channellinkagemap OK</p><p>mptvdb.channelmap OK</p><p>mptvdb.conflict OK</p><p>mptvdb.diseqcmotor OK</p><p>mptvdb.favorite OK</p><p>mptvdb.groupmap OK</p><p>mptvdb.history OK</p><p>mptvdb.keyword OK</p><p>mptvdb.keywordmap OK</p><p>mptvdb.pendingdeletion OK</p><p>mptvdb.personaltvguidemap OK</p><p>mptvdb.program OK</p><p>mptvdb.radiochannelgroup OK</p><p>mptvdb.radiogroupmap OK</p><p>mptvdb.recording OK</p><p>mptvdb.satellite OK</p><p>mptvdb.schedule OK</p><p>mptvdb.server OK</p><p>mptvdb.setting OK</p><p>mptvdb.softwareencoder OK</p><p>mptvdb.timespan OK</p><p>mptvdb.tuningdetail OK</p><p>mptvdb.tvmoviemapping OK</p><p>mptvdb.version OK</p><p> </p><p>C:\Program Files\MySQL\MySQL Server 5.6\bin>[/code]</p><p> </p><p>TvService surely failed to start because db was not ok.</p><p> </p><p>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 <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p><p> </p><p>Thanks <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p></blockquote><p></p>
[QUOTE="Sebastiii, post: 970619, member: 60104"] 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 :) [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
HTPC Projects
Software
Tools and other software
[How To] [User Exp] Update MySQL
Contact us
RSS
Top
Bottom