Reply to thread

Message

<blockquote data-quote="FreakyJ" data-source="post: 1041185" data-attributes="member: 106003">Hey,it looks like your database is broken.You have to get mysql workbench from here:<a href="http://www.mysql.de/products/workbench/" target="_blank">http://www.mysql.de/products/workbench/</a>And than follow these steps:1. stop MP and TvService2. start Mysql Workbench3. Select your server from the list in &quot;Open Connection to start Querying&quot;3. the Password should be MediaPortal if you haven't changed it.4. double click on mptvdb (it is bold now)5. copy this sql statement in the window &quot;Query 1&quot;6. Press the fifth button from the left (it is a small lightning) and the text says if you hover it : &quot;Execute SQL Script in Connected Server&quot;7. close mysql workbench8. start the TvService again and everything should work again <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />Hope this helps <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" /></blockquote>

[QUOTE="FreakyJ, post: 1041185, member: 106003"] Hey, it looks like your database is broken. You have to get mysql workbench from here: [url]http://www.mysql.de/products/workbench/[/url] And than follow these steps: 1. stop MP and TvService 2. start Mysql Workbench 3. Select your server from the list in "Open Connection to start Querying" 3. the Password should be MediaPortal if you haven't changed it. 4. double click on mptvdb (it is bold now) 5. copy this sql statement in the window "Query 1" 6. Press the fifth button from the left (it is a small lightning) and the text says if you hover it : "Execute SQL Script in Connected Server" 7. close mysql workbench 8. start the TvService again and everything should work again :) Hope this helps ;) [/QUOTE]

Verification