Ошибки GS при в ходе в игровой мир (AL rev.179)

[sotariz]

Обновил сегодня реву, в мускул ссе залил. При входе персонажем в игру вот такая бяка вылазит. До этого бяки похожие вылазили, но дисконекта не было

Код:

[INFO] 2010-10-18 07:32:42 - Connecting to LoginServer: localhost/127.0.0.1:9014
[INFO] 2010-10-18 07:32:42 - Connected to LoginServer!
[INFO] 2010-10-18 07:32:42 - sending packet: [S] 0x00 SM_GS_AUTH
[INFO] 2010-10-18 07:32:42 - recived packet: [C] 0x00 CM_GS_AUTH_RESPONSE
[INFO] 2010-10-18 07:32:42 - sending packet: [S] 0x04 SM_ACCOUNT_LIST
[INFO] 2010-10-18 07:35:01 - connection from: 127.0.0.1
[INFO] 2010-10-18 07:35:01 - sending packet: [S] 0x01 SM_ACCOUNT_AUTH
[INFO] 2010-10-18 07:35:01 - recived packet: [C] 0x01 CM_ACOUNT_AUTH_RESPONSE
[INFO] 2010-10-18 07:35:01 - Account authed: 1 = player
[ERROR] 2010-10-18 07:35:27 - Unknown column 'daily_ap' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'daily_ap' in 'field list'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
    at com.mysql.jdbc.Util.getInstance(Util.java:384)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at mysql5.MySQL5AbyssRankDAO.loadAbyssRank(MySQL5AbyssRankDAO.java from JavaSourceFromFile:59)
    at com.aionemu.gameserver.services.PlayerService.getPlayer(PlayerService.java:205)
    at com.aionemu.gameserver.network.aion.clientpackets.CM_ENTER_WORLD.enterWorld(CM_ENTER_WORLD.java:137)
    at com.aionemu.gameserver.network.aion.clientpackets.CM_ENTER_WORLD.runImpl(CM_ENTER_WORLD.java:123)
    at com.aionemu.gameserver.network.aion.AionClientPacket.run(AionClientPacket.java:74)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:61)
    at com.aionemu.gameserver.taskmanager.FIFORunnableQueue.removeAndExecuteFirst(FIFORunnableQueue.java:28)
    at com.aionemu.gameserver.taskmanager.FIFOExecutableQueue.run(FIFOExecutableQueue.java:73)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:61)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:42)
    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)
[INFO] 2010-10-18 07:35:28 - Player logged in: player Account: player
[ERROR] 2010-10-18 07:35:28 - Error handling client (admin) message :[C] 0xFB CM_ENTER_WORLD
java.lang.NullPointerException
    at com.aionemu.gameserver.network.aion.serverpackets.SM_ABYSS_RANK.<init>(SM_ABYSS_RANK.java:38)
    at com.aionemu.gameserver.network.aion.clientpackets.CM_ENTER_WORLD.enterWorld(CM_ENTER_WORLD.java:231)
    at com.aionemu.gameserver.network.aion.clientpackets.CM_ENTER_WORLD.runImpl(CM_ENTER_WORLD.java:123)
    at com.aionemu.gameserver.network.aion.AionClientPacket.run(AionClientPacket.java:74)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:61)
    at com.aionemu.gameserver.taskmanager.FIFORunnableQueue.removeAndExecuteFirst(FIFORunnableQueue.java:28)
    at com.aionemu.gameserver.taskmanager.FIFOExecutableQueue.run(FIFOExecutableQueue.java:73)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:61)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:42)
    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)
[INFO] 2010-10-18 07:35:35 - Sending current game time to all players
[ERROR] 2010-10-18 07:35:40 - Dispatcher error! java.lang.NullPointerException
java.lang.NullPointerException
    at com.aionemu.gameserver.network.aion.serverpackets.SM_PLAYER_INFO.writeImpl(SM_PLAYER_INFO.java:248)
    at com.aionemu.gameserver.network.aion.AionServerPacket.write(AionServerPacket.java:78)
    at com.aionemu.gameserver.network.aion.AionConnection.writeData(AionConnection.java:202)
    at com.aionemu.commons.network.Dispatcher.write(Dispatcher.java:320)
    at com.aionemu.commons.network.AcceptReadWriteDispatcherImpl.dispatch(AcceptReadWriteDispatcherImpl.java:85)
    at com.aionemu.commons.network.Dispatcher.run(Dispatcher.java:110)
[INFO] 2010-10-18 07:35:40 - Write 0 ip: 127.0.0.1
[INFO] 2010-10-18 07:35:41 - Sending account disconnected 1
[INFO] 2010-10-18 07:35:41 - sending packet: [S] 0x03 SM_ACCOUNT_DISCONNECTED
[INFO] 2010-10-18 07:35:56 - Player logged out: player Account: player
[WARN] 2010-10-18 07:35:56 - Exception in a Runnable execution:
java.lang.NullPointerException
    at mysql5.MySQL5AbyssRankDAO.storeAbyssRank(MySQL5AbyssRankDAO.java from JavaSourceFromFile:105)
    at com.aionemu.gameserver.services.PlayerService.storePlayer(PlayerService.java:154)
    at com.aionemu.gameserver.services.PlayerService.playerLoggedOut(PlayerService.java:446)
    at com.aionemu.gameserver.services.PlayerService$1.run(PlayerService.java:462)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:61)
    at com.aionemu.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:42)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
    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)

[TieLay]

тебе же аглицким по белому написано

[ERROR] 2010-10-18 07:35:27 - Unknown column 'daily_ap' in 'field list'

[sotariz]

видю, а что с ним сделать (что куда дописать) не знаю...

Добавлено через 24 минуты
ошибка из-за недобавления abyss_update.sql, но я влил все 0_о и база не чистая была а накопительная. Может из-за этого бяки?

Добавлено через 28 минут
перезалил этот упдейт от предудущей ревы, 60+ какой-то и все заработало 0_о

[TieLay]

sotariz, может разместишь где на файлообменнике, а то и правда на 179 ревизии глюки - да и клиент вылетает с ошибкой...

Добавлено через 5 минут
Да использовал Rev 1 - abyss_update.sql от 78 ревизии вот с таким содержимым:

ALTER TABLE `abyss_rank`
ADD COLUMN `daily_ap` int(11) NOT NULL AFTER `player_id`,
ADD COLUMN `weekly_ap` int(11) NOT NULL AFTER `daily_ap`,
ADD COLUMN `top_ranking` int(4) NOT NULL AFTER `rank`,
ADD COLUMN `daily_kill` int(5) NOT NULL AFTER `top_ranking`,
ADD COLUMN `weekly_kill` int(5) NOT NULL AFTER `daily_kill`,
ADD COLUMN `last_kill` int(5) NOT NULL AFTER `max_rank`,
ADD COLUMN `last_ap` int(11) NOT NULL AFTER `last_kill`,
ADD COLUMN `last_update` decimal(20,0) NOT NULL AFTER `last_ap`;

И всё заработало без проблем...

[Luteron]

спс помогло