GameServer error

[Xerus]

I've just compiled and extracted l2_gameserver and datapack_development inside the gameserver, edited passwords copy servername.xml into loginserver and i get this error when i run it....

anyone can help?

[disast3r]

reinstall ur database...

[Xerus]

reinstall ur database...

i tried but it is not working

[xAddytzu]

are you lazy to read errors from console ? said clearly that table "messages" is missing

[Xerus]

are you lazy to read errors from console ? said clearly that table "messages" is missing

i am not expert at this... so what i have to do?

[xAddytzu]

Create this table

 

CREATE TABLE IF NOT EXISTS `messages` (

  `messageId` INT NOT NULL DEFAULT 0,

  `senderId` INT NOT NULL DEFAULT 0,

  `receiverId` INT NOT NULL DEFAULT 0,

  `subject` TINYTEXT,

  `content` TEXT,

  `expiration` BIGINT NOT NULL DEFAULT 0,

  `reqAdena` BIGINT NOT NULL DEFAULT 0,

  `hasAttachments` enum('true','false') DEFAULT 'false' NOT NULL,

  `isUnread` enum('true','false') DEFAULT 'true' NOT NULL,

  `isDeletedBySender` enum('true','false') DEFAULT 'false' NOT NULL,

  `isDeletedByReceiver` enum('true','false') DEFAULT 'false' NOT NULL,

  `isLocked` enum('true','false') DEFAULT 'false' NOT NULL,

  `isFourStars` enum('true','false') DEFAULT 'false' NOT NULL,

  `isNews` enum('true','false') DEFAULT 'false' NOT NULL,

  PRIMARY KEY (`messageId`)

);

 

 

[Xerus]

Create this table

 

CREATE TABLE IF NOT EXISTS `messages` (

 `messageId` INT NOT NULL DEFAULT 0,

 `senderId` INT NOT NULL DEFAULT 0,

 `receiverId` INT NOT NULL DEFAULT 0,

 `subject` TINYTEXT,

 `content` TEXT,

 `expiration` BIGINT NOT NULL DEFAULT 0,

 `reqAdena` BIGINT NOT NULL DEFAULT 0,

 `hasAttachments` enum('true','false') DEFAULT 'false' NOT NULL,

 `isUnread` enum('true','false') DEFAULT 'true' NOT NULL,

 `isDeletedBySender` enum('true','false') DEFAULT 'false' NOT NULL,

 `isDeletedByReceiver` enum('true','false') DEFAULT 'false' NOT NULL,

 `isLocked` enum('true','false') DEFAULT 'false' NOT NULL,

 `isFourStars` enum('true','false') DEFAULT 'false' NOT NULL,

 `isNews` enum('true','false') DEFAULT 'false' NOT NULL,

 PRIMARY KEY (`messageId`)

);

 

 

doesnt works :(

[rodox]

Show curren log.

[Xerus]

this is java0.log

2010.01.17 16:33:44,826	INFO	10	com.l2jserver.Config	Loading GameServer Configuration Files...
2010.01.17 16:33:44,879	INFO	10	com.l2jserver.util.L2Properties	L2Properties: Missing property for key - DatapackRoot
2010.01.17 16:33:44,921	INFO	10	com.l2jserver.Config	Loading mmo.properties
2010.01.17 16:33:44,922	INFO	10	com.l2jserver.util.L2Properties	L2Properties: Missing property for key - IOSelectorThreadCount
2010.01.17 16:33:44,954	INFO	10	com.l2jserver.Config	Loaded 6 Filter Words.
2010.01.17 16:33:44,995	INFO	10	com.mchange.v2.log.MLog	MLog clients using java 1.4+ standard logging.
2010.01.17 16:33:45,251	INFO	10	com.mchange.v2.c3p0.C3P0Registry	Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
2010.01.17 16:33:45,746	INFO	10	com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource	Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 500, autoCommitOnClose -> true, automaticTestTable -> connection_test_table, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge1ai86gucpfgr91ky3|2fdb7df8, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge1ai86gucpfgr91ky3|2fdb7df8, idleConnectionTestPeriod -> 3600, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost/l2jdb, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100, maxStatements -> 0, maxStatementsPerConnection -> 100, minPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
2010.01.17 16:33:45,813	INFO	10	com.l2jserver.gameserver.GameServer	L2J Server Version:    ${l2j.revision}
2010.01.17 16:33:45,821	INFO	10	com.l2jserver.gameserver.GameServer	L2J Datapack Version:  Unsupported Custom Version.
2010.01.17 16:33:45,837	INFO	10	com.l2jserver.gameserver.idfactory.IdFactory	Updated characters online status.
2010.01.17 16:33:45,962	INFO	10	com.l2jserver.gameserver.idfactory.IdFactory	Cleaned 0 expired timestamps from database.
2010.01.17 16:33:46,014	SEVERE	10	com.l2jserver.gameserver.idfactory.BitSetIDFactory	BitSet ID Factory could not be initialized correctly
2010.01.17 16:33:46,115	INFO	10	com.l2jserver.gameserver.idfactory.BitSetIDFactory	IDFactory: 102912 id's available.
2010.01.17 16:33:46,117	SEVERE	10	com.l2jserver.gameserver.GameServer	Could not read object IDs from DB. Please Check Your Data.

[rodox]

Maybe try to install mysql using another installer, then add all sql files again.

[Xerus]

erm the second pack here http://www.maxcheaters.com/forum/index.php?topic=98823.0 3620 revision it shows the same error at start but it skips and continues and it runs fine... what u think?

[marwan]

check ur server configs network data base and host

and delete ur data base and install agaian

[Xerus]

nvm guys i used an older compiled rev 3690 than 3820 its ok thx for trying to help me anyway i appreciate this...

lock it if u want