sql issues

Find the proper support area, Saga-Version.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
glebmanik
Posts: 1
Joined: Wed Jul 10, 2013 11:00 pm

sql issues

Post by glebmanik »

Starting L2J Game Server.

loading gameserver config
MLog clients using java 1.4+ standard logging.
Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireInc
rement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, autoCommitOnCl
ose -> true, automaticTestTable -> connection_test_table, breakAfterAcquireFailu
re -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connec
tionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSou
rceName -> 1hge0yt8v1k9g1av4ghqs9|2a80656c, debugUnreturnedConnectionStackTraces
-> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryCla
ssLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken ->
1hge0yt8v1k9g1av4ghqs9|2a80656c, idleConnectionTestPeriod -> 3600, initialPoolS
ize -> 10, jdbcUrl -> jdbc:mysql://localhost/l2jdb, maxAdministrativeTaskTime ->
0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0,
maxPoolSize -> 100, maxStatements -> 0, maxStatementsPerConnection -> 100, minPo
olSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0,
preferredTestQuery -> null, properties -> {user=******, password=******}, prope
rtyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> fal
se, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false
]
L2J Server Version: 1434
L2J Datapack Version: Unsupported Custom Version.
Updated characters online status.
BitSet ID Factory could not be initialized correctly
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'obj_id' in
'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1355)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1270)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStat
ement.java:64)
at net.sf.l2j.gameserver.idfactory.IdFactory.extractUsedObjectIDTable(Id
Factory.java:242)
at net.sf.l2j.gameserver.idfactory.BitSetIDFactory.initialize(BitSetIDFa
ctory.java:84)
at net.sf.l2j.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactor
y.java:72)
at net.sf.l2j.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:113
)
at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:297)
at net.sf.l2j.gameserver.GameServer.main(GameServer.java:688)
IDFactory: 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 net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:301)
at net.sf.l2j.gameserver.GameServer.main(GameServer.java:688)





plz help me i did all right as in tutorials, but when i start login server and then gameserver i get this in gameserver...
plz help me
User avatar
Zoey76
L2j Inner Circle
L2j Inner Circle
Posts: 7005
Joined: Tue Aug 11, 2009 3:36 am

Re: sql issues

Post by Zoey76 »

BitSet ID Factory could not be initialized correctly
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'obj_id' in
'field list'
Check the source and the database tables, one of those has something wrong.

For source start at IDFactory.

Finally you posted the exact same post in 3 different areas, that's considered flooding and it's not allowed, if you care about getting support start reading: viewtopic.php?f=1&t=2
Powered by Eclipse 4.30 ๐ŸŒŒ | Eclipse Temurin 21 โ˜• | MariaDB 11.2.2 ๐Ÿ—ƒ๏ธ | L2J Server 2.6.3.0 - High Five ๐Ÿš€

๐Ÿ”— Join our Discord! ๐ŸŽฎ๐Ÿ’ฌ
Post Reply