03-25-2011, 08:09 AM
Обновился.
Поменял конфиги.
В игру пускает, но в игре нет ни 1 вообще вещи. И логи:
Мож струкутра базы поменялась в этой реве?
Подтолкните...
Поменял конфиги.
В игру пускает, но в игре нет ни 1 вообще вещи. И логи:
gameserver/log/errors.log
[WARN 2011-03-25 07:34:17] com.aionemu.commons.database.DB:189 - Error executing select query java.sql.SQLException: Column 'itemCreator' not found.
java.sql.SQLException: Column 'itemCreator' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)
at mysql5.MySQL5BrokerDAO$2.handleRead(MySQL5BrokerDAO.java from JavaSourceFromFile:105)
at com.aionemu.commons.database.DB.select(DB.java:185)
at com.aionemu.commons.database.DB.select(DB.java:163)
at mysql5.MySQL5BrokerDAO.getBrokerItems(MySQL5BrokerDAO.java from JavaSourceFromFile:89)
at mysql5.MySQL5BrokerDAO.loadBroker(MySQL5BrokerDAO.java from JavaSourceFromFile:46)
at gameserver.services.BrokerService.initBrokerService(BrokerService.java:84)
at gameserver.services.BrokerService.<init>(BrokerService.java:67)
at gameserver.services.BrokerService$SingletonHolder.<clinit>(BrokerService.java:737)
at gameserver.services.BrokerService.getInstance(BrokerService.java:63)
at gameserver.GameServer.main(GameServer.java:134)
[FATAL 2011-03-25 07:40:47] mysql5.MySQL5InventoryDAO:190 - Could not restore Equipment data for player: 79511 from DB: Unknown column 'itemCreator' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'itemCreator' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
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:3566)
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.executeQuery(PreparedStatement.java:2275)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at mysql5.MySQL5InventoryDAO.loadEquipment(MySQL5InventoryDAO.java from JavaSourceFromFile:167)
at gameserver.services.AccountService.loadAccount(AccountService.java:134)
at gameserver.services.AccountService.getAccount(AccountService.java:68)
at gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:217)
at gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:89)
at gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:46)
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(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[FATAL 2011-03-25 07:40:47] mysql5.MySQL5InventoryDAO:97 - Could not restore storage data for player: 1 from DB: Unknown column 'itemCreator' in 'field list'
java.sql.SQLException: Column 'itemCreator' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263)
at mysql5.MySQL5BrokerDAO$2.handleRead(MySQL5BrokerDAO.java from JavaSourceFromFile:105)
at com.aionemu.commons.database.DB.select(DB.java:185)
at com.aionemu.commons.database.DB.select(DB.java:163)
at mysql5.MySQL5BrokerDAO.getBrokerItems(MySQL5BrokerDAO.java from JavaSourceFromFile:89)
at mysql5.MySQL5BrokerDAO.loadBroker(MySQL5BrokerDAO.java from JavaSourceFromFile:46)
at gameserver.services.BrokerService.initBrokerService(BrokerService.java:84)
at gameserver.services.BrokerService.<init>(BrokerService.java:67)
at gameserver.services.BrokerService$SingletonHolder.<clinit>(BrokerService.java:737)
at gameserver.services.BrokerService.getInstance(BrokerService.java:63)
at gameserver.GameServer.main(GameServer.java:134)
[FATAL 2011-03-25 07:40:47] mysql5.MySQL5InventoryDAO:190 - Could not restore Equipment data for player: 79511 from DB: Unknown column 'itemCreator' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'itemCreator' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
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:3566)
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.executeQuery(PreparedStatement.java:2275)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at mysql5.MySQL5InventoryDAO.loadEquipment(MySQL5InventoryDAO.java from JavaSourceFromFile:167)
at gameserver.services.AccountService.loadAccount(AccountService.java:134)
at gameserver.services.AccountService.getAccount(AccountService.java:68)
at gameserver.network.loginserver.LoginServer.accountAuthenticationResponse(LoginServer.java:217)
at gameserver.network.loginserver.clientpackets.CM_ACOUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE.java:89)
at gameserver.network.loginserver.LsClientPacket.run(LsClientPacket.java:46)
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(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[FATAL 2011-03-25 07:40:47] mysql5.MySQL5InventoryDAO:97 - Could not restore storage data for player: 1 from DB: Unknown column 'itemCreator' in 'field list'
Подтолкните...