Issue information

Issue ID
#3721
Status
Working as Intended
Severity
None
Started
Hercules Elf Bot
Nov 12, 2009 14:00
Last Post
Hercules Elf Bot
Apr 5, 2012 10:13
Confirmation
N/A

Hercules Elf Bot - Nov 12, 2009 14:00

Originally posted by [b][NITRO]FOX[/b]
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=3721

QUOTE
Comando SQL:

# REPLACE INTO `item_db` VALUES (5400,'Fox_Hat','Fox Mask',5,20,NULL,200,NULL,1,NULL,0,0xFFFFFFFF,7,0,769,NULL,0,1,403,'bonus bLuk,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5401,'Black_Glasses','Black Glasses',5,20,NULL,200,NULL,1,NULL,0,0xFFFFFFFF,7,2,512,NULL,70,0,404,'bonus bInt,1; bonus bMdef,2;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5402,'Mischievous_Fairy','Naughty Fairy',5,20,NULL,200,NULL,1,NULL,0,0xFFFFFFFF,7,2,512,NULL,70,0,405,'bonus bFlee2,3;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5403,'Fish_In_Mouth','Fish Mouth',5,20,NULL,200,NULL,0,NULL,0,0xFFFFFFFF,7,2,1,NULL,30,0,406,'bonus2 bAddMonsterDropItem,579,500; bonus2 bAddItemHealRate,579,25;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5404,'Blue_Ribbon','Blue Ribbon',5,20,NULL,100,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,45,1,407,'bonus4 bAutoSpellWhenHit,\"AC_CONCENTRATION\",2,30,0;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5405,'Filir_Hat','Blue Bird',5,20,NULL,200,NULL,0,NULL,0,0xFFFFFFFF,7,2[...]

Mensagens do MySQL : Documentação
#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 ';
REPLACE INTO `item_db` VALUES (5410,'Bread_Bag2','Brown Paper Bag Hat',5,20,N' at line 3


http://svn.eathena.ws/bugs/changeset/14142/trunk

Hercules Elf Bot - Dec 20, 2011 4:58

Originally posted by [b]Ind[/b]
it's a phpmyadmin bug, you should import from the mysql command prompt and it will work fine.