Jump to content

Db não se mantém ligada


Requiem

Recommended Posts

Resolvi um dos erros que afetava que era a ausência de um ficheiro na lib, que já resolvi..

Mas agora já percebi porque não consigo ligar o cliente.. O game está a funcionar corretamente, mas a db de x em x tempo vai se desligando..

Vi o ficheiro e não percebi qual o problema.

Se me puderem ajudar..

[spoiler=Autorun.log]

Real Server
Log OffSuccess PLAYER
Success ACCOUNT
Success COMMON
Success HOTBACKUP
테스트 파일이 없습니다. 그대로 진행합니다.
테스트 파일이 없습니다. 그대로 진행합니다.
item_proto_test.txt 파일을 읽어오지 못했습니다
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Real Server
Log OffSuccess PLAYER
Success ACCOUNT
Success COMMON
Success HOTBACKUP
테스트 파일이 없습니다. 그대로 진행합니다.
테스트 파일이 없습니다. 그대로 진행합니다.
item_proto_test.txt 파일을 읽어오지 못했습니다
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Real Server
Log OffSuccess PLAYER
Success ACCOUNT
Success COMMON
Success HOTBACKUP
테스트 파일이 없습니다. 그대로 진행합니다.
테스트 파일이 없습니다. 그대로 진행합니다.
item_proto_test.txt 파일을 읽어오지 못했습니다
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Real Server
Log OffSuccess PLAYER
Success ACCOUNT
Success COMMON
Success HOTBACKUP
테스트 파일이 없습니다. 그대로 진행합니다.
테스트 파일이 없습니다. 그대로 진행합니다.
item_proto_test.txt 파일을 읽어오지 못했습니다
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Real Server
Log OffSuccess PLAYER
Success ACCOUNT
Success COMMON
Success HOTBACKUP
테스트 파일이 없습니다. 그대로 진행합니다.
테스트 파일이 없습니다. 그대로 진행합니다.
item_proto_test.txt 파일을 읽어오지 못했습니다
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Real Server
Log OffSuccess PLAYER
Success ACCOUNT
Success COMMON
Success HOTBACKUP
테스트 파일이 없습니다. 그대로 진행합니다.
테스트 파일이 없습니다. 그대로 진행합니다.
item_proto_test.txt 파일을 읽어오지 못했습니다
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Real Server
Log OffSuccess PLAYER
Success ACCOUNT
Success COMMON
Success HOTBACKUP
테스트 파일이 없습니다. 그대로 진행합니다.
테스트 파일이 없습니다. 그대로 진행합니다.
item_proto_test.txt 파일을 읽어오지 못했습니다
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Real Server
Log OffSuccess PLAYER
Success ACCOUNT
Success COMMON
Success HOTBACKUP
테스트 파일이 없습니다. 그대로 진행합니다.
테스트 파일이 없습니다. 그대로 진행합니다.
item_proto_test.txt 파일을 읽어오지 못했습니다
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Real Server
Log OffSuccess PLAYER
Success ACCOUNT
Success COMMON
Success HOTBACKUP
테스트 파일이 없습니다. 그대로 진행합니다.
테스트 파일이 없습니다. 그대로 진행합니다.
item_proto_test.txt 파일을 읽어오지 못했습니다
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Real Server
Log OffSuccess PLAYER
Success ACCOUNT
Success COMMON
Success HOTBACKUP
테스트 파일이 없습니다. 그대로 진행합니다.
테스트 파일이 없습니다. 그대로 진행합니다.
item_proto_test.txt 파일을 읽어오지 못했습니다
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Real Server
Log OffSuccess PLAYER
Success ACCOUNT
Success COMMON
Success HOTBACKUP
테스트 파일이 없습니다. 그대로 진행합니다.
테스트 파일이 없습니다. 그대로 진행합니다.
item_proto_test.txt 파일을 읽어오지 못했습니다
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)

 

 

Obrigado desde já.

As files são as do Dynamic, a source será as duas do tierri mas ainda não compilei nenhuma delas, estava só a tentar colocar as files a funcionar.

Link to comment

Estavas a dizer para fazer em localhost.. Não sei porquê, já tentei fazer no meu pc e simplesmente nem no WinSCP consigo entrar, por isso é que uso hamachi.

 

 

 

SYSERR: Feb 26 16:19:27 :: pid_init:
Start of pid: 1436

SYSERR: Feb 26 16:19:27 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Feb 26 16:19:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'latin1' in 'field list' (query: replace into mob_proto (vnum, name, latin1, 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 (103, "????", "Lobo Alfa", 0, 0, 0, 4, 0, 0, 1, 0, 0,
SYSERR: Feb 26 16:19:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'latin1' in 'field list' (query: replace into mob_proto (vnum, name, latin1, 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 (104, "????", "Lobo Azul", 0, 0, 0, 6, 0, 0, 1, 0, 0,
SYSERR: Feb 26 16:19:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'latin1' in 'field list' (query: replace into mob_proto (vnum, name, latin1, 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 (105, "?? ????", "Lobo Alfa Azul", 0, 0, 0, 9, 0, 0, 1
SYSERR: Feb 26 16:19:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'latin1' in 'field list' (query: replace into mob_proto (vnum, name, latin1, 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 (106, "????", "Lobo Cinzento", 0, 0, 0, 13, 0, 0, 1, 0
SYSERR: Feb 26 16:19:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'latin1' in 'field list' (query: replace into mob_proto (vnum, name, latin1, 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 (107, "?? ????", "Lobo Alfa Cinzento", 0, 1, 0, 16, 0,
SYSERR: Feb 26 16:19:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'latin1' in 'field list' (query: replace into mob_proto (vnum, name, latin1, 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 (108, "???", "Javali Selvagem", 0, 0, 0, 7, 0, 0, 1, 0
SYSERR: Feb 26 16:19:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'latin1' in 'field list' (query: replace into mob_proto (vnum, name, latin1, 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 (109, "?? ???", "Javali Vermelho", 0, 1, 0, 10, 0, 0,
SYSERR: Feb 26 16:19:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'latin1' in 'field list' (query: replace into mob_proto (vnum, name, latin1, 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 (110, "?", "Urso", 0, 0, 3, 12, 0, 0, 1, 0, 0, 0, 3001
SYSERR: Feb 26 16:19:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'latin1' in 'field list' (query: replace into mob_proto (vnum, name, latin1, 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 (111, "???", "Urso Cinzento", 0, 1, 4, 15, 0, 0, 1, 0,


 

 

e por aí fora.. tem muitas mais linhas

Link to comment

Não te sei dizer pois em não uso files a sério ao testar.

Eu apenas fiz a estrutura para as files (auth, db, ch99, ch1 com 3 cores)

Para a base de dados usei o proto extraido do cliente em txt

 

Já vi um ou dois tópicos aqui criados com isso, um deles usava as básicas 34k do wom2, penso que foi o sonitex a postar

No entanto a minha recomendação é sempre começares a fazer umas mesmo do 0, demora mais tempo e dá mais trabalho mas ficas a saber exatamente o que lá está adicionado

Link to comment
Guest
This topic is now closed to further replies.
×
×
  • Create New...