Game Server New Error

[drakoo]

Greetings friends MXC

I come to you to bring a new problem.

My server made automatic restart, but after the restart it does not get online.

I get the following error in Game Server.

 

BitSet ID Factory could not be initialized correctly

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu

mn 'object_id' at row 85099

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3489)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)

       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)

       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)

       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)

       at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)

       at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)

       at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStat

ement.java:64)

       at net.sf.l2j.gameserver.idfactory.IdFactory.extractUsedObjectIDTable(Id

Factory.java:198)

       at net.sf.l2j.gameserver.idfactory.BitSetIDFactory.initialize(BitSetIDFa

ctory.java:76)

       at net.sf.l2j.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactor

y.java:65)

       at net.sf.l2j.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:68)

 

       at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:180)

       at net.sf.l2j.gameserver.GameServer.main(GameServer.java:563)

IDFactory: 102912 id's available.

=====================================================================-[ World ]

L2World: Setting up World Regions

L2World: (87 by 128) World Region Grid set up.

Initializing Script Engine Manager

Script Engine: jython 2.2.1 - Language: python - Language Version: 2.2.1

Script Engine: Mozilla Rhino 1.6 release 2 - Language: ECMAScript - Language Ver

sion: 1.6

Script Engine: java 1.6 - Language: java - Language Version: 1.6

Script Engine: BeanShell Engine 1.1 - Language: BeanShell - Language Version: 2.

0b5

================================================================-[ ID Factory ]

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 net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:195)

       at net.sf.l2j.gameserver.GameServer.main(GameServer.java:563)

 

[CriticalError]

check this man, you have something wrong in this row.

 

column 'object_id' at row 85099

[Matim]

Out of range value for colu

 

It should be self explanatory.

[drakoo]

85099 already deleted the line ...

After he asks for 85098 ... 85097 ... 85096 ... until arriving at line 1

And the error continues.

 

[Tryskell]

Your SQLs are corrupted/focked up.

 

There is no table name cited, so I can't really be usefull.

 

Try to search tables "with object_id" column.

 

Basically, "items" table can be the problem (well I won't be surprised it comes from it).

 

 

Design your table and post a screen, or correct if you know what to correct.

 

----

 

As the error is too much generic, and doesn't come on the sql load but before, it can comes from IDFactory itself.

[drakoo]

Print desig table items.

http://img571.imageshack.us/img571/6471/errornl.jpg

 

 

[Tryskell]

This is the only table using this column name ?

 

Search for others, it seems it's not related to items.

 

And as I said your problem is perhaps more boring. It can comes from IdFactory or even BitSet.

 

-----

 

Btw row 85099... What is it supposed to be ? What table did you tried to remove those lines ?

 

And after removing all (do a backup of it), does the error continue on another table ?

 

If yes, you're really in bad position. Consider ask help to the dev team which support your project or change of project.

[drakoo]

The error is related to Characters table .

but do not know how to solve it.

Deleted all the characters of the table "characters" and the error disappeared ..

but is not a viable solution.

anyone have any suggestions?