Page 1 of 1

Server Creating Problem

Posted: Thu Dec 20, 2012 6:49 am
by Sharpvoice
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

Re: Server Creating Problem

Posted: Thu Dec 20, 2012 9:14 am
by Gladicek
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.

Re: Server Creating Problem

Posted: Thu Dec 20, 2012 10:47 am
by Sharpvoice
I dont understand what you mean in which folder should I put in the hexid?

Re: Server Creating Problem

Posted: Thu Dec 20, 2012 11:02 am
by Asmodaius
\L2J_Server_BETA\game\config

Re: Server Creating Problem

Posted: Thu Dec 20, 2012 11:08 am
by Sharpvoice
I did it in game/config and nothing happens

Re: Server Creating Problem

Posted: Thu Dec 20, 2012 12:29 pm
by Asmodaius
Did you import the table that your db is missing?