Server error and freeze!

[Removed20180815]

L2J Revision 3695
L2JDP Revision 6775

Well everything is fine with my server just that some times i get this error and the server freezes(i have to restart it).


Any help is rly apreciated!

[Removed20180815]

No one knows? i even searched and found some answears but ware not so claryfing. I use wamp server could this be a problem? (i use some web scripts,thats why i installed wamp).

Thank you in advance!
ps: sorry for double post.

[pokiokio]

Seems like a Database error. It says it can't connect.

[Removed20180815]

Well it happened again i read on forums and yea its a database error but how can i fix it? I really need some suggestions please...

[Lee]

Check your store() function if it matches this one from L2J..

[Removed20180815]

first i dont know where to check it and second what you mean it it matches? Ofcourse it matches cause i use pure l2j core and files! Maybe you can explain more ... ty for your help.

[Lee]

first i dont know where to check it and second what you mean it it matches? Ofcourse it matches cause i use pure l2j core and files! Maybe you can explain more ... ty for your help.

so you didnt edit java?

[Removed20180815]

nop i just have added an script of aio npc that has all gk gmshop and other things. No java editing...

[Lee]

did you touch ur database?
do you have a second gameserver at the same login?

Something is wrong while storing characters data..

[Probe]

Seen this error happen with not just char storage, on a clean core.
It's some sort of error with database storage in general, still no idea what's causing it.

[Removed20180815]

did you touch ur database?
do you have a second gameserver at the same login?

Something is wrong while storing characters data..

I dont have a second gameserver. Touch my database well i entered data ofc.. but not in a bad way...
Should i keep useing wamp or install mysql separataly?

Edit: I saw that i use 2 scripts (in custom folder) one is for stackble subclass and one is for aio npc and they both use L2DatabaseFactory to connect to mysql database. and in the error there is something about L2DatabaseFactory. So could it be because of one of those 2 scripts? And if yes, how can i fix it? Help is much apreciated, Ty guys

[JIV]

why these scripts need direct Db access? post them here.

[janiii]

check that scripts that access database also close the connection after use and that not every time a new connection is created.

[Removed20180815]

This is the first script:
http://pastebin.com/m1cd27850
And the second script:
http://pastebin.com/mc9c8849

Ty very much...

[JIV]

first doesnt close connections, second doesnt close result and statement.
Remove first(worst one) and test.