portoswat 0 Posted February 18, 2020 Boas malta, Estou tentando fazer um servidor, so mesmo para eu e alguns amigos tirarmos os vicio de antigamente. Bom segui todos os passos porem acontece-me isto alguem me pode ajudar? http://prnt.sc/r3zhcp Share this post Link to post Share on other sites
0 portoswat 0 Posted February 18, 2020 (edited) 1 hora atrás, D 4 R K. disse: Syserr? Mais daqui pouco deixo aí ainda estou no trabalho, não consegui deixar logo de manha Tenho o mysql8 instalado. aqui fica: SYSERR: Feb 18 13:34:18.852128 :: pid_init: Start of pid: 41116 SYSERR: Feb 18 13:34:18.852157 :: Start: TABLE_POSTFIX not configured use default SYSERR: Feb 18 13:34:18.856464 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: 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 ', battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_clic' at line 1 query: SELECT vnum, name, locale_name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, 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_leve SYSERR: Feb 18 13:34:18.856488 :: InitializeMobTable: Could not load mob_proto. No results! SYSERR: Feb 18 13:34:18.856496 :: InitializeTables: InitializeMobTable FAILED SYSERR: Feb 18 13:34:18.856503 :: Initialize: Table Initialize FAILED SYSERR: Feb 18 13:34:18.857372 :: pid_deinit: End of pid SYSERR: Feb 18 13:34:21.869980 :: pid_init: Start of pid: 41153 SYSERR: Feb 18 13:34:21.870006 :: Start: TABLE_POSTFIX not configured use default SYSERR: Feb 18 13:34:21.874328 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: 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 ', battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_clic' at line 1 query: SELECT vnum, name, locale_name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, 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_leve SYSERR: Feb 18 13:34:21.874339 :: InitializeMobTable: Could not load mob_proto. No results! SYSERR: Feb 18 13:34:21.874347 :: InitializeTables: InitializeMobTable FAILED SYSERR: Feb 18 13:34:21.874354 :: Initialize: Table Initialize FAILED SYSERR: Feb 18 13:34:21.875250 :: pid_deinit: End of pid SYSERR: Feb 18 13:34:24.889146 :: pid_init: Start of pid: 41203 SYSERR: Feb 18 13:34:24.889172 :: Start: TABLE_POSTFIX not configured use default SYSERR: Feb 18 13:34:24.893514 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: 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 ', battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_clic' at line 1 query: SELECT vnum, name, locale_name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, 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_leve SYSERR: Feb 18 13:34:24.893544 :: InitializeMobTable: Could not load mob_proto. No results! SYSERR: Feb 18 13:34:24.893553 :: InitializeTables: InitializeMobTable FAILED SYSERR: Feb 18 13:34:24.893559 :: Initialize: Table Initialize FAILED SYSERR: Feb 18 13:34:24.894490 :: pid_deinit: End of pid SYSERR: Feb 18 13:34:27.931732 :: pid_init: Start of pid: 41253 SYSERR: Feb 18 13:34:27.931758 :: Start: TABLE_POSTFIX not configured use default SYSERR: Feb 18 13:34:27.936071 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: 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 ', battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_clic' at line 1 query: SELECT vnum, name, locale_name, type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, 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_leve SYSERR: Feb 18 13:34:27.936082 :: InitializeMobTable: Could not load mob_proto. No results! SYSERR: Feb 18 13:34:27.936090 :: InitializeTables: InitializeMobTable FAILED SYSERR: Feb 18 13:34:27.936096 :: Initialize: Table Initialize FAILED SYSERR: Feb 18 13:34:27.936991 :: pid_deinit: End of pid Edited February 18, 2020 by portoswat (see edit history) Share this post Link to post Share on other sites
0 [SA]Phoenix 9 Posted February 18, 2020 SYSERR: Feb 18 13:34:27.936082 :: InitializeMobTable: Could not load mob_proto. No results! SYSERR: Feb 18 13:34:27.936090 :: InitializeTables: InitializeMobTable FAILED SYSERR: Feb 18 13:34:27.936096 :: Initialize: Table Initialize FAILED ela nao esta ler estes arquivos algo estas a fazer mas tens ai vdi delas procura Share this post Link to post Share on other sites
0 portoswat 0 Posted February 18, 2020 (edited) Sim eu sei que exite a vdi, porem nao tenho pc para montar em virtual box, tenho maquina pronta com freebsd e tenho me conectado por putty ja tenho tudo funcional a parte da base de dados e nao consigo perceber o porque .... Sera que ela esta a falhar pela questao do mysql? Edited February 18, 2020 by portoswat (see edit history) Share this post Link to post Share on other sites
0 NewWars 875 Posted February 18, 2020 Os logs não estão a mostrar a query inteira, mas provavelmente o problema é do server MySQL que usas, lembro-me que maior parte da mysql data do addict é para MariaDB, tenta fazer uma instalação da mariadb55, apagar a data a fazer import novamente Nome da package é mariadb55-server pkg install mariadb55-server Cumprimentos. Share this post Link to post Share on other sites
0 portoswat 0 Posted February 19, 2020 Em 18/02/2020 at 17:52, NewWars disse: Os logs não estão a mostrar a query inteira, mas provavelmente o problema é do server MySQL que usas, lembro-me que maior parte da mysql data do addict é para MariaDB, tenta fazer uma instalação da mariadb55, apagar a data a fazer import novamente Nome da package é mariadb55-server pkg install mariadb55-server Cumprimentos. Fiz como dissestes desinstalei tudo e voltei a colocar o correcto, porem mesmo assim nao consegui Deixo ai o syerr para alguem me tentar ajudar autogame starting game Wed Feb 19 21:04:30 WET 2020 running db autogame starting game Wed Feb 19 21:04:33 WET 2020 running db autogame starting game Wed Feb 19 21:04:36 WET 2020 running db autogame starting game Wed Feb 19 21:04:40 WET 2020 running db autogame starting game Wed Feb 19 21:04:43 WET 2020 running db autogame starting game Wed Feb 19 21:04:46 WET 2020 running db autogame starting game Wed Feb 19 21:04:49 WET 2020 running db autogame starting game Wed Feb 19 21:04:52 WET 2020 running db autogame starting game Wed Feb 19 21:04:55 WET 2020 running db autogame starting game Wed Feb 19 21:04:58 WET 2020 running db autogame starting game Wed Feb 19 21:05:01 WET 2020 running db autogame starting game Wed Feb 19 21:05:04 WET 2020 running db autogame starting game Wed Feb 19 21:05:07 WET 2020 running db Share this post Link to post Share on other sites
Boas malta,
Estou tentando fazer um servidor, so mesmo para eu e alguns amigos tirarmos os vicio de antigamente.
Bom segui todos os passos porem acontece-me isto alguem me pode ajudar?
http://prnt.sc/r3zhcp
Share this post
Link to post
Share on other sites