Aion Unity 5.8 Land of Battle Release

[daezugun]

works perfectly, already connect the client, thank you very much. Now what I have is a doubt, as I put it so that it starts from the initial zone and without gifts because we want to play it from the beginning to see everything while we move up, if someone has a database of the server that is in that form , please tell me where you are so I would like to start from scratch. Thank you.

There are 2 steps you need to do in order to change the gameplay back from level 1 without gifts.

1st Go to AL-Game\config\main and look for newbieguide.properties then open in notepad.

#======================================================================================#
# Commons config's:
# ----------------------------
# Newbie guide enable/disable: true
# If you want to use this feature, make sure that you have setup player_initial data.
gameserver.newbie.guide.enabled = true  with gift<---- change it to false without gift

Then save it.

2nd Rename your "player_initial_data.xml" from AL-Game\data\static_data to "player_initial_data.xml.gift"
(in case you want it back the gift thingy)

3nd Download file below and Extract the player_initial_data.xml to AL-Game\data\static_data

Link for player_initial_data.xml https://mega.nz/#!vuwhzSCY!2h_ku_L5r...uRRUqhDWFi2WI4

Note: Just change the kirah amount you want.

Hope it helps.

[Chuwi]

hello again,

thanks the files work, but isnt it possible to connect server offline ? everytime should I build server ?

after reconnect same error for me ..

: 2018-07-25 20:28:04,274 Could not restore PlayerCommonData data for player: 337922 from DB: Column 'is_newbie_guide' not found.
java.sql.SQLException: Column 'is_newbie_guide' not found.

any solution please ?

[eldrey]

thanks for the help I'm going to try it in a while and I'll tell you how it was. Now I have another problem, when I connect he creates the accounts automatically, I go in and play a bit but when I give him out of the game he does not let me in again he puts me this:
You are disconected from the game server

and the server gives this error


- - - Updated - - -



- - - Updated - - -



- - - Updated - - -

error logs from server

2018-07-25 19:21:36,766 getAbyssRankingPlayers
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dreamaion.account_data' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_51]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_51]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_51]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_51]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5AbyssRankDAO.getAbyssRankingPlayers(MySQL5AbyssRankDAO.java]:354) ~[na:na]
at com.aionemu.gameserver.services.abyss.AbyssRankingCache.generatePacketsForRace(AbyssRankingCache.java:103) [AL-Game.jar:na]
at com.aionemu.gameserver.services.abyss.AbyssRankingCache.renewPlayerRanking(AbyssRankingCache.java:96) [AL-Game.jar:na]
at com.aionemu.gameserver.services.abyss.AbyssRankingCache.reloadRankings(AbyssRankingCache.java:53) [AL-Game.jar:na]
at com.aionemu.gameserver.services.abyss.AbyssRankUpdateService.performUpdate(AbyssRankUpdateService.java:134) [AL-Game.jar:na]
at com.aionemu.gameserver.services.abyss.AbyssRankUpdateService.scheduleUpdate(AbyssRankUpdateService.java:103) [AL-Game.jar:na]
at com.aionemu.gameserver.GameServer.main(GameServer.java:389) [AL-Game.jar:na]
2018-07-25 19:21:36,773 getAbyssRankingPlayers
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dreamaion.account_data' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_51]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_51]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_51]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_51]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5AbyssRankDAO.getAbyssRankingPlayers(MySQL5AbyssRankDAO.java]:354) ~[na:na]
at com.aionemu.gameserver.services.abyss.AbyssRankingCache.generatePacketsForRace(AbyssRankingCache.java:103) [AL-Game.jar:na]
at com.aionemu.gameserver.services.abyss.AbyssRankingCache.renewPlayerRanking(AbyssRankingCache.java:96) [AL-Game.jar:na]
at com.aionemu.gameserver.services.abyss.AbyssRankingCache.reloadRankings(AbyssRankingCache.java:54) [AL-Game.jar:na]
at com.aionemu.gameserver.services.abyss.AbyssRankUpdateService.performUpdate(AbyssRankUpdateService.java:134) [AL-Game.jar:na]
at com.aionemu.gameserver.services.abyss.AbyssRankUpdateService.scheduleUpdate(AbyssRankUpdateService.java:103) [AL-Game.jar:na]
at com.aionemu.gameserver.GameServer.main(GameServer.java:389) [AL-Game.jar:na]
2018-07-25 19:57:08,100 Uncaught exception in callback
java.lang.ClassCastException: com.aionemu.gameserver.model.gameobjects.Npc cannot be cast to com.aionemu.gameserver.model.gameobjects.player.Player
at com.aionemu.gameserver.services.base.BossDeathListener.onBeforeDie(BossDeathListener.java:65) ~[AL-Game.jar:na]
at com.aionemu.gameserver.ai2.eventcallback.OnDieEventCallback.onBeforeHandleGeneralEvent(OnDieEventCallback.java:32) ~[AL-Game.jar:na]
at com.aionemu.gameserver.ai2.eventcallback.OnHandleAIGeneralEvent.beforeCall(OnHandleAIGeneralEvent.java:35) ~[AL-Game.jar:na]
at com.aionemu.gameserver.ai2.eventcallback.OnHandleAIGeneralEvent.beforeCall(OnHandleAIGeneralEvent.java:29) ~[AL-Game.jar:na]
at com.aionemu.commons.callbacks.util.ObjectCallbackHelper.beforeCall(ObjectCallbackHelper.java:150) ~[al-commons.jar:na]
at com.aionemu.gameserver.ai2.AbstractAI.handleGeneralEvent(AbstractAI.java) [AL-Game.jar:na]
at com.aionemu.gameserver.ai2.AbstractAI.onGeneralEvent(AbstractAI.java:188) [AL-Game.jar:na]
at com.aionemu.gameserver.controllers.NpcController.onDie(NpcController.java:182) [AL-Game.jar:na]
at com.aionemu.gameserver.model.stats.container.CreatureLifeStats.reduceHp(CreatureLifeStats.java:131) [AL-Game.jar:na]
at com.aionemu.gameserver.controllers.CreatureController.onAttack(CreatureController.java:276) [AL-Game.jar:na]
at com.aionemu.gameserver.controllers.NpcController.onAttack(NpcController.java:390) [AL-Game.jar:na]
at com.aionemu.gameserver.controllers.CreatureController.onAttack(CreatureController.java:324) [AL-Game.jar:na]
at com.aionemu.gameserver.controllers.CreatureController.attackTarget(CreatureController.java:426) [AL-Game.jar:na]
at com.aionemu.gameserver.ai2.manager.SimpleAttackManager.attackAction(SimpleAttackManager.java:112) [AL-Game.jar:na]
at com.aionemu.gameserver.ai2.manager.SimpleAttackManager$SimpleAttackAction.run(SimpleAttackManager.java:133) [AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) [al-commons.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [na:1.7.0_51]
at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.7.0_51]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) [na:1.7.0_51]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) [na:1.7.0_51]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.7.0_51]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.7.0_51]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_51]
2018-07-25 20:00:06,939 Missing H for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:00:06,940 Missing S for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:00:06,941 Missing Q for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:02:25,956 Missing H for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:02:25,957 Missing S for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:02:25,957 Missing Q for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:04:44,984 Can't add skills for player: 337922 Execption is : Field 'skill_animation' doesn't have a default value
java.sql.BatchUpdateException: Field 'skill_animation' doesn't have a default value
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1815) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1277) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5PlayerSkillListDAO.addSkills(MySQL5PlayerSkillListDAO.java]:151) [na:na]
at mysql5.MySQL5PlayerSkillListDAO.store(MySQL5PlayerSkillListDAO.java]:119) [na:na]
at mysql5.MySQL5PlayerSkillListDAO.storeSkills(MySQL5PlayerSkillListDAO.java]:106) [na:na]
at com.aionemu.gameserver.services.player.PlayerService.storeNewPlayer(PlayerService.java:107) [AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.clientpackets.CM_CREATE_CHARACTER.runImpl(CM_CREATE_CHARACTER.java:269) [AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionClientPacket.run(AionClientPacket.java:65) [AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na]
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_51]
Caused by: java.sql.SQLException: Field 'skill_animation' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773) ~[mysql-connector-java-5.1.33.jar:5.1.33]
... 12 common frames omitted
2018-07-25 20:12:40,586 Error saving player: 337922 Sylvanas
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'service_bonus' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_51]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_51]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_51]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_51]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5PlayerDAO.storePlayer(MySQL5PlayerDAO.java]:224) ~[na:na]
at com.aionemu.gameserver.services.player.PlayerService.storePlayer(PlayerService.java:116) [AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerLeaveWorldService.startLeaveWorld(PlayerLeaveWorldService.java:221) [AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.clientpackets.CM_QUIT.runImpl(CM_QUIT.java:65) [AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionClientPacket.run(AionClientPacket.java:65) [AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na]
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_51]
2018-07-25 20:12:40,601 Can't add skills for player: 337922 Execption is : Field 'skill_animation' doesn't have a default value
java.sql.BatchUpdateException: Field 'skill_animation' doesn't have a default value
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1815) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1277) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5PlayerSkillListDAO.addSkills(MySQL5PlayerSkillListDAO.java]:151) [na:na]
at mysql5.MySQL5PlayerSkillListDAO.store(MySQL5PlayerSkillListDAO.java]:119) [na:na]
at mysql5.MySQL5PlayerSkillListDAO.storeSkills(MySQL5PlayerSkillListDAO.java]:106) [na:na]
at com.aionemu.gameserver.services.player.PlayerService.storePlayer(PlayerService.java:117) [AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerLeaveWorldService.startLeaveWorld(PlayerLeaveWorldService.java:221) [AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.clientpackets.CM_QUIT.runImpl(CM_QUIT.java:65) [AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionClientPacket.run(AionClientPacket.java:65) [AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na]
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_51]
Caused by: java.sql.SQLException: Field 'skill_animation' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773) ~[mysql-connector-java-5.1.33.jar:5.1.33]
... 13 common frames omitted
2018-07-25 20:13:20,540 Missing H for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:13:20,540 Missing S for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:13:20,540 Missing Q for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:13:20,552 Could not restore PlayerCommonData data for player: 337922 from DB: Column 'is_newbie_guide' not found.
java.sql.SQLException: Column 'is_newbie_guide' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1064) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2566) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at mysql5.MySQL5PlayerDAO.loadPlayerCommonData(MySQL5PlayerDAO.java]:368) ~[na:na]
at com.aionemu.gameserver.services.AccountService.loadAccount(AccountService.java:145) [AL-Game.jar:na]
at com.aionemu.gameserver.services.AccountService.getAccount(AccountService.java:80) [AL-Game.jar:na]
at com.aionemu.gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:227) [AL-Game.jar:na]
at com.aionemu.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:113) [AL-Game.jar:na]
at com.aionemu.gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:50) [AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) [al-commons.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.7.0_51]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.7.0_51]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_51]
2018-07-25 20:13:20,917 Dispatcher error! java.lang.NullPointerException
java.lang.NullPointerException: null
at com.aionemu.gameserver.network.aion.PlayerInfo.writePlayerInfo(PlayerInfo.java:125) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.serverpackets.SM_CHARACTER_LIST.writeImpl(SM_CHARACTER_LIST.java:82) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionServerPacket.write(AionServerPacket.java:144) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionConnection.writeData(AionConnection.java:321) ~[AL-Game.jar:na]
at com.aionemu.commons.network.Dispatcher.write(Dispatcher.java:289) ~[al-commons.jar:na]
at com.aionemu.commons.network.AcceptReadWriteDispatcherImpl.dispatch(AcceptReadWriteDispatcherImpl.java:83) ~[al-commons.jar:na]
at com.aionemu.commons.network.Dispatcher.run(Dispatcher.java:107) ~[al-commons.jar:na]
2018-07-25 20:21:27,212 Missing H for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:21:27,213 Missing S for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:21:27,216 Missing Q for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:21:27,218 Could not restore PlayerCommonData data for player: 337922 from DB: Column 'is_newbie_guide' not found.
java.sql.SQLException: Column 'is_newbie_guide' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1064) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2566) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at mysql5.MySQL5PlayerDAO.loadPlayerCommonData(MySQL5PlayerDAO.java]:368) ~[na:na]
at com.aionemu.gameserver.services.AccountService.loadAccount(AccountService.java:145) [AL-Game.jar:na]
at com.aionemu.gameserver.services.AccountService.getAccount(AccountService.java:80) [AL-Game.jar:na]
at com.aionemu.gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:227) [AL-Game.jar:na]
at com.aionemu.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:113) [AL-Game.jar:na]
at com.aionemu.gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:50) [AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) [al-commons.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.7.0_51]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.7.0_51]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_51]
2018-07-25 20:21:28,009 Dispatcher error! java.lang.NullPointerException
java.lang.NullPointerException: null
at com.aionemu.gameserver.network.aion.PlayerInfo.writePlayerInfo(PlayerInfo.java:125) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.serverpackets.SM_CHARACTER_LIST.writeImpl(SM_CHARACTER_LIST.java:82) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionServerPacket.write(AionServerPacket.java:144) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionConnection.writeData(AionConnection.java:321) ~[AL-Game.jar:na]
at com.aionemu.commons.network.Dispatcher.write(Dispatcher.java:289) ~[al-commons.jar:na]
at com.aionemu.commons.network.AcceptReadWriteDispatcherImpl.dispatch(AcceptReadWriteDispatcherImpl.java:83) ~[al-commons.jar:na]
at com.aionemu.commons.network.Dispatcher.run(Dispatcher.java:107) ~[al-commons.jar:na]
2018-07-25 20:28:04,270 Missing H for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:28:04,270 Missing S for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:28:04,271 Missing Q for: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
2018-07-25 20:28:04,274 Could not restore PlayerCommonData data for player: 337922 from DB: Column 'is_newbie_guide' not found.
java.sql.SQLException: Column 'is_newbie_guide' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1064) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2566) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at mysql5.MySQL5PlayerDAO.loadPlayerCommonData(MySQL5PlayerDAO.java]:368) ~[na:na]
at com.aionemu.gameserver.services.AccountService.loadAccount(AccountService.java:145) [AL-Game.jar:na]
at com.aionemu.gameserver.services.AccountService.getAccount(AccountService.java:80) [AL-Game.jar:na]
at com.aionemu.gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:227) [AL-Game.jar:na]
at com.aionemu.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:113) [AL-Game.jar:na]
at com.aionemu.gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:50) [AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) [al-commons.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.7.0_51]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.7.0_51]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_51]
2018-07-25 20:28:04,521 Dispatcher error! java.lang.NullPointerException
java.lang.NullPointerException: null
at com.aionemu.gameserver.network.aion.PlayerInfo.writePlayerInfo(PlayerInfo.java:125) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.serverpackets.SM_CHARACTER_LIST.writeImpl(SM_CHARACTER_LIST.java:82) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionServerPacket.write(AionServerPacket.java:144) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionConnection.writeData(AionConnection.java:321) ~[AL-Game.jar:na]
at com.aionemu.commons.network.Dispatcher.write(Dispatcher.java:289) ~[al-commons.jar:na]
at com.aionemu.commons.network.AcceptReadWriteDispatcherImpl.dispatch(AcceptReadWriteDispatcherImpl.java:83) ~[al-commons.jar:na]
at com.aionemu.commons.network.Dispatcher.run(Dispatcher.java:107) ~[al-commons.jar:na]

[daezugun]

hello again,

thanks the files work, but isnt it possible to connect server offline ? everytime should I build server ?

after reconnect same error for me ..

: 2018-07-25 20:28:04,274 Could not restore PlayerCommonData data for player: 337922 from DB: Column 'is_newbie_guide' not found.
java.sql.SQLException: Column 'is_newbie_guide' not found.

any solution please ?

Hello there,
You need to add all the column missing from the database and after Onyen542 helped me out about is_newbie_guide (thanks to him), i'll give you the other db problem that i figured it out.

Go to your database al_server_gs and run this query, use navicat or phpmyadmin.

ALTER TABLE `players` 
ADD `is_newbie_guide` TINYINT(4) NULL DEFAULT NULL,
ADD `service_bonus` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0',
ADD `service_bonus_time` TIMESTAMP NULL DEFAULT NULL;

About skill animation, you need to find the db "player_skills" then set the "skill_animation" and "skill_animation_enabled" default value to 1

Hope it helps...

[eldrey]

it works perfectly, it starts from level 1 and in the initial zone, but I still have a big problem, I create the automatic accounts when registering the users, but once they are disconnected they do not let me re-enter with those users, it tells me that have been disconnected from the server. What do I do to register users or to remove that error? please help

[Chuwi]

Hello there,
You need to add all the column missing from the database and after Onyen542 helped me out about is_newbie_guide (thanks to him), i'll give you the other db problem that i figured it out.

Go to your database al_server_gs and run this query, use navicat or phpmyadmin.

ALTER TABLE `players` 
ADD `is_newbie_guide` TINYINT(4) NULL DEFAULT NULL,
ADD `service_bonus` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0',
ADD `service_bonus_time` TIMESTAMP NULL DEFAULT NULL;

About skill animation, you need to find the db "player_skills" then set the "skill_animation" and "skill_animation_enabled" default value to 1

Hope it helps...

it this right like that ?

`skill_animation_enabled` int(1) NOT NULL DEFAULT '1',

[eldrey]

it works perfectly, it starts from level 1 and in the initial zone, but I still have a big problem, I create the automatic accounts when registering the users, but once they are disconnected they do not let me re-enter with those users, it tells me that have been disconnected from the server. What do I do to register users or to remove that error? please help

[daezugun]

it this right like that ?

`skill_animation_enabled` int(1) NOT NULL DEFAULT '1',

Thats correct, and about the accout pls show the gs logs thank you

[DamSF]

it works perfectly, it starts from level 1 and in the initial zone, but I still have a big problem, I create the automatic accounts when registering the users, but once they are disconnected they do not let me re-enter with those users, it tells me that have been disconnected from the server. What do I do to register users or to remove that error? please help

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dreamaion.account_data' doesn't exist

I've checked your Game Server logs and it seems that you're lacking a MySQL table/database.
Try restoring them again.

[eldrey]

I have already restored them on several occasions but that table does not appear, even try to: https://github.com/AionGermany/aion-germany with those databases and nothing. Can someone give me the download link where is a database with all its tables ???. On the other hand, I am creating the accounts automatically in login server because I do not have a website for this server and when I login and leave the account, it does not let me in anymore, can you help me with that to? please

[daezugun]

I have already restored them on several occasions but that table does not appear, even try to: https://github.com/AionGermany/aion-germany with those databases and nothing. Can someone give me the download link where is a database with all its tables ???. On the other hand, I am creating the accounts automatically in login server because I do not have a website for this server and when I login and leave the account, it does not let me in anymore, can you help me with that to? please

Database location with account_data is under AL-Login\sql\al_server_ls

[Chuwi]

The possible errors in this emulator:
mysql 5.7 version doesnt support NOT NULL,
gameserver works with JDK 7 , and log in server with JDK 8
is_newbie error, lack of sql file,
is_enhance error , !!
minion_function_time is missing in al_server_gs.sql ..
gm command panel ( only a few commands work )

maybe some of them is my own mistake, thank you anyway..

[eldrey]

Hi, I've done everything and it works, but I have 2 new problems when I logout and login again:
1- the character enters without clothes so I have to go back to the backpack and dress him.
2- the gathering points are set to 0 and I have to gather again from the initial zone.

How could these problems be solved? Does anyone have the solution?

[Chuwi]

hello again,

I have been still testing the classes, but for now I have seen that ranger and gunner skill ranges have errors.. for e.g, while some skills' ranges must be 25m , they are around 13-14m...

is yours working well or, is there error for you, as well ?

Thanks,

[eldrey]

I have the same problem, but I am more worried about the problem that every time I enter the game I get the player undressed and with the gathering points in 1. Does anyone have any solution for this?