MORTE 78 Posted August 31, 2014 Share Posted August 31, 2014 no getting it vrunner and run.sh and put a start.sh well? #!/bin/sh echo -e "033[31m============================================033[0m" echo -e "033[31m= Drakon2 Servidor Privado 2013/2014 =033[0m" echo -e "033[31m============================================033[0m" echo -e "033[31m Que canales desea iniciar ? n 1 - (1) Iniciar canal 1?n 2 - (2) Iniciar canal 2?n 3 - (3) Iniciar canal 3?n 4 - (4) Iniciar canal 4?n 5 - (5) Iniciar 4 canales?033[0m" read chs case $chs in 1*) echo -e "033[31m Iniciando base de datos ..033[0m" cd /home/drakon2/base/db/ ./db & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando Auth ..033[0m" cd /home/drakon2/canales/auth ./auth & ./clear_logs.sh & sleep 2 clear echo -e "033[31m Iniciando nucleo1_1 ..033[0m" cd /home/drakon2/canales/canal_1/nucleo1_1 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo1_2 ..033[0m" cd /home/drakon2/canales/canal_1/nucleo1_2 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo1_3 ..033[0m" cd /home/drakon2/canales/canal_1/nucleo1_3 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando game99 ..033[0m" cd /home/drakon2/canales/channel99 && ./game99 & ./clear_logs.sh & sleep 2 clear echo -e "033[32m n El canal 1 esta iniciado!033[0m" ;; 2*) echo -e "033[31m Iniciando base de datos ..033[0m" cd /home/drakon2/base/db/ ./db & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando Auth ..033[0m" cd /home/drakon2/canales/auth ./auth & ./clear_logs.sh & sleep 2 clear echo -e "033[31m Iniciando nucleo2_1 ..033[0m" cd /home/drakon2/canales/canal_2/nucleo2_1 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo2_2 ..033[0m" cd /home/drakon2/canales/canal_2/nucleo2_2 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo2_3 ..033[0m" cd /home/drakon2/canales/canal_2/nucleo2_3 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando game99 ..033[0m" cd /home/drakon2/canales/channel99 && ./game99 & ./clear_logs.sh & sleep 2 clear echo -e "033[32m n El canal 2 esta iniciado!033[0m" ;; 3*) echo -e "033[31m Iniciando base de datos ..033[0m" cd /home/drakon2/base/db/ ./db & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando Auth ..033[0m" cd /home/drakon2/canales/auth ./auth & ./clear_logs.sh & sleep 2 clear echo -e "033[31m Iniciando nucleo3_1 ..033[0m" cd /home/drakon2/canales/canal_3/nucleo3_1 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo3_2 ..033[0m" cd /home/drakon2/canales/canal_3/nucleo3_2 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo3_3 ..033[0m" cd /home/drakon2/canales/canal_3/nucleo3_3 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando game99 ..033[0m" cd /home/drakon2/canales/channel99 && ./game99 & ./clear_logs.sh & sleep 2 clear echo -e "033[32m n El canal 3 esta iniciado!033[0m" ;; 4*) echo -e "033[31m Iniciando base de datos ..033[0m" cd /home/drakon2/base/db/ ./db & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando Auth ..033[0m" cd /home/drakon2/canales/auth ./auth & ./clear_logs.sh & sleep 2 clear echo -e "033[31m Iniciando nucleo4_1 ..033[0m" cd /home/drakon2/canales/canal_4/nucleo4_1 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo4_2 ..033[0m" cd /home/drakon2/canales/canal_4/nucleo4_2 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo4_3 ..033[0m" cd /home/drakon2/canales/canal_4/nucleo4_3 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando game99 ..033[0m" cd /home/drakon2/canales/channel99 && ./game99 & ./clear_logs.sh & sleep 2 clear echo -e "033[32m n El canal 4 esta iniciado!033[0m" ;; 5*) echo -e "033[31m Iniciando base de datos ..033[0m" cd ./base/db/ ./db & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando Auth ..033[0m" cd /home/drakon2/canales/auth ./auth & ./clear_logs.sh & sleep 2 clear echo -e "033[31m Iniciando nucleo1_1 ..033[0m" cd /home/drakon2/canales/canal_1/nucleo1_1 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo1_2 ..033[0m" cd /home/drakon2/canales/canal_1/nucleo1_2 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo1_3 ..033[0m" cd /home/drakon2/canales/canal_1/nucleo1_3 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo2_1 ..033[0m" cd /home/drakon2/canales/canal_2/nucleo2_1 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo2_2 ..033[0m" cd /home/drakon2/canales/canal_2/nucleo2_2 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo2_3 ..033[0m" cd /home/drakon2/canales/canal_2/nucleo2_3 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m Iniciando nucleo3_1 ..033[0m" cd /home/drakon2/canales/canal_3/nucleo3_1 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo3_2 ..033[0m" cd /home/drakon2/canales/canal_3/nucleo3_2 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo3_3 ..033[0m" cd /home/drakon2/canales/canal_3/nucleo3_3 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m Iniciando nucleo4_1 ..033[0m" cd /home/drakon2/canales/canal_4/nucleo4_1 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo4_2 ..033[0m" cd /home/drakon2/canales/canal_4/nucleo4_2 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando nucleo4_3 ..033[0m" cd /home/drakon2/canales/canal_4/nucleo4_3 && ./game & ./clear_logs.sh & sleep 2 clear echo -e "033[31m n Iniciando game99 ..033[0m" cd /home/drakon2/canales/channel99 && ./game99 & ./clear_logs.sh & sleep 2 clear echo -e "033[32m n Se ha iniciado Ch1, Ch2, Ch3 y Ch4!033[0m" ;; esac Link to comment Share on other sites More sharing options...
Radiatos 0 Posted September 6, 2014 Share Posted September 6, 2014 hello, i became this error db syserr: SYSERR: Sep 6 16:39:28 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='185.11.147.25') SYSERR: Sep 6 16:39:29 :: Process: FDWATCH: peer null in event: ident 20 SYSERR: Sep 6 16:39:31 :: Process: FDWATCH: peer null in event: ident 22 SYSERR: Sep 6 16:39:33 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='185.11.147.25') SYSERR: Sep 6 16:39:35 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='185.11.147.25') SYSERR: Sep 6 16:39:35 :: Process: FDWATCH: peer null in event: ident 20 SYSERR: Sep 6 16:39:36 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='185.11.147.25') please help.. Link to comment Share on other sites More sharing options...
MrKarpiuk 124 Posted September 8, 2014 Share Posted September 8, 2014 hmm help me i'm dont have any idea how fix this SYSERR: Sep 8 15:17:31 :: Start: TABLE_POSTFIX not configured use default Sep 8 15:17:31 :: connecting to MySQL server (player) Sep 8 15:17:31 :: CREATING DIRECT_SQL Sep 8 15:17:31 :: AsyncSQL: locale euckr Sep 8 15:17:31 :: failed, retrying in 5 seconds Sep 8 15:17:36 :: CREATING DIRECT_SQL Sep 8 15:17:36 :: AsyncSQL: locale euckr Link to comment Share on other sites More sharing options...
Darkoz 1 Posted September 26, 2014 Share Posted September 26, 2014 Can someone give me a client compatible with this file? i download the sg put the launcher but didnt work Link to comment Share on other sites More sharing options...
Rumor 2606 Posted September 26, 2014 Author Share Posted September 26, 2014 http://metin2dev.org/board/topic/136-40250-test-client/ Link to comment Share on other sites More sharing options...
Darkoz 1 Posted September 26, 2014 Share Posted September 26, 2014 With the client u link i got this: Error: Bad magic number in libtraceback.pyc with your launcher called: metin2client_r36469_unprotected_working_NOHS Link to comment Share on other sites More sharing options...
dofuzeiro 1 Posted September 29, 2014 Share Posted September 29, 2014 (edited) Can someone help me pls with this error thanks alot. edit: i resolved that error but now i have this one: look at putty : i put the correct password which is 123456, ( i did the password mysql reset) but i still get errors really strange, if anybody could help me, i really appreciate thanks. Edited August 18, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Rumor 2606 Posted September 29, 2014 Author Share Posted September 29, 2014 (edited) Can someone help me pls with this error thanks alot. edit: i resolved that error but now i have this one: look at putty : i put the correct password which is 123456, ( i did the password mysql reset) but i still get errors really strange, if anybody could help me, i really appreciate thanks. Don't edit your reply saying you resolved an error without even explaining how you resolved it. Until you explain that you won't get any further help, howabout that? Edited August 18, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
dofuzeiro 1 Posted September 29, 2014 Share Posted September 29, 2014 (edited) Can someone help me pls with this error thanks alot. edit: i resolved that error but now i have this one: look at putty : i put the correct password which is 123456, ( i did the password mysql reset) but i still get errors really strange, if anybody could help me, i really appreciate thanks. Don't edit your reply saying you resolved an error without even explaining how you resolved it. Until you explain that you won't get any further help, howabout that? Yeah you are right to be honest i dont even know how i solved that, cause i did so many things, like delete and start again with, i delete the mysql folder and put it on again, next if i remember correctly i rebooted my machine went to putty and tried installing everything install.sh as the metin2 user, gave chown -R metin2 . in every folder of /var/db /var/db/mysql and somehow i rebooted again and started working, kinda strange, i didn't want to post this as the solution cause i was not sure of what i did exactly, now if you could help me with my problem my host isn't allowed on the mysql server i would really appreciate. Edited August 18, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Darkoz 1 Posted September 30, 2014 Share Posted September 30, 2014 why when i open item_proto or mob proto is empty? Link to comment Share on other sites More sharing options...
Rumor 2606 Posted September 30, 2014 Author Share Posted September 30, 2014 Yeah you are right to be honest i dont even know how i solved that, cause i did so many things, like delete and start again with, i delete the mysql folder and put it on again, next if i remember correctly i rebooted my machine went to putty and tried installing everything install.sh as the metin2 user, gave chown -R metin2 . in every folder of /var/db /var/db/mysql and somehow i rebooted again and started working, kinda strange, i didn't want to post this as the solution cause i was not sure of what i did exactly, now if you could help me with my problem my host isn't allowed on the mysql server i would really appreciate. Setup an account for you to login to the database via Navicat and an account for your game cores to interact with your database using. For this example I'll use the username "rumor" for my account and "metin2" for the game core's account. Every password in this example will be "password" but please DO NOT use this as your password! If you have a static IP address and wish to restrict access to the database only to your IP, change the "%" sign to your IP. The "%" sign indicates that any IP address is allowed to connect to the database using the specified credentials. mysql -pNow enter the password you set with mysqladmin earlier... and you will see this prompt: mysql>This is where we set the actual permissions for the accounts up. GRANT ALL PRIVILEGES ON *.* TO 'rumor'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'metin2'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; quit pro tip: remember (or write down) this information because you will need it later. 1 Link to comment Share on other sites More sharing options...
dofuzeiro 1 Posted September 30, 2014 Share Posted September 30, 2014 Yeah you are right to be honest i dont even know how i solved that, cause i did so many things, like delete and start again with, i delete the mysql folder and put it on again, next if i remember correctly i rebooted my machine went to putty and tried installing everything install.sh as the metin2 user, gave chown -R metin2 . in every folder of /var/db /var/db/mysql and somehow i rebooted again and started working, kinda strange, i didn't want to post this as the solution cause i was not sure of what i did exactly, now if you could help me with my problem my host isn't allowed on the mysql server i would really appreciate. Setup an account for you to login to the database via Navicat and an account for your game cores to interact with your database using. For this example I'll use the username "rumor" for my account and "metin2" for the game core's account. Every password in this example will be "password" but please DO NOT use this as your password! If you have a static IP address and wish to restrict access to the database only to your IP, change the "%" sign to your IP. The "%" sign indicates that any IP address is allowed to connect to the database using the specified credentials. mysql -p Now enter the password you set with mysqladmin earlier... and you will see this prompt: mysql> This is where we set the actual permissions for the accounts up. GRANT ALL PRIVILEGES ON *.* TO 'rumor'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'metin2'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; quit pro tip: remember (or write down) this information because you will need it later. thanks alot it worked =), i'm going to test the filles now and see if everything is working perfectly, once again thanks. and sorry for the inconvenience EDIT: btw why is mob proto and item proto empty? is there some .sql file that i need to run? Thanks again. 1 Link to comment Share on other sites More sharing options...
Rumor 2606 Posted September 30, 2014 Author Share Posted September 30, 2014 it should be in the mob_proto.txt, mob_names.txt, item_proto.txt, item_names.txt files in the serverfiles. If those are empty maybe something else is configured wrong on the server so it isn't finding those? Like broken/missing symlinks. Link to comment Share on other sites More sharing options...
dofuzeiro 1 Posted September 30, 2014 Share Posted September 30, 2014 it should be in the mob_proto.txt, mob_names.txt, item_proto.txt, item_names.txt files in the serverfiles. If those are empty maybe something else is configured wrong on the server so it isn't finding those? Like broken/missing symlinks. yeah i have those files in the filezilla in some folder (idk the name now) but im talking about the navicat player db and the item_proto table and mob_proto table those are empty what am i suppose to do? i can normally start the server? Ty. Link to comment Share on other sites More sharing options...
Rumor 2606 Posted October 1, 2014 Author Share Posted October 1, 2014 well check to make sure the server is even starting, specifically the DB score. maybe you're getting an error when starting and it won't load the tables with the data from the txt files. Link to comment Share on other sites More sharing options...
dofuzeiro 1 Posted October 2, 2014 Share Posted October 2, 2014 (edited) well check to make sure the server is even starting, specifically the DB score. maybe you're getting an error when starting and it won't load the tables with the data from the txt files. Hello the server starts normally, at least i use run.sh and no errors appear, however i went to the db sys log and this appeared: Whenever i tried to login to the server it stays in You will be connected to the server. Also there is the db Also mob proto is empty, Humh very strange and i dont know what to do :X, thanks. Edited August 18, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Rumor 2606 Posted October 2, 2014 Author Share Posted October 2, 2014 type ps to check if db core is running type "service mysql-server status" to check if mysql is on Link to comment Share on other sites More sharing options...
Despero 130 Posted October 2, 2014 Share Posted October 2, 2014 I need a Client for this Files ? Link to comment Share on other sites More sharing options...
Rumor 2606 Posted October 3, 2014 Author Share Posted October 3, 2014 No you can play with imaginary client 5 Link to comment Share on other sites More sharing options...
Premium SirGath 1 Posted October 15, 2014 Premium Share Posted October 15, 2014 SYSERR: Oct 15 23:21:35 :: pid_init: Start of pid: 21338 SYSERR: Oct 15 23:21:35 :: Start: TABLE_POSTFIX not configured use default SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB5xE9xB0xB3' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (101, "µé°³", "Wild SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB4xC1xB4xEB' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (102, "´Á´ë", "Wolf t_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2108, " SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xC0xFCxB0xA5xC0xCE...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2131, " skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34005, "¾Æ SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34006, "¾Æ SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34007, "¾Æ SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34008, "¾Æ SYSERR: Oct 15 23:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist query: SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry SYSERR: Oct 15 23:21:36 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) I Need help.. is db sysser @Rumor 1 Link to comment Share on other sites More sharing options...
Premium SirGath 1 Posted October 15, 2014 Premium Share Posted October 15, 2014 No you can play with imaginary client Link to comment Share on other sites More sharing options...
Rumor 2606 Posted October 15, 2014 Author Share Posted October 15, 2014 SYSERR: Oct 15 23:21:35 :: pid_init: Start of pid: 21338 SYSERR: Oct 15 23:21:35 :: Start: TABLE_POSTFIX not configured use default SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB5xE9xB0xB3' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (101, "µé°³", "Wild SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB4xC1xB4xEB' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (102, "´Á´ë", "Wolf t_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2108, " SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xC0xFCxB0xA5xC0xCE...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2131, " skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34005, "¾Æ SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34006, "¾Æ SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34007, "¾Æ SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34008, "¾Æ SYSERR: Oct 15 23:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist query: SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry SYSERR: Oct 15 23:21:36 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) I Need help.. is db sysser @Rumor In this query it looks like it has an issue with the name. It says the "string value" is incorrect. Notice that on all of these errors it's for these foreign character sets using things like "´Á´ë". I suggest changing these wherever they are (I think in the item_names.txt file). I think the xB5XE9xB0xB3 stuff is the way the game core is interpreting the entries for the name column. So maybe you should try fixing these names like "´Á´ë" to something in normal letters. SYSERR: Oct 15 23:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist Regarding this, you need to create a table in account called iptocountry. So you can go into Navicat and right click the account database then click "Execute MySQL File..." then choose the file below (save the contents I post down there as a .sql file): SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `iptocountry` -- ---------------------------- DROP TABLE IF EXISTS `iptocountry`; CREATE TABLE `iptocountry` ( `IP_FROM` varchar(16) NOT NULL DEFAULT '', `IP_TO` varchar(16) DEFAULT NULL, `COUNTRY_NAME` varchar(16) DEFAULT NULL, PRIMARY KEY (`IP_FROM`) ) ENGINE=MyISAM DEFAULT CHARSET=big5; -- ---------------------------- -- Records of iptocountry -- ---------------------------- INSERT INTO `iptocountry` VALUES ('127.0.0.1', '127.0.0.1', 'localhost'); 1 Link to comment Share on other sites More sharing options...
Premium SirGath 1 Posted October 16, 2014 Premium Share Posted October 16, 2014 SYSERR: Oct 15 23:21:35 :: pid_init: Start of pid: 21338 SYSERR: Oct 15 23:21:35 :: Start: TABLE_POSTFIX not configured use default SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB5xE9xB0xB3' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (101, "µé°³", "Wild SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xB4xC1xB4xEB' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (102, "´Á´ë", "Wolf t_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2108, " SYSERR: Oct 15 23:21:35 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xC0xFCxB0xA5xC0xCE...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (2131, " skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34005, "¾Æ SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34006, "¾Æ SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34007, "¾Æ SYSERR: Oct 15 23:21:36 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: 'xBExC6xB1xE2 xC0...' for column 'name' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34008, "¾Æ SYSERR: Oct 15 23:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist query: SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry SYSERR: Oct 15 23:21:36 :: Load: DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) I Need help.. is db sysser @Rumor In this query it looks like it has an issue with the name. It says the "string value" is incorrect. Notice that on all of these errors it's for these foreign character sets using things like "´Á´ë". I suggest changing these wherever they are (I think in the item_names.txt file). I think the xB5XE9xB0xB3 stuff is the way the game core is interpreting the entries for the name column. So maybe you should try fixing these names like "´Á´ë" to something in normal letters. SYSERR: Oct 15 23:21:36 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.iptocountry' doesn't exist Regarding this, you need to create a table in account called iptocountry. So you can go into Navicat and right click the account database then click "Execute MySQL File..." then choose the file below (save the contents I post down there as a .sql file): SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `iptocountry` -- ---------------------------- DROP TABLE IF EXISTS `iptocountry`; CREATE TABLE `iptocountry` ( `IP_FROM` varchar(16) NOT NULL DEFAULT '', `IP_TO` varchar(16) DEFAULT NULL, `COUNTRY_NAME` varchar(16) DEFAULT NULL, PRIMARY KEY (`IP_FROM`) ) ENGINE=MyISAM DEFAULT CHARSET=big5; -- ---------------------------- -- Records of iptocountry -- ---------------------------- INSERT INTO `iptocountry` VALUES ('127.0.0.1', '127.0.0.1', 'localhost'); In mob_proto.txt i have this name of mobs: 저주받은 늑대 Link to comment Share on other sites More sharing options...
Premium SirGath 1 Posted October 16, 2014 Premium Share Posted October 16, 2014 and i haven't this letters: ´Á´ë Link to comment Share on other sites More sharing options...
Premium SirGath 1 Posted October 16, 2014 Premium Share Posted October 16, 2014 Ok now when i choose character return to login.. Link to comment Share on other sites More sharing options...
Recommended Posts