[Help] Errors

nestreys · 07/21/2009, 16:34

Can someone help me fix this errors please.

System.InvalidOperationException: Connection must be valid and open
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.System.Data.ID bCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at COServer_Project.DataBase.Authenticate(String UserName, String Password) in C:\Documents and Settings\YernaJ\Desktop\RoflCOpter Source\COServerProject\DataBase.cs:line 1609

System.InvalidOperationException: Connection must be valid and open
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()
at COServer_Project.DataBase.SaveChar(Character Charr) in C:\Documents and Settings\YernaJ\Desktop\RoflCOpter Source\COServerProject\DataBase.cs:line 1454

~~f0am~~ · 07/21/2009, 17:09

Post here what is on line 1454 in Database.cs

( Ctrl + G ) to type in line

nestreys · 07/21/2009, 17:44

/* public static void SaveExpball(Character Charr)
{
try
{
MySqlCommand Command = null;
Command = new MySqlCommand("UPDATE `Characters` SET `expballend` = '" + Charr.expballend.ToString() + "',`expball` = '" + Charr.expball + "' WHERE `Account` = '" + Charr.MyClient.Account + "'", Connection);
Command.ExecuteNonQuery();

}
catch (Exception Exc) { General.WriteLine(Convert.ToString(Exc)); }
}*/

thats the whole thing in line 1454....

~~f0am~~ · 07/21/2009, 17:54

well its in /* and */ shoudn't even show up

nestreys · 07/21/2009, 18:05

ah i see. but what about the first one? Why does my heaven bless cant be save?

~~f0am~~ · 07/21/2009, 18:12

Do you have teamviewer if you pm me id and pass and turn tv on i will go on and check it out, actually PM me and ill give u my msn. i have togo now

nestreys · 07/21/2009, 19:04

Can someone help me with this problem. Thanks.