Ошибка в Гс

[blackjack]

Вылезла ошибка на днях.
После которой перестал работать сервер.
а именно топ бездны,
первый удар всегда мимо.
дерик, вплод до осад.



ну и еще.
как охранить спавн поставленный мной.
если мобы не ресаются в базе..
?

[NotSpecified]

Попробуйте временно использовать значение --skip-innodb и отключить заодно проверку KEYS, что-то вроде SET FOREIGN_KEY_CHECKS=0

[blackjack]

эту проблему решил.
теперь :

ответьте еще на 1 вопрос.

всю базу перезалил а именно данные.
таблицы взял исходные.

ошибка пропала.
но так же :

что тут?

WeNd1G0, я имею ввиду моба поставил, убил его , но он не появляется..
каждый раз reload ....
нет.

[Axeffekt]

Кто подскажет в чем проблемко после ввода Логина и пароля? "связь с сервером прервана"

логи геймсерва

[FATAL 2011-09-04 10:07:35] mysql5.MySQL5PlayerDAO:306 - Could not restore PlayerCommonData data for player: 34756 from DB: Column 'advenced_stigma_slot_size' not found.
java.sql.SQLException: Column 'advenced_stigma_slot_size' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2813)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at mysql5.MySQL5PlayerDAO.loadPlayerCommonData(MySQL5PlayerDAO.java from JavaSourceFromFile:262)
at org.openaion.gameserver.services.AccountService.loadAccount(AccountService.java:141)
at org.openaion.gameserver.services.AccountService.getAccount(AccountService.java:77)
at org.openaion.gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:248)
at org.openaion.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:94)
at org.openaion.gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:53)
at org.openaion.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:45)
at org.openaion.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:26)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
[FATAL 2011-09-04 10:07:35] org.openaion.gameserver.dao.PlayerAppearanceDAO:114 - Could not restore PlayerAppearance data for player 34756 from DB: Column 'face' not found.
java.sql.SQLException: Column 'face' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2813)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at mysql5.MySQL5PlayerAppearanceDAO.load(MySQL5PlayerAppearanceDAO.java from JavaSourceFromFile:60)
at org.openaion.gameserver.services.AccountService.loadAccount(AccountService.java:142)
at org.openaion.gameserver.services.AccountService.getAccount(AccountService.java:77)
at org.openaion.gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:248)
at org.openaion.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:94)
at org.openaion.gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:53)
at org.openaion.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:45)
at org.openaion.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:26)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
[FATAL 2011-09-04 10:07:35] mysql5.MySQL5PlayerDAO:306 - Could not restore PlayerCommonData data for player: 38274 from DB: Column 'advenced_stigma_slot_size' not found.
java.sql.SQLException: Column 'advenced_stigma_slot_size' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2813)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at mysql5.MySQL5PlayerDAO.loadPlayerCommonData(MySQL5PlayerDAO.java from JavaSourceFromFile:262)
at org.openaion.gameserver.services.AccountService.loadAccount(AccountService.java:141)
at org.openaion.gameserver.services.AccountService.getAccount(AccountService.java:77)
at org.openaion.gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:248)
at org.openaion.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:94)
at org.openaion.gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:53)
at org.openaion.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:45)
at org.openaion.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:26)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
[FATAL 2011-09-04 10:07:35] org.openaion.gameserver.dao.PlayerAppearanceDAO:114 - Could not restore PlayerAppearance data for player 38274 from DB: Column 'face' not found.
java.sql.SQLException: Column 'face' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2813)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:275)
at mysql5.MySQL5PlayerAppearanceDAO.load(MySQL5PlayerAppearanceDAO.java from JavaSourceFromFile:60)
at org.openaion.gameserver.services.AccountService.loadAccount(AccountService.java:142)
at org.openaion.gameserver.services.AccountService.getAccount(AccountService.java:77)
at org.openaion.gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:248)
at org.openaion.gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:94)
at org.openaion.gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:53)
at org.openaion.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:45)
at org.openaion.commons.utils.concurrent.ExecuteWrapper.run(ExecuteWrapper.java:26)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
[ERROR 2011-09-04 10:07:35] org.openaion.commons.network.Dispatcher:102 - Dispatcher error! java.lang.NullPointerException
java.lang.NullPointerException
at org.openaion.gameserver.network.aion.PlayerInfo.writePlayerInfo(PlayerInfo.java:56)
at org.openaion.gameserver.network.aion.serverpackets.SM_CHARACTER_LIST.writeImpl(SM_CHARACTER_LIST.java:61)
at org.openaion.gameserver.network.aion.AionServerPacket.write(AionServerPacket.java:81)
at org.openaion.gameserver.network.aion.AionConnection.writeData(AionConnection.java:229)
at org.openaion.commons.network.Dispatcher.write(Dispatcher.java:304)
at org.openaion.commons.network.AcceptReadWriteDispatcherImpl.dispatch(AcceptReadWriteDispatcherImpl.java:69)
at org.openaion.commons.network.Dispatcher.run(Dispatcher.java:94)

таблички: advenced_stigma_slot_size и face в базе присутствуют.

P.S. сборка екстримов чистая р.149 клиент 2.5 рус
P.S.S. Прошу мордой в поиск не тыкать "мопед" не мой, я просто разместил объяву!
Пасибо!

[Bugsoft]

Column 'advenced_stigma_slot_size' not found.
За тебя перевести что ли ?)
Не табличка, а колонка.

[Axeffekt]

Column 'advenced_stigma_slot_size' not found.
За тебя перевести что ли ?)
Не табличка, а колонка.

Спасибо что поправил
в таблице 'player_apperance' КОЛОНКИ 'advenced_stigma_slot_size' и 'face'
присутствовали, но, кривого типа... удалил/создал (INT) - заработало!

П.С. "День нефтянника" справляли однако... :drink: