Help Where the Error at My Database

02/09/2012 19:35 magnon#1

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----

02/09/2012 20:16 Kiyono#2

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

02/09/2012 20:35 magnon#3

Quote:

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 ?

02/09/2012 20:36 Spirited#4

Are you disposing of connections properly?
If you are, are you killing connections properly?
(Here's what I mean by [Only registered and activated users can see links. Click Here To Register...])

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

02/09/2012 21:10 magnon#5

Quote:

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 [Only registered and activated users can see links. Click Here To Register...])

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

02/09/2012 23:54 Spirited#6

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?

02/10/2012 08:43 12k#7

Quote:

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 [Only registered and activated users can see links. Click Here To Register...])

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.

02/10/2012 08:51 Spirited#8

Quote:

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.

Code:

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.

02/10/2012 09:38 SkullTreats#9

I cannot even access your site.

#Fix please.

02/10/2012 10:23 magnon#10

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

02/10/2012 11:05 Spirited#11

Quote:

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 "[Only registered and activated users can see links. Click Here To Register...]". That's what I use to teach myself about Microsoft Framework.

02/10/2012 11:38 I don't have a username#12

Quote:

Originally Posted by Fаng

I'm going to bed now. I'm really tired. Try "[Only registered and activated users can see links. Click Here To Register...]". That's what I use to teach myself about Microsoft Framework.

RedGate's reflector sucks.

02/10/2012 11:54 Kiyono#13

Quote:

Originally Posted by I don't have a username

RedGate's reflector sucks.

Then mind suggesting a better one?

02/11/2012 00:46 magnon#14

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

02/11/2012 01:03 Spirited#15

Quote:

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...