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 »

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: 634
Joined: Wed Jan 19, 2011 6:25 pm
Location: Czech Republic

Re: Server Creating Problem

Post 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.
ImageImage
L2J retired
Sharpvoice
Posts: 5
Joined: Fri Jan 06, 2012 8:07 pm

Re: Server Creating Problem

Post by Sharpvoice »

I dont understand what you mean in which folder should I put in the hexid?
User avatar
Asmodaius
Posts: 170
Joined: Sun Jul 16, 2006 9:43 am

Re: Server Creating Problem

Post by Asmodaius »

\L2J_Server_BETA\game\config
Sharpvoice
Posts: 5
Joined: Fri Jan 06, 2012 8:07 pm

Re: Server Creating Problem

Post by Sharpvoice »

I did it in game/config and nothing happens
User avatar
Asmodaius
Posts: 170
Joined: Sun Jul 16, 2006 9:43 am

Re: Server Creating Problem

Post by Asmodaius »

Did you import the table that your db is missing?
Post Reply