Hercules Elf Bot - Jun 24, 2008 2:30
Originally posted by [b]Lavin[/b]
http://www.eathena.ws/board/index.php?autocom=bugtracker&showbug=1757
While importing item_db.mysql file to ragnarok database using phpmyadmin, in an Ubuntu 8.04 system, the next error message was received:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Error
SQL query:
# REPLACE INTO `item_db` VALUES (5305,'Pirate_Dagger','Pirate Dagger',5,NULL,10,100,NULL,0,NULL,0,0xFFFFFFFF,7,2,1,NULL,0,0,327,NULL,NULL,NULL);
# REPLACE INTO `item_db` VALUES (5306,'Freya\'s_Crown','Freya\'s Crown',5,NULL,10,500,NULL,12,NULL,0,0xFFFFFFFE,7,2,256,NULL,0,0,328,' bonus2 bSubRace,RC_DemiHuman,5; skill 88,10; bonus bMaxHPrate,20; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5307,'Carmen_Miranda\'s_Hat','Carmen Miranda\'s Hat',5,NULL,10,400,NULL,3,NULL,0,0xFFFFFFFF,7,0,256,NULL,0,1,329,' bonus bMdef,3; bonus3 bAutoSpellWhenHit,1011,1,50; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5308,'Brazil_National_Flag_Hat','Brazil National Flag Hat',5,NULL,10,300,NULL,3,NULL,1,0xFFFFFFFF,7,0,256,NULL,0,1,330,' bonus bSpeedAddRate,25; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5309,'Wool_Mask','Wool Mask',5,NULL,10,200,NULL,1,NULL,0,0xFFFFFFFF,7,0,769,NULL,0,1,331,' skill 220,1; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5310,'Shining_Electric_Bulb','Shining Electric Bulb',5,NULL,10,100,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,0,0,332,' bonus2 bSubEle,Ele_Dark,10; skill 10,1; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5311,'Large_Hibiscus','Large Hibiscus',5,NULL,10,100,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,0,0,333,' bonus bMdef,15; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5312,'Ayothaya_King\'s_Hat','Ayothaya King\'s Hat',5,NULL,10,100,NULL,5,NULL,1,0x000654E2,7,2,256,NULL,0,1,334,' bonus bStr,1; bonus2 bAddRace,RC_DemiHuman,5; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5313,'Diadem','Diadem',5,NULL,10,100,NULL,3,NULL,1,0xFFFFFFFF,7,2,768,NULL,0,1,335,' bonus bInt,1; bonus bMatkRate,3; bonus bCastrate,-3; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5314,'Hockey_Mask','Hockey Mask',5,NULL,10,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,513,NULL,50,0,336,' bonus2 bAddRace,RC_DemiHuman,5; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5315,'Observer','Observer',5,NULL,10,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,512,NULL,35,0,337,' skill 93,1; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5316,'Umbrella_Hat','Umbrella Hat',5,NULL,10,100,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,50,1,338,' bonus2 bSubEle,Ele_Water,3; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5317,'Fisherman\'s_Hat','Fisherman\'s Hat',5,NULL,10,100,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,50,1,339,' bonus3 bAutoSpell,86,3,50; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5318,'Poring_Party_Hat','Poring Party Hat',5,NULL,10,700,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,340,' bonus bAllStats,3; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5319,'Hello_Mother_Hat','Hello Mother Hat',5,NULL,10,200,NULL,2,NULL,0,0xFFFFFFFE,7,2,256,NULL,10,1,341,' bonus bLuk,3; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5320,'Champion_Wreath','Sacred Palma',5,NULL,10,500,NULL,4,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,261,' bonus bAllStats,2; bonus4 bAutoSpellWhenHit,28,1,50,0; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5321,'Indonesian_Bandana','Bandana Merah Putih',5,NULL,10,500,NULL,4,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,1,342,' bonus2 bAddMonsterDropItem,518,100; ',NULL,NULL);
# REPLACE INTO `item_db` VALUES (5322,'Kerchief','Kerchief',5,NULL,10,100,NULL,2,NULL,0,0xFFFFFFFF,7,2,256,NULL,24,0,343,' bonus bFlee,5; bonus bMdef,2; ',NULL,NULL);
REPLACE INTO `item_db`
VALUES ( 5323, 'Sakray_Test_Helm', 'Sakray Test Helm', 5, NULL , 10, 0, NULL , 10, NULL , 0, 0xFFFFFFFF, 7, 2, 256, NULL , 1, 0, 165, ' bonus bAllStats,2; ', NULL , NULL ) ;
MySQL said:
#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 (5324,'Little_Angel_Rock','Little Angel Rock',5,' at line 6
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Though, there is not syntax error apparently.