Reply to thread

Message

<blockquote data-quote="gazzas" data-source="post: 622578" data-attributes="member: 104556">Hi,Thought I would reply to my own thread to help anyone else that has this problem.OK so if you get the &quot;Unable to preview&quot; and &quot;Unknown Error&quot; messages while previewing the tv server channels then it could be a corrupt database.I suspect that at some point (I had a few BSOD recently) my database became corrupt and still continued to work until I tried adding the new channels from the new DVB-S2 card. At which point it became completely screwed. If you look in the TV server log you should see it talking about the &quot;program&quot; table being corrupt.So to fix this you can do two things:1) If OK with SQL and MYSQL you can do what I did and run a repair on the database table. Simply log into the MySQL console with the MediaPortal password (default MediaPortal) and then connect to the media portal database. Then run a &quot;repair table program&quot; command and your table should be ok again. If this doesn't work then you may need to do no. 2.2) Unistall the TV server and the MYSQL database. Delete the database files and do a re-install of the TV server and MySQL. The database should then be auto created and your back to square one. You would then need to rescan all the channels.HTH,Gary</blockquote>

[QUOTE="gazzas, post: 622578, member: 104556"] Hi, Thought I would reply to my own thread to help anyone else that has this problem. OK so if you get the "Unable to preview" and "Unknown Error" messages while previewing the tv server channels then it could be a corrupt database. I suspect that at some point (I had a few BSOD recently) my database became corrupt and still continued to work until I tried adding the new channels from the new DVB-S2 card. At which point it became completely screwed. If you look in the TV server log you should see it talking about the "program" table being corrupt. So to fix this you can do two things: 1) If OK with SQL and MYSQL you can do what I did and run a repair on the database table. Simply log into the MySQL console with the MediaPortal password (default MediaPortal) and then connect to the media portal database. Then run a "repair table program" command and your table should be ok again. If this doesn't work then you may need to do no. 2. 2) Unistall the TV server and the MYSQL database. Delete the database files and do a re-install of the TV server and MySQL. The database should then be auto created and your back to square one. You would then need to rescan all the channels. HTH, Gary [/QUOTE]

Verification