[Error]Gamserver

[DareStrike]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 5177:
L2JDP Revision 8676:

Code: Select all

 >>>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an errorin your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND canUse=1 ORDER BY Buff_Class ASC, id' at line 1<<<  

[DareStrike]

new error

Code: Select all

 Client: [Character: NoNameExist[268484065] - Account: xxxx - IP: xxxxxxx] - Failed writing: [S] 32 UserInfo - L2J Server Version: 186:200 - DP Revision: 38:41 ; com.l2jserver.gameserver.model.items.L2EtcItem cannot be cast to com.l2jserver.gameserver.model.items.L2Weaponjava.lang.ClassCastException: com.l2jserver.gameserver.model.items.L2EtcItem cannot be cast to com.l2jserver.gameserver.model.items.L2Weapon    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.getActiveWeaponItem(L2PcInstance.java:5274)    at com.l2jserver.gameserver.network.serverpackets.UserInfo.writeImpl(UserInfo.java:153)    at com.l2jserver.gameserver.network.serverpackets.L2GameServerPacket.write(L2GameServerPacket.java:63)    at org.mmocore.network.SelectorThread.putPacketIntoWriteBuffer(SelectorThread.java:577)    at org.mmocore.network.SelectorThread.prepareWriteBuffer(SelectorThread.java:549)    at org.mmocore.network.SelectorThread.writePacket(SelectorThread.java:468)    at org.mmocore.network.SelectorThread.run(SelectorThread.java:180) 

2

Code: Select all

 Error could not store char skills: An SQLException was provoked by the following failure: java.lang.InterruptedExceptionjava.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)    at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:571)    at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkoutStatement(GooGooStatementCache.java:192)    at com.mchange.v2.c3p0.impl.NewPooledConnection.checkoutStatement(NewPooledConnection.java:288)    at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:199)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeSkill(L2PcInstance.java:8201)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.addSkill(L2PcInstance.java:8100)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.giveAvailableSkills(L2PcInstance.java:2923)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.rewardSkills(L2PcInstance.java:2835)    at com.l2jserver.gameserver.model.actor.stat.PcStat.addLevel(PcStat.java:237)    at com.l2jserver.gameserver.model.actor.stat.PlayableStat.addExp(PlayableStat.java:68)    at com.l2jserver.gameserver.model.actor.stat.PcStat.addExp(PcStat.java:68)    at com.l2jserver.gameserver.model.actor.stat.PlayableStat.addExpAndSp(PlayableStat.java:104)    at com.l2jserver.gameserver.model.actor.stat.PcStat.addExpAndSp(PcStat.java:150)    at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.addExpAndSp(L2PcInstance.java:11464)    at com.l2jserver.gameserver.model.L2Party.distributeXpAndSp(L2Party.java:818)    at com.l2jserver.gameserver.model.actor.L2Attackable.calculateRewards(L2Attackable.java:887)    at com.l2jserver.gameserver.model.actor.L2Character.doDie(L2Character.java:2293)    at com.l2jserver.gameserver.model.actor.L2Npc.doDie(L2Npc.java:1397)    at com.l2jserver.gameserver.model.actor.L2Attackable.doDie(L2Attackable.java:531)    at com.l2jserver.gameserver.model.actor.instance.L2MonsterInstance.doDie(L2MonsterInstance.java:162)    at com.l2jserver.gameserver.model.actor.status.CharStatus.reduceHp(CharStatus.java:178)    at com.l2jserver.gameserver.model.actor.status.NpcStatus.reduceHp(NpcStatus.java:51)    at com.l2jserver.gameserver.model.actor.status.AttackableStatus.reduceHp(AttackableStatus.java:49)    at com.l2jserver.gameserver.model.actor.L2Character.reduceCurrentHp(L2Character.java:7361)    at com.l2jserver.gameserver.model.actor.L2Attackable.reduceCurrentHp(L2Attackable.java:502)    at com.l2jserver.gameserver.model.actor.L2Attackable.reduceCurrentHp(L2Attackable.java:443)    at handlers.skillhandlers.Mdam.useSkill(Mdam.java:157)    at com.l2jserver.gameserver.model.actor.L2Character.callSkill(L2Character.java:6813)    at com.l2jserver.gameserver.model.actor.L2Character.onMagicHitTimer(L2Character.java:6510)    at com.l2jserver.gameserver.model.actor.L2Character$MagicUseTask.run(L2Character.java:2963)    at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:86)    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)    at java.util.concurrent.FutureTask.run(FutureTask.java:166)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)    at java.lang.Thread.run(Thread.java:722)Caused by: java.lang.InterruptedException    at java.lang.Object.wait(Native Method)    at java.lang.Object.wait(Object.java:503)    at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:561)    ... 38 more 

3

Code: Select all

 Client: [Character: ={ADM}=Delirium[268483524] - Account: miketyros@hotm - IP: xxxxxxxxxxx] - Failed running: [C] 0B RequestGiveNickName - L2J Server Version: 186:200 - DP Revision: 38:41 ; Illegal repetition near index 0xxxxxxxx^java.util.regex.PatternSyntaxException: Illegal repetition near index 0xxxxxxxx^    at java.util.regex.Pattern.error(Pattern.java:1924)    at java.util.regex.Pattern.closure(Pattern.java:3104)    at java.util.regex.Pattern.sequence(Pattern.java:2101)    at java.util.regex.Pattern.expr(Pattern.java:1964)    at java.util.regex.Pattern.compile(Pattern.java:1665)    at java.util.regex.Pattern.<init>(Pattern.java:1337)    at java.util.regex.Pattern.compile(Pattern.java:1022)    at java.util.regex.Pattern.matches(Pattern.java:1128)    at java.lang.String.matches(String.java:2111)    at com.l2jserver.gameserver.network.clientpackets.RequestGiveNickName.runImpl(RequestGiveNickName.java:53)    at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)    at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1104)    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)    at java.lang.Thread.run(Thread.java:722)  

[MELERIX]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 5177:
L2JDP Revision 8676:

Code: Select all

 >>>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an errorin your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND canUse=1 ORDER BY Buff_Class ASC, id' at line 1<<<  

we don't have that in L2J, are you using a custom npc buffer ?

[DareStrike]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 5177:
L2JDP Revision 8676:

Code: Select all

 >>>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an errorin your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND canUse=1 ORDER BY Buff_Class ASC, id' at line 1<<<  

we don't have that in L2J, are you using a custom npc buffer ?

yeas man

[MELERIX]

then why you ask for support here ?

this area is for support about "L2J" (using clean sources).

not for modifications...

for modifications you need to ask to the original author of that mod/npc buffer.

[Zoey76]

For the error
Failed writing: 32 UserInfo - L2J Server Version: 186:200 - DP Revision: 38:41 ; com.l2jserver.gameserver.model.items.L2EtcItem cannot be cast to com.l2jserver.gameserver.model.items.L2Weapon

[code=diff]Index: java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java===================================================================--- java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java    (revision 5176)+++ java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java    (working copy)@@ -5241,12 +5241,8 @@    @Override    public L2Weapon getActiveWeaponItem()    {-       L2ItemInstance weapon = getActiveWeaponInstance();-       -       if (weapon == null)-           return getFistsWeaponItem();-       -       return (L2Weapon) weapon.getItem();+       final L2ItemInstance weapon = getActiveWeaponInstance();+       return ((weapon == null) || !weapon.isWeapon()) ? getFistsWeaponItem() : (L2Weapon) weapon.getItem();    }        public L2ItemInstance getChestArmorInstance() [/code]

Try that, the problem comes from invalid XML data.