L2J Server

How can I fix this error? I totally have no idea how to fix it. Could anyone give me a hand? I found that id in temporaryobjecttable table, but I didn't see any duplicate entry for it. What's wrong about it? Thanks.


Starting L2J Game Server.

loading gameserver config
MLog clients using java 1.4+ standard logging.
Initializing c3p0-0.9.0 [built 08-??????-2005 15:47:30 +0400; debug? false; trac
e: 5]
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@dd87b2 [ conn
ectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@15fe
a60 [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 10
00, autoCommitOnClose -> true, automaticTestTable -> null, breakAfterAcquireFail
ure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.
c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnre
solvedTransactions -> false, identityToken -> 15fea60, idleConnectionTestPeriod
-> 0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 10, maxStatements -
> 100, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> co
m.mchange.v2.c3p0.DriverManagerDataSource@12d03f9 [ description -> null, driverC
lass -> null, factoryClassLocation -> null, identityToken -> 12d03f9, jdbcUrl ->
jdbc:mysql://localhost/l2jdb, properties -> {user=******, password=******} ], p
referredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> fals
e, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false
], factoryClassLocation -> null, identityToken -> dd87b2, numHelperThreads -> 3
]
L2J Server Version: 1960
L2J Server Build Date: 20051217_1346
Updated characters online status.
java.sql.SQLException: Duplicate entry '268479642' for key 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:929)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStat
ement.java:194)
at net.sf.l2j.gameserver.idfactory.IdFactory.extractUsedObjectIDTable(Id
Factory.java:204)
at net.sf.l2j.gameserver.idfactory.CompactionIDFactory.<init>Compaction
IDFactory.java:63)
at net.sf.l2j.gameserver.idfactory.IdFactory.<clinit>IdFactory.java:9

at net.sf.l2j.gameserver.GameServer.<init>GameServer.java:190)
at net.sf.l2j.gameserver.GameServer.main(GameServer.java:460)
ID Factory could not be initialized correctly:java.sql.SQLException: Duplicate e
ntry '268479642' for key 1
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:194)
at net.sf.l2j.gameserver.GameServer.main(GameServer.java:460)

Server terminated abnormaly


server terminated

java.sql.SQLException: Duplicate entry '268479642' for key 1

delete the entry with the id 268479642

DELETE FROM items WHERE object_id = 268479642;

Thats the mysql command I use when I have those bad ID numbers, they are usually Items id numbers.

i have the exact same problem but this the first time ive "opend" a server can you explain the fix with more detail pls

Guys try upgrading to the latest versions.

http://www.l2jdp.com/nightly/

this is the version i have
http://www.l2jdp.com/nightly/index.php? ... %2FT2.1%2F

is old

ah i got the new one now
but now i get 2 other errors
----------
1. ERROR in \FleeNpc.java (at line 25)
public class fleeNpc extends QuestJython
^^^^^^^
The public type fleeNpc must be defined in its own file
----------
1 problem (1 error)The public type fleeNpc must be defined in its own file
Failed executing script: I:\program\Server\gameserver\data\scripts\ai\individual
\FleeNpc.java. See FleeNpc.java.error.log for details.


2.
FATAL: Failed to open server socket. Reason: Cannot assign requested address: bind
SIGTERM received. Shutting down NOW!
RaidBossSpawnManager: All raidboss info saved!!
GrandBossManager: All Grand Boss info saved!!
TradeController: All count Item Saved
Olympiad System: Data saved!!
Data saved. All players disconnected, shutting down.

server terminated

anyone know what might be causing them?

VilleValo wrote:ah i got the new one now
but now i get 2 other errors
----------
1. ERROR in \FleeNpc.java (at line 25)
public class fleeNpc extends QuestJython
^^^^^^^
The public type fleeNpc must be defined in its own file
----------
1 problem (1 error)The public type fleeNpc must be defined in its own file
Failed executing script: I:\program\Server\gameserver\data\scripts\ai\individual
\FleeNpc.java. See FleeNpc.java.error.log for details.

rename that file to FleeNpc.java

VilleValo wrote: 2.
FATAL: Failed to open server socket. Reason: Cannot assign requested address: bind
SIGTERM received. Shutting down NOW!
RaidBossSpawnManager: All raidboss info saved!!
GrandBossManager: All Grand Boss info saved!!
TradeController: All count Item Saved
Olympiad System: Data saved!!
Data saved. All players disconnected, shutting down.

server terminated

anyone know what might be causing them?

incorrect data in server.properties, btw if u know english u can read it O.o