search

ahmedsuffian / aionxemu

Automatically exported from code.google.com/p/aionxemu
0 stars 0 forks source link

Skill Engine , Fortress , Mysql #235

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Core revision:233

Bug description:

What steps will reproduce the problem?:

What is the expected output?:

Please copy/paste errors below:
Mysql and Skill Engine
[WARN 2011-04-03 14:18:08] com.aionemu.commons.database.DB:321 - Failed to 
execute IU query com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of 
range value for column 'skill_lvl' at row 1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for 
column 'skill_lvl' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at mysql5.MySQL5PlayerEffectsDAO$2.handleInsertUpdate(MySQL5PlayerEffectsDAO.java from JavaSourceFromFile:94)
    at com.aionemu.commons.database.DB.insertUpdate(DB.java:314)
    at com.aionemu.commons.database.DB.insertUpdate(DB.java:293)
    at mysql5.MySQL5PlayerEffectsDAO.storePlayerEffects(MySQL5PlayerEffectsDAO.java from JavaSourceFromFile:82)
    at gameserver.services.PlayerService.playerLoggedOut(PlayerService.java:360)
    at gameserver.network.aion.clientpackets.CM_QUIT.runImpl(CM_QUIT.java:71)
    at gameserver.network.aion.AionClientPacket.run(AionClientPacket.java:64)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:54)
    at gameserver.taskmanager.FIFORunnableQueue.removeAndExecuteFirst(FIFORunnableQueue.java:28)
    at gameserver.taskmanager.FIFOExecutableQueue.run(FIFOExecutableQueue.java:65)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:54)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:39)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
[ERROR 2011-04-03 14:26:19] gameserver.network.aion.AionClientPacket:71 - Error 
handling client (dex1994) message :[C] 0x92 CM_ATTACK
java.lang.StackOverflowError
    at gameserver.controllers.ObserveController.notifyAttackedObservers(ObserveController.java:118)
    at gameserver.controllers.CreatureController.onAttack(CreatureController.java:141)
    at gameserver.controllers.PlayerController.onAttack(PlayerController.java:361)
    at gameserver.controllers.PlayerController.onAttack(PlayerController.java:376)
    at gameserver.controllers.CreatureController.onAttack(CreatureController.java:150)
    at gameserver.skillengine.effect.ReflectorEffect$1.attacked(ReflectorEffect.java:67)
    at gameserver.controllers.ObserveController.notifyAttackedObservers(ObserveController.java:124)
    at gameserver.controllers.CreatureController.onAttack(CreatureController.java:141)
    at gameserver.controllers.PlayerController.onAttack(PlayerController.java:361)
    at gameserver.controllers.PlayerController.onAttack(PlayerController.java:376)
    at gameserver.controllers.CreatureController.onAttack(CreatureController.java:150)
    at gameserver.skillengine.effect.ReflectorEffect$1.attacked(ReflectorEffect.java:67)
    at gameserver.controllers.ObserveController.notifyAttackedObservers(ObserveController.java:124)
    at gameserver.controllers.CreatureController.onAttack(CreatureController.java:141)
    at gameserver.controllers.PlayerController.onAttack(PlayerController.java:361)
    at gameserver.controllers.PlayerController.onAttack(PlayerController.java:376)
    at gameserver.controllers.CreatureController.onAttack(CreatureController.java:150)
    at gameserver.skillengine.effect.ReflectorEffect$1.attacked(ReflectorEffect.java:67)
    at gameserver.controllers.ObserveController.notifyAttackedObservers(ObserveController.java:124)
    at gameserver.controllers.CreatureController.onAttack(CreatureController.java:141)
    at gameserver.controllers.PlayerController.onAttack(PlayerController.java:361)
    at gameserver.controllers.PlayerController.onAttack(PlayerController.java:376)
    at gameserver.controllers.CreatureController.onAttack(CreatureController.java:150)
    at gameserver.skillengine.effect.ReflectorEffect$1.attacked(ReflectorEffect.java:67)

Fortress
[INFO] 2011-04-03 13:24:16 - gameserver.services.SiegeService:92 - Starting 
spawn of siege locations ....
[INFO] 2011-04-03 13:24:16 - gameserver.services.SiegeService:575 - Spawned 
FORTRESS/SIEGE 1221: 57
[ERROR] 2011-04-03 13:24:16 - gameserver.services.SiegeService:483 - No 
Instance portal defined for FORTRESS 1231
[INFO] 2011-04-03 13:24:16 - gameserver.services.SiegeService:575 - Spawned 
FORTRESS/SIEGE 1241: 53
[INFO] 2011-04-03 13:24:16 - gameserver.services.SiegeService:575 - Spawned 
FORTRESS/SIEGE 1132: 117
[INFO] 2011-04-03 13:24:16 - gameserver.services.SiegeService:575 - Spawned 
FORTRESS/SIEGE 1251: 48
[ERROR] 2011-04-03 13:24:16 - gameserver.services.SiegeService:483 - No 
Instance portal defined for FORTRESS 1141
[INFO] 2011-04-03 13:24:16 - gameserver.services.SiegeService:575 - Spawned 
FORTRESS/SIEGE 1011: 94
[INFO] 2011-04-03 13:24:16 - gameserver.services.SiegeService:575 - Spawned 
FORTRESS/SIEGE 3021: 76
[INFO] 2011-04-03 13:24:16 - gameserver.services.SiegeService:575 - Spawned 
FORTRESS/SIEGE 3011: 71
[ERROR] 2011-04-03 13:24:16 - gameserver.services.SiegeService:483 - No 
Instance portal defined for FORTRESS 1211

Original issue reported on code.google.com by cristia...@list.ru on 3 Apr 2011 at 2:09

GoogleCodeExporter commented 9 years ago 
Sorry ! 
Core revision: 239

Original comment by cristia...@list.ru on 3 Apr 2011 at 2:11

GoogleCodeExporter commented 9 years ago 
The Skill Level should never be such a high value. In the skill template there 
is no skill level above 6, and it definitely should not above be the DB tinyint 
max value of 127. Revert your skill_template.xml. and npc_skills.xml if it has 
been modified.

Original comment by ZeroSign...@gmail.com on 4 Apr 2011 at 1:07

GoogleCodeExporter commented 9 years ago 
Also try and increase the memory parameters in startGame.bat too:

java -Xms1024m -Xmx2048m -ea -Xbootclasspath/p:./libs/jsr166.jar -cp 
./libs/*;ax-game-1.0.1.jar gameserver.GameServer

Or something.

Original comment by ZeroSign...@gmail.com on 4 Apr 2011 at 1:09

GoogleCodeExporter commented 9 years ago 
Part of this issue is also related to Issue 186.

Original comment by ZeroSign...@gmail.com on 4 Apr 2011 at 2:16