Page 1 of 1

error Exception

Posted: Thu Feb 12, 2015 3:30 pm
by professional
plz help me for my 2 error in concole

Code: Select all

[12/02 04:29:03] Exception: loadCastleData(): Column 'side' not found.
java.sql.SQLException: Column 'side' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1064)
        at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5201)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSe
t.java:908)
        at com.l2jserver.gameserver.model.entity.Castle.load(Castle.java:650)
        at com.l2jserver.gameserver.model.entity.Castle.<init>(Castle.java:246)
        at com.l2jserver.gameserver.instancemanager.CastleManager.loadInstances(
CastleManager.java:283)
        at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:284)
        at com.l2jserver.gameserver.GameServer.main(GameServer.java:475)
and this

Code: Select all

[12/02 05:24:41] ------------------------------------------------=[ Database ]
[12/02 05:24:42] GameServer: Used memory: 56MB
[12/02 05:24:42] Updated characters online status.
[12/02 05:24:42] Could not clean up database: Unknown column 'forums.forum_paren
t' in 'where clause'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'forum
s.forum_parent' in 'where clause'
        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:377)
        at com.mysql.jdbc.Util.getInstance(Util.java:360)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1618)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1549)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStat
ement.java:436)
        at com.l2jserver.gameserver.idfactory.IdFactory.cleanUpDB(IdFactory.java
:284)
        at com.l2jserver.gameserver.idfactory.IdFactory.<init>(IdFactory.java:14
8)
        at com.l2jserver.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFac
tory.java:54)
        at com.l2jserver.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:
162)
        at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:188)
        at com.l2jserver.gameserver.GameServer.main(GameServer.java:475)

[12/02 05:24:42] Cleaned 0 expired timestamps from database.
[12/02 05:24:42] BitSetIDFactory: 102912 id's available.

Re: error Exception

Posted: Thu Feb 12, 2015 4:51 pm
by Aikimaniac
What revision you have ? Is it L2J or some custom fork? Both table miss some columns...

Re: error Exception

Posted: Thu Feb 12, 2015 5:12 pm
by professional
Aikimaniac wrote:What revision you have ? Is it L2J or some custom fork? Both table miss some columns...
i have l2jserver Ertheia new i new download is in ECLIPS this link
https://github.com/L2J/L2J_Server.git
https://github.com/L2J/L2J_DataPack.git

Re: error Exception

Posted: Thu Feb 12, 2015 7:01 pm
by professional
plz help me

Re: error Exception

Posted: Thu Feb 12, 2015 7:18 pm
by Aikimaniac

Re: error Exception

Posted: Thu Feb 12, 2015 9:49 pm
by professional
Aikimaniac wrote:Did you update your database ?

https://github.com/L2J/L2J_DataPack/blo ... update.sql
tnx brothe this problem fixet :X bot i have a new problem . .

Code: Select all

eserver.enums.CastleSide.
java.lang.IllegalArgumentException: No enum constant com.l2jserver.gameserver.en
ums.CastleSide.
        at java.lang.Enum.valueOf(Unknown Source)
        at com.l2jserver.gameserver.model.entity.Castle.load(Castle.java:650)
        at com.l2jserver.gameserver.model.entity.Castle.<init>(Castle.java:246)
        at com.l2jserver.gameserver.instancemanager.CastleManager.loadInstances(
CastleManager.java:283)
        at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:284)
        at com.l2jserver.gameserver.GameServer.main(GameServer.java:475)

[12/02 11:35:31] Exception: loadCastleData(): No enum constant com.l2jserver.gam
eserver.enums.CastleSide.


Re: error Exception

Posted: Thu Feb 12, 2015 10:01 pm
by St3eT
Maybe you have to think about new nickname. :roll:

Re: error Exception

Posted: Thu Feb 12, 2015 10:10 pm
by professional
St3eT wrote:Maybe you have to think about new nickname. :roll:
no man i just download and run build.xml and run game.server and update my database sql.. i dont change config

Re: error Exception

Posted: Fri Feb 13, 2015 12:52 am
by professional
cannot help me ? :(

Re: error Exception

Posted: Fri Feb 13, 2015 4:16 am
by Zoey76
Seems you need to update your source code, both core and datapack (make sure both are ertheia) and recompile.

Re: error Exception

Posted: Fri Feb 13, 2015 8:21 am
by professional
Zoey76 wrote:Seems you need to update your source code, both core and datapack (make sure both are ertheia) and recompile.
my core is update but have this problem . . .

Re: error Exception

Posted: Fri Feb 13, 2015 5:01 pm
by Gladicek
Show us what you use.