Issue information

Issue ID
#4705
Status
Working as Intended
Severity
None
Started
Hercules Elf Bot
Jan 11, 2011 13:24
Last Post
Hercules Elf Bot
Apr 19, 2012 10:08
Confirmation
N/A

Hercules Elf Bot - Jan 11, 2011 13:24

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

I Get erros always for use item sql eAthena folder

QUOTE
Erro

Comando SQL:

# REPLACE INTO `item_db` VALUES (5460,'Adv_Dragon_Skull','Evolved Dragon Skull Hat',5,NULL,NULL,1000,NULL,7,NULL,0,0xFFFFFFFF,7,2,256,NULL,60,1,457,'bonus bAllStats,2; bonus bMaxHPrate,3;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5461,'Adv_Whisper_Mask','Evolved Whisper Mask',5,NULL,NULL,300,NULL,1,NULL,0,0xFFFFFFFF,7,2,769,NULL,50,1,458,'bonus bDex,3; bonus2 bSubEle,Ele_Ghost,20;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5462,'Spiked_Scarf','Spiked Scarf',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,1,NULL,90,1,459,'bonus bVit,1; bonus2 bAddRace,RC_DemiHuman,1; bonus2 bSubRace,RC_DemiHuman,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5463,'Rainbow_Scarf','Rainbow Scarf',5,NULL,NULL,100,NULL,1,NULL,0,0xFFFFFFFF,7,2,1,NULL,90,1,460,'bonus bInt,1; bonus bMdef,2; bonus bMatkRate,1;',NULL,NULL); # REPLACE INTO `item_db` VALUES (5464,'Zaha_Doll_Hat','Zaha Doll Hat',5,NULL,NULL,0,NULL,1,NULL,0,0xFFFFFFFF,7,2,256,NULL,0,0,461,'bonus bInt,2; skill \"PR_MAGNIFICAT\",3;',NULL,NULL);[...]

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 (5466,'Wind_Milestone','Wind Milestone',5,NULL,N' at line 6



I do not use sql, but I'll pass because I need to use the mob to use sql because of this option

http://eathena-project.googlecode.com/svn/...ter_athena.conf

QUOTE
//Use SQL item_db and mob_db for the map server
use_sql_db: no


But just can not afford these errors in phpmyadmin so I wanted to ask to correct these errors or alter the configuration as follows:

//Use SQL item_db for the map server
use_item_db_sql_db: no

//Use SQL mob_db for the map server
use_mob_db_sql_db: no


Thanks ><

Hercules Elf Bot - Jan 4, 2012 4:32

Originally posted by [b]Ind[/b]
it's a phpmyadmin bug, import it from the command line and it will work