Console Error

LetMeBeTheOne · 08/30/2009, 18:13

Code:

MySql.Data.MySqlClient.MySqlException: Connection unexpectedly terminated ---> System.ArgumentOutOfRangeException: Non-negative number required.
Parameter name: count
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.PacketReader.Read(Byte[]& buffer, Int64 pos, Int64 len)
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.PacketReader.Read(Byte[]& buffer, Int64 pos, Int64 len)
   at MySql.Data.MySqlClient.PacketReader.ReadString(Int64 length)
   at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId)
   at MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst)
   at MySql.Data.MySqlClient.CommandResult..ctor(Driver d, Boolean isBinary)
   at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)
   at MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader)
   at MySql.Data.MySqlClient.MySqlCommand.Consume()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at COServer_Project.DataBase.SaveChar(Character Charr) in C:\Documents and Settings\YernaJ\Desktop\My Source\COServerProject\DataBase.cs:line 1728
System.InvalidOperationException: Connection must be valid and open
   at MySql.Data.MySqlClient.MySqlCommand.CheckState()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at COServer_Project.DataBase.SaveChar(Character Charr) in C:\Documents and Settings\YernaJ\Desktop\My Source\COServerProject\DataBase.cs:line 1728
System.InvalidOperationException: Connection must be valid and open
   at MySql.Data.MySqlClient.MySqlCommand.CheckState()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at COServer_Project.DataBase.SaveChar(Character Charr) in C:\Documents and Settings\YernaJ\Desktop\My Source\COServerProject\DataBase.cs:line 1728

what are the causes of that console error? Anyone can help? Thanks.

LetMeBeTheOne · 08/30/2009, 18:52

someone can help me with this. thanks. sorry for double post.

hunterman01 · 08/30/2009, 19:06

Well Go Look at the line its telling you which would be 1728 in database.cs

LetMeBeTheOne · 08/30/2009, 19:46

its all about save chars. its Command.ExecuteNonQuery();

Zion~ · 08/30/2009, 19:55

Upload the source and I'll help you out.

LetMeBeTheOne · 08/30/2009, 20:10

Code:

MySqlCommand Command = new MySqlCommand("UPDATE `Characters` SET `CharName` = '" + Charr.Name + "',`Spouse` = '" + Charr.Spouse + "', `Level` = " + Charr.Level + ",`Exp` = " + Charr.Exp + ",`GuildDonation` = " + Charr.GuildDonation + ",`Strength` = " + Charr.Str + ",`Agility` = " + Charr.Agi + ",`Vitality` = " + Charr.Vit + ",`Spirit` = " + Charr.Spi + ",`Job` = " + Charr.Job + ",`Model` = " + Charr.RealModel + ",`Money` = " + Charr.Silvers + ",`CPs` = " + Charr.CPs + ",`CurrentHP` = " + Charr.CurHP + ",`StatPoints` = " + Charr.StatP + ",`MyGuild` = " + Charr.GuildID + ",`GuildPos` = " + Charr.GuildPosition + ",`LocationMap` = " + Charr.LocMap + ",`LocationX` = " + Charr.LocX + ",`LocationY` = " + Charr.LocY + ",`Hair` = " + Charr.Hair + ",`Equipment` = '" + Charr.PackedEquips + "',`Inventory` = '" + Charr.PackedInventory + "',`PKPoints` = " + Charr.PKPoints + ",`PrevMap` = " + Charr.PrevMap + ", `Skills` = '" + Charr.PackedSkills + "', `Profs` = '" + Charr.PackedProfs + "',`RBCount` = " + Charr.RBCount + ",`Avatar` = " + Charr.Avatar + ",`WHMoney` = " + Charr.WHSilvers + ",`VP` = " + Charr.VP + ",`Warehouses` = '" + Charr.PackedWHs + "',`Friends` = '" + Charr.PackedFriends + "',`Enemies` = '" + Charr.PackedEnemies + "',`QuestKO` = '" + Charr.QuestKO + "',`QuestMob` = '" + Charr.QuestMob + "',`QuestFrom` = '" + Charr.QuestFrom + "',`Prize` = '" + Charr.Prize + "',`ClaimPrize` = '" + Charr.ClaimPrize + "',`LuckyTime` = '" + Charr.LuckTime + "' WHERE `Account` = '" + Charr.MyClient.Account + "'", Connection);
                Command.ExecuteNonQuery();

thats it..

hunterman01 · 08/30/2009, 20:14

If you added heavensblessing make sure you put that in there and put it in mysql tables

raidenx123 · 08/30/2009, 21:01

Connection must be valid and open

LetMeBeTheOne · 08/30/2009, 22:02

dont have heaven bless. idk what is something wrong. i think i have to put AllowQuerys and DatabaseQueue?