Can't import "item_db_re.sql"

[Bahmut]

Hello,

I'm using phpMyAdmin to setup the SQL Databases of my rAthena Server (Revision 15622). Today I wanted to try the remode and thought about importing "item_db_re.sql", but I always get this Error:

SQL-command:
REPLACE INTO `item_db_re`
VALUES ( 1640, 'Krieger_Onehand_Staff1', 'Glorious Arc Wand', 4, 20, NULL , 0, 70 :135, NULL , 1, 0, 0x00818314, 7, 2, 2, 4, 80, 1, 10, 'bonus2 bMagicAddRace,RC_DemiHuman,15; bonus2 bIgnoreMdefRate,RC_DemiHuman,25 + ((getrefine() > 5) ? 5 : 0); bonus bUnbreakableWeapon,0; if(getrefine() > 8) { bonus bMatkRate,5; bonus bCastrate,-5; bonus bDelayRate,-5; }', '', '' ) ;

MySQL reports:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':135,NULL,1,0,0x00818314,7,2,2,4,80,1,10,'bonus2 bMagicAddRace,RC_DemiHuman,15; ' at line 1

Anyone know what is wrong with my sql file or phpMyAdmin?

Edited March 16, 2012 by Bahmut

[JayPee]

SQL-command:

REPLACE INTO `item_db_re`

VALUES ( 1640, 'Krieger_Onehand_Staff1', 'Glorious Arc Wand', 4, 20, NULL , 0, 70 :135, NULL , 1, 0, 0x00818314, 7, 2, 2, 4, 80, 1, 10, 'bonus2 bMagicAddRace,RC_DemiHuman,15; bonus2 bIgnoreMdefRate,RC_DemiHuman,25 + ((getrefine() > 5) ? 5 : 0); bonus bUnbreakableWeapon,0; if(getrefine() > 8) { bonus bMatkRate,5; bonus bCastrate,-5; bonus bDelayRate,-5; }', '', '' ) ;

MySQL reports:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':135,NULL,1,0,0x00818314,7,2,2,4,80,1,10,'bonus2 bMagicAddRace,RC_DemiHuman,15; ' at line 1

Iam suspecting the problem is the :135, i think it should be ,135

try this:

* edit the item_db_re.sql and find the Krieger_Onehand_Staff1 and edit the :135 and change it like this:

VALUES ( 1640, 'Krieger_Onehand_Staff1', 'Glorious Arc Wand', 4, 20, NULL , 0, 70,135, NULL , 1, 0, 0x00818314, 7, 2, 2, 4, 80, 1, 10, 'bonus2 bMagicAddRace,RC_DemiHuman,15; bonus2 bIgnoreMdefRate,RC_DemiHuman,25 + ((getrefine() > 5) ? 5 : 0); bonus bUnbreakableWeapon,0; if(getrefine() > 8) { bonus bMatkRate,5; bonus bCastrate,-5; bonus bDelayRate,-5; }', '', '' ) ;

[Bahmut]

Now the I get this error:

#1136 - Column count doesn't match value count at row 1

This is because the '70:135' has to be like this 'ATK:MATK':

REPLACE INTO `item_db_re` VALUES ('ID','Name','Name','Type','Price','Sell','Weight','ATK:MATK','DEF','Range','Slot','Job','Upper','Gender','Loc','wLV','eLV','Refineable','View','Script','OnEquip_Script','OnUnequip_Script');

This is the line before the error line:

REPLACE INTO `item_db_re` VALUES (1637,'Eraser','Eraser',4,20,NULL,500,'80:170',NULL,1,0,0x00018314,2,2,2,4,70,1,10,'bonus bInt,3; bonus bDex,2; bonus bSPrecovRate,8; if( getrefine() > 9 ) bonus5 bAutoSpell,"NPC_WIDESOULDRAIN",3,5,BF_MAGIC,0; else bonus5 bAutoSpell,"NPC_WIDESOULDRAIN",1,5,BF_MAGIC,0;','','');

I could not find a mistake in both of the lines, but maybe someone here can help me.

This is the file I'm using:

item_db_re.sql

[LCDTheOG]

what version is your mysql?

[Bahmut]

I updated my sql-files and now it's working.