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 ...
Error with second gameserver
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
- Posts: 16
- Joined: Sun Jan 06, 2008 12:04 am
- Location: Germany
Error with second gameserver
Find out and come in ^^
- janiii
- L2j Veteran
- Posts: 4269
- Joined: Wed May 28, 2008 3:15 pm
- Location: Slovakia
Re: Error with second gameserver
your etcitem table miss the column handler.
DO NOT EVEN TRY TO MESS WITH ME!
forum flOOder dancing dEVILoper ♀
I don't give private support - PM will be ignored!
forum flOOder dancing dEVILoper ♀
I don't give private support - PM will be ignored!
-
- Posts: 16
- Joined: Sun Jan 06, 2008 12:04 am
- Location: Germany
Re: Error with second gameserver
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...
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...
Find out and come in ^^