[l2gold]

[20:22:34] WARN Could not execute update 'REPLACE INTO character_variables (obj_id, type, name, value, expire_time) VALUES (?,'user-var','mentorPenalty',?,?)': com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown column 'type' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown column 'type' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4098)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4030)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2677)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2134)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2434)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2352)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2337)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05)
at l2s.gameserver.database.mysql.setEx(mysql.java:47)
at l2s.gameserver.database.mysql.set(mysql.java:85)
at l2s.gameserver.utils.Mentoring.setTimePenalty(Ment oring.java:134)
at l2s.gameserver.network.l2.c2s.RequestMentorCancel. runImpl(RequestMentorCancel.java:37)
at l2s.gameserver.network.l2.c2s.L2GameClientPacket.r un(L2GameClientPacket.java:50)
at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MM OExecutableQueue.java:38)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)


Структура таблицы на сервере

CREATE TABLE IF NOT EXISTS `character_variables` (
`obj_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(86) NOT NULL DEFAULT '0',
`value` varchar(255) NOT NULL DEFAULT '0',
`expire_time` bigint(20) NOT NULL DEFAULT '0',
UNIQUE KEY `prim` (`obj_id`,`name`),
KEY `obj_id` (`obj_id`),
KEY `name` (`name`),
KEY `value` (`value`),
KEY `expire_time` (`expire_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



Структура таблицы в сборке

CREATE TABLE IF NOT EXISTS `character_variables` (
`obj_id` INT NOT NULL DEFAULT '0',
`name` VARCHAR(86) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
`value` VARCHAR(255) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
`expire_time` bigint(20) NOT NULL DEFAULT '0',
UNIQUE KEY `prim` (`obj_id`,`name`),
KEY `obj_id` (`obj_id`),
KEY `name` (`name`),
KEY `value` (`value`),
KEY `expire_time` (`expire_time`)
) ENGINE=MyISAM;

[Admin]

Может быт стоит привести таблицы в соотвествие со сборкой ?

[iqman]

Исправлено.