После обновления до 219 ревы получил

[ruso]

Обновился.
Поменял конфиги.
В игру пускает, но в игре нет ни 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(SQLErro r.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:984)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:929)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetI mpl.java:1144)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetIm pl.java:5616)
at org.apache.commons.dbcp.DelegatingResultSet.getStr ing(DelegatingResultSet.java:263)
at org.apache.commons.dbcp.DelegatingResultSet.getStr ing(DelegatingResultSet.java:263)
at mysql5.MySQL5BrokerDAO$2.handleRead(MySQL5BrokerDA O.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(MySQL5Broker DAO.java from JavaSourceFromFile:89)
at mysql5.MySQL5BrokerDAO.loadBroker(MySQL5BrokerDAO. java from JavaSourceFromFile:46)
at gameserver.services.BrokerService.initBrokerServic e(BrokerService.java:84)
at gameserver.services.BrokerService.<init>(BrokerSer vice.java:67)
at gameserver.services.BrokerService$SingletonHolder. <clinit>(BrokerService.java:737)
at gameserver.services.BrokerService.getInstance(Brok erService.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.MySQLSyntaxErrorEx ception: Unknown column 'itemCreator' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Construc tor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 9)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 59)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:2275)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:96 )
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:96 )
at mysql5.MySQL5InventoryDAO.loadEquipment(MySQL5Inve ntoryDAO.java from JavaSourceFromFile:167)
at gameserver.services.AccountService.loadAccount(Acc ountService.java:134)
at gameserver.services.AccountService.getAccount(Acco untService.java:68)
at gameserver.network.loginserver.LoginServer.account AuthenticationResponse(LoginServer.java:217)
at gameserver.network.loginserver.clientpackets.CM_AC OUNT_AUTH_RESPONSE.runImpl(CM_ACOUNT_AUTH_RESPONSE .java:89)
at gameserver.network.loginserver.LsClientPacket.run( LsClientPacket.java:46)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.execute(ExecuteWrapper.java:54)
at com.aionemu.commons.utils.concurrent.ExecuteWrappe r.run(ExecuteWrapper.java:39)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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'

Свернуть ↑Развернуть ↓

Мож струкутра базы поменялась в этой реве?
Подтолкните...

[TAG]

Так и есть, глянь в папку sql, там есть файлик aionx_gs_inventory_item_creator.sql , его заливаешь в базу ГС

[ruso]

То есть:
ac_server_gs < aionx_gs_inventory_item_creator.sql
там у меня еще 3 файла

server/gameserver/sql/update# ls
aionx_gs_advanced_survey.sql
aionx_gs_dropfix_mobid_216084.sql
aionx_gs_inventory_item_creator.sql
aionx_gs_mail_senderName_truncate_fix.sql

То есть для всех них пойдет команда:
ac_server_gs < *
?
----
Все работает - СПАСИБО!