Issue information

Issue ID
#6349
Status
Fixed
Severity
None
Started
Hercules Elf Bot
Jul 27, 2012 23:19
Last Post
Hercules Elf Bot
Jul 27, 2012 23:33
Confirmation
N/A

Hercules Elf Bot - Jul 27, 2012 23:19

Originally posted by [b]Cusy[/b]
On item_db_re.sql:

[CODE]0 01:03:31 REPLACE INTO `item_db_re` VALUES (1231,'Bazerald','Bazerald',4,20,NULL,500,'70:105',NULL,1,NULL,0x028F5EEE,7,2,2,4,36,1,1,'bonus bAtkEle,Ele_Fire; bonus bInt,5;',NULL,NULL) Error Code: 1265. Data truncated for column 'attack' at row 1
0 01:05:00 REPLACE INTO `item_db_re` VALUES (1433,'Imperial_Spear','Imperial Spear',4,20,NULL,1800,'180:50',NULL,3,1,0x00004082,7,2,2,3,102,1,4,'bonus2 bSkillAtk,"LG_CANNONSPEAR",20+getrefine()/2; bonus2 bSkillAtk,"LG_BANISHINGPOINT",20+getrefine()/2;',NULL,NULL) Error Code: 1265. Data truncated for column 'attack' at row 1
0 01:05:54 REPLACE INTO `item_db_re` VALUES (1472,'Staff_Of_Soul','Soul Staff',4,20,NULL,1400,'25:200',NULL,1,NULL,0x00810204,7,2,34,3,73,1,10,'bonus bInt,5; bonus bAgi,2;',NULL,NULL) Error Code: 1265. Data truncated for column 'attack' at row 1
0 01:06:43 REPLACE INTO `item_db_re` VALUES (1473,'Wizardy_Staff','Wizardry Staff',4,20,NULL,2400,'120:200',NULL,1,NULL,0x00810204,7,2,34,4,90,1,10,'bonus bInt,6; bonus bDex,2;',NULL,NULL) Error Code: 1265. Data truncated for column 'attack' at row 1
[/CODE]
And so on (i've stopped commenting non-working lines after 4 items).
Using MySQL Workbench under Win Server 2008 R2
Using revision 16516

item_db, mob_db_re and mob_skill_db_re works fine.

This post has been edited by Cusy on Jul 27, 2012 23:25

Hercules Elf Bot - Jul 27, 2012 23:27

Originally posted by [b]Kenpachi[/b]
I see...
I'll revert the item DBs to revision 16512 delete my stupig converter and start it again from scratch.
I'm really sorry. /sry

(That happens when you're commiting without being able to test... Note to me: Never do it again!)

This post has been edited by Kenpachi on Jul 27, 2012 23:29

Hercules Elf Bot - Jul 27, 2012 23:33

Originally posted by [b]Kenpachi[/b]
Fixed in [rev=16517].