Issue Information
-
#004705
-
0 - None Assigned
-
Working as Intended
Issue Confirmations
-
Yes (0)No (0)
0
Originally posted by [NITRO]FOX
http://www.eathena.w...er&showbug=4705
I Get erros always for use item sql eAthena folder
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-proje...ter_athena.conf
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 ><
http://www.eathena.w...er&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
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-proje...ter_athena.conf
QUOTE
//Use SQL item_db and mob_db for the map server
use_sql_db: no
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 ><
