Character_instance_time

[YukiLT]

Hi Guys,

We've updated a few days ago and we constantly have the character_instance_time error..

Example:

Code: Select all

 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'databazeris.character_instance_time' doesn't exist	at sun.reflect.GeneratedConstructorAccessor65.newInstance(Unknown Source)	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)	at com.mysql.jdbc.Util.getInstance(Util.java:381)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1365)	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)	at net.sf.l2j.gameserver.network.L2GameClient.deleteCharByObjId(L2GameClient.java:458)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.restoreChar(CharSelectionInfo.java:284)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:212)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:54)	at net.sf.l2j.gameserver.LoginServerThread.run(LoginServerThread.java:318) Error deleting character.com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'databazeris.character_instance_time' doesn't exist	at sun.reflect.GeneratedConstructorAccessor65.newInstance(Unknown Source)	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)	at com.mysql.jdbc.Util.getInstance(Util.java:381)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1365)	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)	at net.sf.l2j.gameserver.network.L2GameClient.deleteCharByObjId(L2GameClient.java:458)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.restoreChar(CharSelectionInfo.java:284)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:212)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:54)	at net.sf.l2j.gameserver.LoginServerThread.run(LoginServerThread.java:318) Error deleting character.com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'databazeris.character_instance_time' doesn't exist	at sun.reflect.GeneratedConstructorAccessor65.newInstance(Unknown Source)	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)	at com.mysql.jdbc.Util.getInstance(Util.java:381)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1365)	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)	at net.sf.l2j.gameserver.network.L2GameClient.deleteCharByObjId(L2GameClient.java:458)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.restoreChar(CharSelectionInfo.java:284)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:212)	at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:54)	at net.sf.l2j.gameserver.LoginServerThread.run(LoginServerThread.java:318) Error deleting character. 

I thought that someone mayde a bug in the character table, and checked the latest rev to see the changes if there's a new column with a " instance_time" line, but theresn't..

How can I fix this?

[janiii]

the is a new table, not a new column. you probably did not update properly!
read the error message too: Table 'databazeris.character_instance_time' doesn't exist

Code: Select all

CREATE TABLE IF NOT EXISTS `character_instance_time` (  `charId` INT UNSIGNED NOT NULL DEFAULT '0',  `instanceId` int(3) NOT NULL DEFAULT '0',  `time` decimal(20) NOT NULL DEFAULT '0',  PRIMARY KEY (`charId`,`instanceId`));

[YukiLT]

Ogh... I'm blind sometimes, sorry Thank you very much.