L2J Server

L2J Server Discussion Board
https://l2jserver.com/forum/

Lastest Revision Error

https://l2jserver.com/forum/viewtopic.php?t=18585

Page 1 of 1

Lastest Revision Error

Posted: Tue Aug 31, 2010 2:22 pm
by Scepter
If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number: 4410
L2JDP Revision Number: 7664

Hi Guys wounder if you can help me, i was using nightlys before and i decided to update to latest revisions using svn, on the nightlys i had no errors on gamserver.bat console but when i use the svn source codes i get this:

Code: Select all

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)        at com.l2jserver.gameserver.model.entity.Fort.loadDoor(Fort.java:733)        at com.l2jserver.gameserver.model.entity.Fort.<init>(Fort.java:249)        at com.l2jserver.gameserver.instancemanager.FortManager.loadInstances(FortManager.java:177)        at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:260)        at com.l2jserver.gameserver.GameServer.main(GameServer.java:490) Exception: loadFlagPoles(): Table 'l2jdb.fort_staticobjects' doesn't existcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.fort_staticobjects' doesn't exist        at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        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:3562)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)        at com.l2jserver.gameserver.model.entity.Fort.loadFlagPoles(Fort.java:771)        at com.l2jserver.gameserver.model.entity.Fort.<init>(Fort.java:250)        at com.l2jserver.gameserver.instancemanager.FortManager.loadInstances(FortManager.java:177)        at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:260)        at com.l2jserver.gameserver.GameServer.main(GameServer.java:490) Exception: loadFortDoor(): Table 'l2jdb.fort_staticobjects' doesn't existcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.fort_staticobjects' doesn't exist        at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        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:3562)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)        at com.l2jserver.gameserver.model.entity.Fort.loadDoor(Fort.java:733)        at com.l2jserver.gameserver.model.entity.Fort.<init>(Fort.java:249)        at com.l2jserver.gameserver.instancemanager.FortManager.loadInstances(FortManager.java:177)        at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:260)        at com.l2jserver.gameserver.GameServer.main(GameServer.java:490) Exception: loadFlagPoles(): Table 'l2jdb.fort_staticobjects' doesn't existcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.fort_staticobjects' doesn't exist        at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        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:3562)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)        at com.l2jserver.gameserver.model.entity.Fort.loadFlagPoles(Fort.java:771)        at com.l2jserver.gameserver.model.entity.Fort.<init>(Fort.java:250)        at com.l2jserver.gameserver.instancemanager.FortManager.loadInstances(FortManager.java:177)        at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:260)        at com.l2jserver.gameserver.GameServer.main(GameServer.java:490) Exception: loadFortDoor(): Table 'l2jdb.fort_staticobjects' doesn't existcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.fort_staticobjects' doesn't exist        at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        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:3562)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)        at com.l2jserver.gameserver.model.entity.Fort.loadDoor(Fort.java:733)        at com.l2jserver.gameserver.model.entity.Fort.<init>(Fort.java:249)        at com.l2jserver.gameserver.instancemanager.FortManager.loadInstances(FortManager.java:177)        at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:260)        at com.l2jserver.gameserver.GameServer.main(GameServer.java:490) Exception: loadFlagPoles(): Table 'l2jdb.fort_staticobjects' doesn't existcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.fort_staticobjects' doesn't exist        at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        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:3562)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)        at com.l2jserver.gameserver.model.entity.Fort.loadFlagPoles(Fort.java:771)        at com.l2jserver.gameserver.model.entity.Fort.<init>(Fort.java:250)        at com.l2jserver.gameserver.instancemanager.FortManager.loadInstances(FortManager.java:177)        at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:260)        at com.l2jserver.gameserver.GameServer.main(GameServer.java:490) 
and this is causing a bit of lag on my server any help, thanks.

Re: Lastest Revision Error

Posted: Tue Aug 31, 2010 2:30 pm
by Gnacik
Table 'l2jdb.fort_staticobjects' doesn't exist
Update your datapack corectly.

Re: Lastest Revision Error

Posted: Tue Aug 31, 2010 2:33 pm
by Scepter
How exactly, i used the latest revisions from scratch, didn't update for a previous revision so how could i have "updated" wrong? (sorry to sound like a noob, well i am, but i just dont understand how) :s

Re: Lastest Revision Error

Posted: Tue Aug 31, 2010 2:37 pm
by Zoey76
You have an exception because Table 'l2jdb.fort_staticobjects' doesn't exist.
Then FortManager.java at line 177 try to create a Fort based on a null Id:

Code: Select all

getForts().add(new Fort(rs.getInt("id")));
You need to properly update SQL or simply dump and restore fort_staticobjects table and maybe fort table too.

Re: Lastest Revision Error

Posted: Tue Aug 31, 2010 2:41 pm
by Scepter
Thanks very much, sorted now, i just dumped the sql then re excecuted it and it worked, must have been corupt or something.

Thanks alot.

Re: Lastest Revision Error

Posted: Tue Aug 31, 2010 2:46 pm
by Zoey76
Scepter wrote:Thanks very much, sorted now, i just dumped the sql then re excecuted it and it worked, must have been corupt or something.

Thanks alot.
No problem, glad it works.

//offtopic
Sorry Gnacik my previous post may look like copycatting yours, I was already writing it and I sent it because I though I was in "Preview", not that there we already answers. :oops:
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited