[HELP] Can't create Character

[suffokate]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision 4957:
L2JDP Revision 8408:

Hey,

I have the following problem:
i can log in to my server, but when i try to create a character i get the following error in the gameserver console.

Code: Select all

 Error found in null's ContactsList: Table 'l2jgs.character_contacts' doesn't existcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jgs.character_contacts' doesn't exist        at sun.reflect.GeneratedConstructorAccessor88.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)        at com.mysql.jdbc.Util.getInstance(Util.java:386)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)        at com.l2jserver.gameserver.model.L2ContactList.restore(L2ContactList.java:71)        at com.l2jserver.gameserver.model.L2ContactList.<init>(L2ContactList.java:57)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.<init>(L2PcInstance.java:449)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.create(L2PcInstance.java:1053)        at com.l2jserver.gameserver.network.clientpackets.CharacterCreate.runImpl(CharacterCreate.java:184)        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1097)        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at java.lang.Thread.run(Unknown Source) Could not insert char data: Unknown column 'createDate' in 'field list'com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'createDate' in 'field list'        at sun.reflect.GeneratedConstructorAccessor88.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)        at com.mysql.jdbc.Util.getInstance(Util.java:386)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.createDb(L2PcInstance.java:7057)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.create(L2PcInstance.java:1066)        at com.l2jserver.gameserver.network.clientpackets.CharacterCreate.runImpl(CharacterCreate.java:184)        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1097)        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at java.lang.Thread.run(Unknown Source) Client: [Account: suffokateadmin - IP: 127.0.0.1] - Failed running: [C] 0C CharacterCreate - L2J Server Version: 4957 - DP Revision: 8408 ; nulljava.lang.NullPointerException        at com.l2jserver.gameserver.network.clientpackets.CharacterCreate.runImpl(CharacterCreate.java:187)        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1097)        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at java.lang.Thread.run(Unknown Source) 

hope someone can help me to solve this.

greetz.

[Aikimaniac]

What do you think means this "Table 'l2jgs.character_contacts' doesn't exi
st" ? What about to create that character_contacts table or using sql updater ? http://trac.l2jdp.com/browser/trunk/L2J ... ntacts.sql

[Randalthorpk]

Just update your Java mate, I had the same problem with my last setup geting the newest version of Java fixed it.

[suffokate]

i have try it and get the error in the navicat console:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2 charId INT UNSIGNED NOT NULL DEFAULT 0,
3 contactId INT UNSIGNED NOT NULL' at line 2

Just update your Java mate, I had the same problem with my last setup geting the newest version of Java fixed it.

i have downloaded the newest version of java yesterday.

EDIT:
table is created,
but problem is not solved.

Gameserver console:

Code: Select all

Could not insert char data: Unknown column 'createDate' in 'field list'com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'creaeDate' in 'field list'        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method         at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sorce)        at java.lang.reflect.Constructor.newInstance(Unknown Source)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)        at com.mysql.jdbc.Util.getInstance(Util.java:386)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.jva:2119)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.jav:2415)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.jav:2333)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.jav:2318)        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewroxyPreparedStatement.java:105)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.createDb(2PcInstance.java:7057)        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.create(L2cInstance.java:1066)        at com.l2jserver.gameserver.network.clientpackets.CharacterCreate.runIml(CharacterCreate.java:184)        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.ru(L2GameClientPacket.java:62)        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:097)        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at java.lang.Thread.run(Unknown Source) Client: [Account: suffokateadmin - IP: 127.0.0.1] - Failed running: [C] 0C CharcterCreate - L2J Server Version: 4957 - DP Revision: 8408 ; nulljava.lang.NullPointerException        at com.l2jserver.gameserver.network.clientpackets.CharacterCreate.runIml(CharacterCreate.java:187)        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.ru(L2GameClientPacket.java:62)        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:097)        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)        at java.lang.Thread.run(Unknown Source)

[blarke]

you are still missing some table updates. I had similar problems when I made the upgrade to the beta H5 trunk. running all the update sqls and overriding some old tables (npc, npcaidata, npcskills etc) fixed it.

[suffokate]

i have tried to update the "characters" table in the l2jgs database, but it's not working.
the field "createDate" doesn't exist, there's only a field called "createTime"

EDIT: all problems solved.