We moved our repositories to BitBucket!

If you can't login or you can't register to the forums do not rise an issue, instead please write to support (at) l2jserver.com

Check our wiki!

Report server issues here

Forum has been updated to phpBB 3.2, let's see if this fixes some minor bugs we had.

Thank you for visiting http://www.l2jserver.com/

Server Creating Problem

Find the proper support area, Saga-Version.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Sharpvoice
Posts: 5
Joined: Fri Jan 06, 2012 8:07 pm

Server Creating Problem

Post by Sharpvoice » Thu Dec 20, 2012 6:49 am

This error is incoming
SPOILER:
Starting L2J Game Server.

Loading GameServer Configuration Files...
Could not load HexID file (./config/hexid.txt). Hopefully login will give us one
.
Loaded 6 Filter Words.
-----------------------------------------------------------------=[ Database ]
L2J Server Version: 5727
L2J Datapack Version: 9339
Could not update characters online status: Table 'l2jgs.characters' doesn't exis
t
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jgs.characte
rs' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1794)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1712)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStat
ement.java:428)
at com.l2jserver.gameserver.idfactory.IdFactory.setAllCharacterOffline(I
dFactory.java:164)
at com.l2jserver.gameserver.idfactory.IdFactory.<init>(IdFactory.java:12
4)
at com.l2jserver.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFac
tory.java:50)
at com.l2jserver.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:
145)
at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:190)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:459)

Could not clean up database: Table 'l2jgs.account_gsdata' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jgs.account_
gsdata' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1794)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1712)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStat
ement.java:428)
at com.l2jserver.gameserver.idfactory.IdFactory.cleanUpDB(IdFactory.java
:207)
at com.l2jserver.gameserver.idfactory.IdFactory.<init>(IdFactory.java:13
1)
at com.l2jserver.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFac
tory.java:50)
at com.l2jserver.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:
145)
at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:190)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:459)

BitSetIDFactory: Could not be initialized properly: Table 'l2jgs.characters' doe
sn't exist
BitSetIDFactory: 102912 id's available.
Could not read object IDs from DB. Please Check Your Data.
Exception in thread "main" java.lang.Exception: Could not initialize the ID fact
ory
at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:195)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:459)
What should I do

L2J Revision Number:version=5727
builddate=20/12/2012 05:00
L2JDP Revision Number:version=9339
builddate=20/12/2012 05:00

User avatar
Gladicek
Posts: 633
Joined: Wed Jan 19, 2011 6:25 pm
Location: Czech Republic

Re: Server Creating Problem

Post by Gladicek » Thu Dec 20, 2012 9:14 am

1) You must register your server name in login (select name like Bartz blablabla and that will create HexID which you insert in config folder.
2) Your GS canť find table characters in mysql database l2jgs.
ImageImage
L2J retired

Sharpvoice
Posts: 5
Joined: Fri Jan 06, 2012 8:07 pm

Re: Server Creating Problem

Post by Sharpvoice » Thu Dec 20, 2012 10:47 am

I dont understand what you mean in which folder should I put in the hexid?

User avatar
Asmodaius
Posts: 166
Joined: Sun Jul 16, 2006 9:43 am

Re: Server Creating Problem

Post by Asmodaius » Thu Dec 20, 2012 11:02 am

\L2J_Server_BETA\game\config

Sharpvoice
Posts: 5
Joined: Fri Jan 06, 2012 8:07 pm

Re: Server Creating Problem

Post by Sharpvoice » Thu Dec 20, 2012 11:08 am

I did it in game/config and nothing happens

User avatar
Asmodaius
Posts: 166
Joined: Sun Jul 16, 2006 9:43 am

Re: Server Creating Problem

Post by Asmodaius » Thu Dec 20, 2012 12:29 pm

Did you import the table that your db is missing?

Post Reply