Help Where the Error at My Database

[magnon]

PHP Code:

----Exception message----
Fatal error encountered during command execution.
----End of exception message----

----Stack trace----
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at Conquer_Online_Server.Database.MySqlReader.TryFill(MySqlCommand command) in C:\Users\WarCraft\Desktop\Joseph - Copy\Source (Warcraftsco)\Database\MySql\MySqlReader.cs:line 26
   at Conquer_Online_Server.Database.MySqlReader..ctor(MySqlCommand command) in C:\Users\WarCraft\Desktop\Joseph - Copy\Source (Warcraftsco)\Database\MySql\MySqlReader.cs:line 17
   at Conquer_Online_Server.Database.SkillTable.LoadSpells(GameState client, MySqlConnection conn) in C:\Users\WarCraft\Desktop\Joseph - Copy\Source (Warcraftsco)\Database\SkillTable.cs:line 112
   at Conquer_Online_Server.Network.PacketHandler.DoLogin(Object _client) in C:\Users\WarCraft\Desktop\Joseph - Copy\Source (Warcraftsco)\Network\PacketHandler.cs:line 11429
   at Conquer_Online_Server.Network.PacketHandler.AppendConnect(Connect appendConnect, GameState client) in C:\Users\WarCraft\Desktop\Joseph - Copy\Source (Warcraftsco)\Network\PacketHandler.cs:line 11401
   at Conquer_Online_Server.Network.PacketHandler.HandlePacket(Byte[] packet, GameState client) in C:\Users\WarCraft\Desktop\Joseph - Copy\Source (Warcraftsco)\Network\PacketHandler.cs:line 1035
----End of stack trace---- 


[Kiyono]

The errors mention the filename and the line where the error occurred, simply try check them all.

[magnon]

Originally Posted by Kiyono

The errors mention the filename and the line where the error occurred, simply try check them all.

thank for answer but can you explain more please and thanks and this at database or Source ?

[Spirited]

Are you disposing of connections properly?
If you are, are you killing connections properly?
(Here's what I mean by )

i'm going to class now, I'll check back on this later.

[magnon]

Originally Posted by Fаng

Are you disposing of connections properly?
If you are, are you killing connections properly?
(Here's what I mean by )

i'm going to class now, I'll check back on this later.

thanks for help but it's just happend from yasterday i was run my game for about 2 month and this first time to happened to me

[Spirited]

Well... unfortunately, conquer online private server projects are big. There could be a lot of causes to this problem. Let's first cover whether or not that you're disposing of things properly. (1) Are you using a thread that loops every 20000 milliseconds or so to kill sleeping connections (like the void seen in the link I posted)? (2) Are you disposing of your connections? If you don't, the pool can get blocked up and start spamming error messages (similar to that). It also seems like you have truncated your error message. (3) Was there an error code (specifically a number) that went along with it?

[12k]

Originally Posted by Fаng

Are you disposing of connections properly?
If you are, are you killing connections properly?
(Here's what I mean by )

i'm going to class now, I'll check back on this later.

select concat('KILL ',id,';') from information_schema.processlist where user='root'

Just execute that query and it should be a little less work then ur solution, and a little more efficient.

[Spirited]

Originally Posted by 12k

select concat('KILL ',id,';') from information_schema.processlist where user='root'

Just execute that query and it should be a little less work then ur solution, and a little more efficient.

public static string Concat(object arg0, object arg1)
{
    if (arg0 == null)
    {
        arg0 = Empty;
    }
    if (arg1 == null)
    {
        arg1 = Empty;
    }
    return (arg0.ToString() + arg1.ToString());
}

That's the method from Framework.
It's basically the same thing.

[SkullTreats]

I cannot even access your site.

#Fix please.

[magnon]

i dont have Full Source Just Debug so i can't Resolve it ?

[Spirited]

Originally Posted by magnon

i dont have Full Source Just Debug so i can't Resolve it ?

I'm going to bed now. I'm really tired. Try "". That's what I use to teach myself about Microsoft Framework.

[I don't have a username]

Originally Posted by Fаng

I'm going to bed now. I'm really tired. Try "". That's what I use to teach myself about Microsoft Framework.

RedGate's reflector sucks.

[Kiyono]

Originally Posted by I don't have a username

RedGate's reflector sucks.

Then mind suggesting a better one?

[magnon]

yes reflector not good not out full source and have alot of errror

[Spirited]

Originally Posted by magnon

yes reflector not good not out full source and have alot of errror

Try downloading a full source or talking with the coder of the bin that you downloaded then. There's not much you can do unless you get the source (unless you want to make a hook which is much to advanced for this situation). You could just put it into a different program and run that along side it...