Jump to content

Db não se mantém ligada


Requiem
 Share

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
Share on other sites

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
Share on other sites

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
Share on other sites

Okay.. Vou então sacas as files já com VDI que estão aqui no fórum..

Obrigado.

Podes fechar aqui o tópico, caso seja preciso algo crio num tópico próprio para esse assunto.

Para todos os outros que vejam este tópico depois devo disponibilizar as files já com tudo como deve ser, para se quiserem usar com a source do tierri que o possam fazer.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

×
×
  • Create New...