item_proto problem (crash)

[KoYGeR 106]

Hi community

 

after run db item_proto table is crashed like:

https://metin2.download/picture/r3F9504x09DVmF8K988YXgTtGTP6KMUj/.gif

and db error_log looks like:

http://wklej.to/YZx94

 

can anyone help me? 

Edited September 3, 2022 by Metin2 Dev
Core X - External 2 Internal

[KoYGeR 106]

up

[Syreldar 1817]

ERR: Mar 13 15:10:47 :: InitializeSkillTable: no result from skill_proto
SYSERR: Mar 13 15:10:47 :: InitializeTables: InitializeSkillTable FAILED
SYSERR: Mar 13 15:10:47 :: Initialize: Table Initialize FAILED

Where is your skillproto?

 ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Data truncated for column 'immuneflag' at row 1:

ALTER TABLE `item_proto` MODIFY COLUMN `immuneflag` set('PARA','CURSE','STUN','SLEEP','SLOW','POISON','TERROR') CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '' AFTER `wearflag`;

Length and Decimals must be set to 0.