Reply to thread

Message

<blockquote data-quote="Sohvaperuna" data-source="post: 589108" data-attributes="member: 66214">My MP is totally screwed up, it says;2010-03-05 19:14:23.240234 [MPMain(1)]: BusinessLayer: GetProgramsForAllChannels caused an Exception - Table '.\mptvdb\program' is marked as crashed and should be repaired,&nbsp; &nbsp; kohteessa MySql.Data.MySqlClient.MySqlStream.OpenPacket()&nbsp;&nbsp; kohteessa MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64&amp; affectedRows, Int64&amp; lastInsertId)&nbsp;&nbsp; kohteessa MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()&nbsp;&nbsp; kohteessa MySql.Data.MySqlClient.MySqlDataReader.NextResult()&nbsp;&nbsp; kohteessa MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)&nbsp;&nbsp; kohteessa MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)&nbsp;&nbsp; kohteessa System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)&nbsp;&nbsp; kohteessa System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)&nbsp;&nbsp; kohteessa System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)&nbsp;&nbsp; kohteessa System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)&nbsp;&nbsp; kohteessa TvDatabase.TvBusinessLayer.GetProgramsForAllChannels(DateTime startTime, DateTime endTime, List`1 channelList)Where that database is, can I fix it?What happens if I delete it, what is lost?Thanks,SohvaperunaFixedmysql -u root -puse mptvdb;repair table program;</blockquote>

[QUOTE="Sohvaperuna, post: 589108, member: 66214"] My MP is totally screwed up, it says; 2010-03-05 19:14:23.240234 [MPMain(1)]: BusinessLayer: GetProgramsForAllChannels caused an Exception - Table '.\mptvdb\program' is marked as crashed and should be repaired, kohteessa MySql.Data.MySqlClient.MySqlStream.OpenPacket() kohteessa MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) kohteessa MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() kohteessa MySql.Data.MySqlClient.MySqlDataReader.NextResult() kohteessa MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) kohteessa MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) kohteessa System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) kohteessa System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) kohteessa System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) kohteessa System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) kohteessa TvDatabase.TvBusinessLayer.GetProgramsForAllChannels(DateTime startTime, DateTime endTime, List`1 channelList) Where that database is, can I fix it? What happens if I delete it, what is lost? Thanks, Sohvaperuna Fixed mysql -u root -p use mptvdb; repair table program; [/QUOTE]

Verification