[HELP]L2j Freya error

[djph4ntom]

I'm using L2jserver latest Freya revision

everytime more then 15-20 players login or after 30-45 minutes i restart server i get this errors in gameserver

 

 

Multiply prepared statement! SELECT classname FROM char_templates WHERE classid=

110

Multiply prepared statement! SELECT classname FROM char_templates WHERE classid=

110

Multiply prepared statement! SELECT classname FROM char_templates WHERE classid=

128

Multiply prepared statement! SELECT classname FROM char_templates WHERE classid=

110

Multiply prepared statement! SELECT classname FROM char_templates WHERE classid=

95

Multiply prepared statement! SELECT classname FROM char_templates WHERE classid=

110

Multiply prepared statement! SELECT classname FROM char_templates WHERE classid=

95

Multiply prepared statement! SELECT classname FROM char_templates WHERE classid=

103

Multiply prepared statement! SELECT classname FROM char_templates WHERE classid=

110

Multiply prepared statement! SELECT classname FROM char_templates WHERE classid=

40

Multiply prepared statement! SELECT classname FROM char_templates WHERE classid=

 

 

after 1 hour-1hour and a half the errors start to flood the gameserver and crushes. plz i need help

[soragoi]

You use Custom Scripts??

 

Check your custom Scripts ,i think they have unclosed conection inside!!

 

Soragoi

[djph4ntom]

can you plz explain me a bit at what do you refer ""unclosed connection" ?

[djph4ntom]

i fix the first error with the unclosed connection but i still get that multiply statement error and its flooding my game server. need help plz

[soragoi]

Try to delete your custom scripts like buffer or other!!

and run the Server for test.

i think a custom script is wrong "at org.python.core.PyTableCode.call(Unknown Source)"

check all your python custom scripts.

 

hmm i dont know withthe multiply statement but you look in your mysql database in table char_templates?

[djph4ntom]

well i fixed the first error. it was because of the buffer code but finally fixed it. i still don't know what to do with second error...

[Akken]

something is wrong either on char_tampletes or on core side support for the classes

 

[djph4ntom]

i think the problem might be because of this code. its from Npc hero mod(makes normal npcs look like chars+hero aura)

if someone could check this code and tell me if this is why i get that error i would apreciate.

ty

 

link http://www.megaupload.com/?d=RAYYJEJB

[soragoi]

You use ru.l2open project?

 

sure this script is for l2jserver project: com.l2jserver.

 

delete this script and look to get the error again.

 

sorry for my english

Soragoi

[djph4ntom]

no. sry that was just a copy and paste from another user post because i couldn't get the error log from my host machine . i'm using l2jserver freya version.

[allchemia]

thx for share

[Akken]

thx for share

LOL?

 

is an error post lame farmer!!!

 

 

 

 

BTW Reinstall the db something is wrong with sql and try to recompile and put the compiled libs