Page 1 of 4
Server error and freeze!
Posted: Fri Dec 04, 2009 2:03 pm
by 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!
Re: Server error and freez!
Posted: Fri Dec 04, 2009 7:19 pm
by 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.
Re: Server error and freez!
Posted: Fri Dec 04, 2009 8:27 pm
by pokiokio
Seems like a Database error. It says it can't connect.
Re: Server error and freez!
Posted: Sat Dec 05, 2009 8:04 pm
by 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...
Re: Server error and freez!
Posted: Sat Dec 05, 2009 9:50 pm
by Lee
Check your store() function if it matches this one from L2J..
Re: Server error and freez!
Posted: Sat Dec 05, 2009 10:06 pm
by 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.
Re: Server error and freez!
Posted: Sat Dec 05, 2009 10:48 pm
by Lee
EboLLa wrote: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?
Re: Server error and freez!
Posted: Sat Dec 05, 2009 10:56 pm
by Removed20180815
nop i just have added an script of aio npc that has all gk gmshop and other things. No java editing...
Re: Server error and freez!
Posted: Sat Dec 05, 2009 11:12 pm
by Lee
did you touch ur database?
do you have a second gameserver at the same login?
Something is wrong while storing characters data..
Re: Server error and freez!
Posted: Sat Dec 05, 2009 11:24 pm
by 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.
Re: Server error and freez!
Posted: Sat Dec 05, 2009 11:40 pm
by Removed20180815
Lee wrote: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
Re: Server error and freez!
Posted: Sun Dec 06, 2009 11:00 am
by JIV
why these scripts need direct Db access? post them here.
Re: Server error and freez!
Posted: Sun Dec 06, 2009 11:03 am
by janiii
check that scripts that access database also close the connection after use and that not every time a new connection is created.
Re: Server error and freez!
Posted: Sun Dec 06, 2009 11:22 am
by Removed20180815
This is the first script:
http://pastebin.com/m1cd27850
And the second script:
http://pastebin.com/mc9c8849
Ty very much...
Re: Server error and freez!
Posted: Sun Dec 06, 2009 11:34 am
by JIV
first doesnt close connections, second doesnt close result and statement.
Remove first(worst one) and test.