With MYsql issue.

[naitos]

I'm kinda new on this things so can anyone help me with this problem?

 

 

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;

[Err] 1071 - Specified key was too long; max key length is 1000 bytes

 

Best regards

[SweeTs]

value` VARCHAR(4000)

 

This I guess. Change it to =< 1000 and try again.

[naitos]

Yah thanks the problem is solved.

 

Now i have other issue...

 

My client protocol version is 268 and when i select server and try to enter i get disconnected and says that says that the protocol version is wrong.

 

I allready config in server to accept that protocol but i keep having the same problem.

 

Best Regards

[Stewie]

Yah thanks the problem is solved.

 

Now i have other issue...

 

My client protocol version is 268 and when i select server and try to enter i get disconnected and says that says that the protocol version is wrong.

 

I allready config in server to accept that protocol but i keep having the same problem.

 

Best Regards

 

 

Server Version / Client Version?

[naitos]

My client is high five and my server is high five. My server protocols are 267 to 273 and my game is 268 so should work...

[Intrepid]

My client is high five and my server is high five. My server protocols are 267 to 273 and my game is 268 so should work...

 

do you have a clean system folder or its modded, do you use a precompiled l2j or trunk/unstable branch maybe?