Help Character_Variables Mysql Problem.

[RaizelNPC]

Helllo I have problem with importing : character_variables
In MySql.
 

Here is the File.
 

CREATE TABLE IF NOT EXISTS `character_variables` (

`obj_id` INT NOT NULL DEFAULT '0',

`type` VARCHAR(86) NOT NULL DEFAULT '0',

`name` VARCHAR(86) CHARACTER SET UTF8 NOT NULL DEFAULT '0',

`value` VARCHAR(4000) CHARACTER SET UTF8 NOT NULL DEFAULT '0',

`expire_time` bigint(20) NOT NULL DEFAULT '0',

UNIQUE KEY `prim` (`obj_id`,`type`,`name`),

KEY `obj_id` (`obj_id`),

KEY `type` (`type`),

KEY `name` (`name`),

KEY `value` (`value`),

KEY `expire_time` (`expire_time`)

) ENGINE=MyISAM;

 

 

And here is the error. 

 

MySql Error

http://imgur.com/b8EGHJ3
 

Game Server Console Error.

http://imgur.com/RbKvWQz

 

 

I use l2 Rebellion source rev 608 i think.

Edited April 6, 2016 by RaizelNPC

[SweeTs]

Read the error "max key length is 1000", and your varchar is 4000... I wonder that's the point of such a huge value.. Second error "characters table is missing". I guess it's clear.

Edited April 6, 2016 by SweeTs

[RaizelNPC]

VARCHAR(4000) 

I change it to : VARCHAR(255) and working now 0_0 ... 

[RaizelNPC]

Read the error "max key length is 1000", and your varchar is 4000... I wonder that's the point of such a huge value.. Second error "characters table is missing". I guess it's clear.

Last time when i change it to 255 and worked i got some erros with offline traiders any way its ok now.

[SweeTs]

Locked.