L2J Server

If you want to receive support we need this info to help you properly.
» 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 ...

your etcitem table miss the column handler.

But how can i set the column handler

or is it wrong to copy the database?


**edit

Omg ... Pls forgett all what i said after good morning

The next time i will translate correctly in my language ... i allways search for a Handler Exception xD ... not thinking, that the table could have a new column ... Who can read ... can work easier...