Reply to thread

Message

<blockquote data-quote="HomeY" data-source="post: 893350" data-attributes="member: 68365">Een SSD word niet warm, daar zitten geen bewegende delen in.&nbsp;Heb je logs even bekeken en het ziet er naar uit dat je een SQL database probleem hebt (Table 'program' staat gemarkeerd als 'crashed')&nbsp;[code]2012-08-21 17:58:32.170726 [EPG Update thread(18)]: Exception&nbsp;&nbsp; :Error: StatementErrorUnclassifiedGentle.Common.GentleException: delete from Program where idChannel = ?idChannel and endTime &lt; '2012-08-20 17:58:32'; ---&gt; MySql.Data.MySqlClient.MySqlException: Table 'program' is marked as crashed and should be repaired[/code]&nbsp;Om je database te repareren doe je het volgende:&nbsp;1. Open a command line by clicking start, type &quot;cmd&quot;, hit return/enter.2. Type cd C:\Program Files\MySQL\MySQL Server 5.1\bin (this should be the path to the bin subdirectory within your MySQL install folder) and hit return/enter.3. Type mysqlcheck mptvdb --auto-repair -e -u root -p, and hit return/enter.4. A password prompt should appear. The default password is MediaPortal (case sensitive).</blockquote>

[QUOTE="HomeY, post: 893350, member: 68365"] Een SSD word niet warm, daar zitten geen bewegende delen in. Heb je logs even bekeken en het ziet er naar uit dat je een SQL database probleem hebt (Table 'program' staat gemarkeerd als 'crashed') [code]2012-08-21 17:58:32.170726 [EPG Update thread(18)]: Exception :Error: StatementErrorUnclassified Gentle.Common.GentleException: delete from Program where idChannel = ?idChannel and endTime < '2012-08-20 17:58:32'; ---> MySql.Data.MySqlClient.MySqlException: Table 'program' is marked as crashed and should be repaired[/code] Om je database te repareren doe je het volgende: 1. Open a command line by clicking start, type "cmd", hit return/enter. 2. Type [B]cd C:\Program Files\MySQL\MySQL Server 5.1\bin[/B] (this should be the path to the bin subdirectory within your MySQL install folder) and hit return/enter. 3. Type [B]mysqlcheck mptvdb --auto-repair -e -u root -p[/B], and hit return/enter. 4. A password prompt should appear. The default password is [B]MediaPortal[/B] (case sensitive). [/QUOTE]

Verification