» Find Revision
L2J Revision Number:3159
L2JDP Revision Number:6256
hello.
i tried to create a second gameserver. i have make a copy from the database from the first gameserver for the second gameserver and run the second gameserver. The server starts, that is not the problem. the problem is, that many items are not shown at second gameserver. Following Msg are in Errorlog.
10.06.2009 02:58:29 net.sf.l2j.gameserver.datatables.ItemTable <init>
WARNUNG: data error on item:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'handler' 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:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:244)
at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:214)
at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:216)
at net.sf.l2j.gameserver.GameServer.main(GameServer.java:543)
10.06.2009 02:58:29 net.sf.l2j.gameserver.skills.DocumentBase parse
SCHWERWIEGEND: Error in file C:\Users\Administrator\Desktop\L2J_Server-unstable\gameserver\data\stats\armor\0000-0099.xml
java.lang.IllegalStateException: No SQL data for Item ID: 21 - name: Shirt
at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:124)
at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:98)
at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:156)
at net.sf.l2j.gameserver.skills.SkillsEngine.loadArmors(SkillsEngine.java:115)
at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:346)
at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:214)
at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:216)
at net.sf.l2j.gameserver.GameServer.main(GameServer.java:543)
* thats the first lines of errorlog ... the next hundrets line all like ... java.lang.IllegalStateException: No SQL data for Item
When i make a second gameserver with a copy from the first gameserver, all is fine. I don`t know, where my mistake is
