1265 - Data truncated for column 'equip_jobs' at row 1

[Grimmjow]

[Err] 1265 - Data truncated for column 'equip_jobs' at row 1
[Err] REPLACE INTO `item_db` VALUES ('501','Red_Potion','Red Potion','0','50','25','70','0','0','0','0','0','0xFFFFFFFFFFFFFFFF','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(45,65),0;','','');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
 
Help!

 

[RagnarokOnline2015]

Same problem) Who know how to fix? 

 

[bWolfie]

Sounds bad if it's dud on the first entry

 

[Dastgir]

Seems we forgot to update the schema when we updated the item_db to support 64 bit.

@@hemagx

 

[Grimmjow]

Seems we forgot to update the schema when we updated the item_db to support 64 bit.

@@hemagx

Can't import the item_db.sql and item_db_re.sql into the database. I use Windows 10 x32. MySQL 5.5

 

[RagnarokOnline2015]

"Can't import the item_db.sql and item_db_re.sql into the database" same Just I am use Windows 7 x32 MySQL 5.5 

I import the file using a program Navicat