Ошибка в ГС-нет колонки в БД

[Stema]

l2jfree 1,2,3

Как лечить? БД переустановил, чего оно ругается?

SEVERE Could not restore active effect data:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'systime' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.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:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1888)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.l2jfree.gameserver.model.actor.instance.L2PcInstance.restoreEffects(L2PcInstance.java:7657)
at com.l2jfree.gameserver.model.actor.instance.L2PcInstance.restore(L2PcInstance.java:6848)
at com.l2jfree.gameserver.model.actor.instance.L2PcInstance.load(L2PcInstance.java:1011)
at com.l2jfree.gameserver.network.L2GameClient.loadCharFromDisk(L2GameClient.java:434)
at com.l2jfree.gameserver.network.clientpackets.CharacterSelected.runImpl(CharacterSelected.java:86)
at com.l2jfree.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:78)
at com.l2jfree.gameserver.threadmanager.ExecuteWrapper.run(ExecuteWrapper.java:40)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

[Aquanox]

наверно надо добавить колонку systime в characters_skill_save

Код:

-- ---------------------------
-- Table structure for `character_skills_save`
-- ---------------------------
CREATE TABLE IF NOT EXISTS `character_skills_save` (
  `charId` INT UNSIGNED NOT NULL DEFAULT 0,
  `skill_id` INT NOT NULL DEFAULT 0,
  `skill_level` INT(3) NOT NULL DEFAULT 1,
  `effect_count` INT NOT NULL DEFAULT 0,
  `effect_cur_time` INT NOT NULL DEFAULT 0,
  `reuse_delay` INT(8) NOT NULL DEFAULT 0,
  `systime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
  `restore_type` INT(1) NOT NULL DEFAULT 0,
  `class_index` INT(1) NOT NULL DEFAULT 0,
  `buff_index` INT(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`charId`,`skill_id`,`class_index`)
) DEFAULT CHARSET=utf8;

[Stema]

Спасибо, проверю

Добавлено через 9 часов 41 минуту
Спасибо, помогло. А это как лечить не подскажете?

WARNING AutoSpawnHandler: An error occurred while initializing spawn instance (Object ID = 268435572):
java.lang.NullPointerException
at com.l2jfree.gameserver.instancemanager.TownManager.getClosestTownName(TownManager.java:313)
at com.l2jfree.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandler.java:499)
at com.l2jfree.gameserver.threadmanager.ExecuteWrapper.run(ExecuteWrapper.java:40)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Добавлено через 10 часов 7 минут
И еще.. Сорри за оффтоп

При релогине пропадают бафы\дебафы. Как сделать, чтобы они сохранялсь. Вроди поставил все там где надо

# Store buffs/debuffs other effects on user logout?
StoreSkillCooltime = False

И всеравно исчезают..

[JoJo]

Спасибо, проверю

Добавлено через 9 часов 41 минуту
Спасибо, помогло. А это как лечить не подскажете?

WARNING AutoSpawnHandler: An error occurred while initializing spawn instance (Object ID = 268435572):
java.lang.NullPointerException
at com.l2jfree.gameserver.instancemanager.TownManager.getClosestTownName(TownManager.java:313)
at com.l2jfree.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandler.java:499)
at com.l2jfree.gameserver.threadmanager.ExecuteWrapper.run(ExecuteWrapper.java:40)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Добавлено через 10 часов 7 минут
И еще.. Сорри за оффтоп

При релогине пропадают бафы\дебафы. Как сделать, чтобы они сохранялсь. Вроди поставил все там где надо

# Store buffs/debuffs other effects on user logout?
StoreSkillCooltime = False

И всеравно исчезают..

1. - смотри зоны не поменял ли ты у какогонить замка type=Town(вроде так) на чегонить другое.

2. - надо поставить не False а True.