Beiträge von Manecko

Manecko · 28. Dezember 2021

Zitat von .colossus.

Zitat von Manecko

Besteht nicht die Möglichkeit rauszufinden, woran es liegt?
Wenn nach Serverstart die CHs für 1-3 Sec laufen bevor sie abstürzen - ist das ein mögliches Indiz?

du kannst bei einem crash den dump (.core) mit zum Beispiel gdb debuggen. Siehe --> Bitte melden Sie sich an, um diesen Link zu sehen.

Ok, wie genau bringt mich das weiter, wenn ich den genannten Befehl eingebe?

Hab das noch nie benutzt.

Manecko · 28. Dezember 2021

Zitat von 'Asasel

Joa deine db ist am arsch. Der fehler kann leider alles mögliche bedeuten. Schwer da jetzt konkret was festzulegen

Besteht nicht die Möglichkeit rauszufinden, woran es liegt?

Wenn nach Serverstart die CHs für 1-3 Sec laufen bevor sie abstürzen - ist das ein mögliches Indiz?

Manecko · 27. Dezember 2021

Die Syserr von DB:

Code

SYSERR: Dec 23 16:54:06 :: pid_init:
Start of pid: 1229
SYSERR: Dec 23 16:54:06 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Dec 23 16:54:14 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Dec 23 16:54:16 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Dec 23 16:54:20 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Dec 23 16:54:23 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Dec 23 16:54:25 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Dec 23 16:54:27 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Dec 23 16:54:28 :: Process: FDWATCH: peer null in event: ident 20

Alles anzeigen

Manecko · 27. Dezember 2021

mysql is running as pid 743.

Mysql läuft ja.

EDIT:

Gesehen, das nach dem Serverstart die Channel für 1-2 Sekunden laufen, falls das wichtig ist.

Manecko · 27. Dezember 2021

Ok, konnte es soweit beheben, danke.

Nur hab ich das Problem, wenn ich den Server starte, starten DB und Auth, die Channels aber nicht.

Versuch ich ingame einzuloggen, schmiert auch Auth ab.

Hab eig in den Error nichts drin außer im Auth das:

Code

socket_connect: HOST localhost:11000, could not connect.

Manecko · 27. Dezember 2021

Servus

Wenn ich den Server starten will kommt in der DB Syserr dieser Error und ch1 stürzt ab. Wenn ich einloggen will stürzt dann auch DB und Auth ab.

Spoiler anzeigen

Code

SYSERR: Dec 23 15:27:42 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xB5\xE9\xB0\xB3' 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: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xB4\xC1\xB4\xEB' 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
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xB5\xCE\xB8\xF1\xB4\xC1...' 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 (103, "µ
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC7\xAA\xB8\xA5\xB4\xC1...' 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 (104, "Ç
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC7\xAA\xB8\xA5 \xB5...' 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 (105, "Çª¸¥
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC8\xB8\xBB\xF6\xB4\xC1...' 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 (106, "È
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC8\xB8\xBB\xF6 \xB5...' 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 (107, "È¸»ö
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xB8\xE4\xB5\xC5\xC1\xF6' 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 (108, "¸äµÅ
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xBA\xD3\xC0\xBA \xB8...' 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 (109, "ºÓÀº
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xB0\xF5' 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 (110, "°õ", "Bear", 0, 0, 4
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC8\xB8\xBB\xF6\xB0\xF5' 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 (111, "È¸»ö
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xB0\xCB\xC0\xBA\xB0\xF5' 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 (112, "°ËÀº
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xBA\xD2\xB0\xF5' 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 (113, "ºÒ°õ", "Brow
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC8\xA3\xB6\xFB\xC0\xCC' 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 (114, "È£¶û
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xB4\xEB\xC8\xA3' 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 (115, "´ëÈ£", "Whit
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (131, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (132, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (133, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (134, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (135, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (136, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (137, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (138, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (139, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (140, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (141, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (142, "À
SYSERR: Dec 23 15:27:42 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\xC0\xFA\xC1\xD6\xB9\xDE...' 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 (143, "À

Alles anzeigen

Hatte das schonmal, weiß aber nicht mehr wie man es behebt.

Manecko · 18. Dezember 2021

Wie genau kann ich das nachschauen?

Also der cyptopp ordner ist da.

Sorry erstes mal Source, danke!

Manecko · 18. Dezember 2021

Servus

versuche den Server Source zu complien.

DB ist soweit gar kein Problem.

bei der game kommt am Ende ein Error:

Code

linking ../game_r44206_32....
/usr/local/bin/ld: cannot find -lcryptopp
collect2: error: ld returned 1 exit status
gmake[1]: *** [Makefile:126: ../game_r44206_32] Error 1
gmake[1]: Leaving directory '/usr/src/Server/game/src'
gmake: *** [Makefile:101: all] Error 2

cryptopp ist aber vorhanden?

Danke!

Manecko · 20. Juli 2021

Servus,

habe mir mal die Files von Ephelion gezogen.

Server läuft einwandfrei.

Nun ist meine Frage, wie das mit dem Client und Cython funktioniert, also zwecks Server-IP?

Danke schön!

Manecko · 20. Juli 2021

Servus, wenn ich den Server starte bekomme ich folgenden Error:

Code

directquery: asyncsql::directquery : mysql_query error: unknown column 'shop_item.price_vnum' in 'field list'

Woran liegts und was muss ich tun?

Thanks :>

Manecko · 20. Juli 2021

Servus,

Da ich das erste Mal mit ML arbeite, interessiert es mich, wie das funktioniert, das wenn ich eine Quest möchte, diese natürlich in allen Sprachen verfügbar ist.

Gibt es ein Tut oder kann jemand mal kurzerhand erklären, wie das so funktioniert?

Also als Beispiel Skills holen. Wenn man mit Level 5 die Skills holt, dass die Quest auch in allen vorhandene Sprachen verfügbar ist?

Danke euch. :>

Manecko · 9. Mai 2020

Zitat von Volvox

Code

Cannot open table common/priv_settings from the internal data dictionary of InnoDB though the .frm file for the table exists.

mysql_query error: Table 'common.priv_settings' doesn't exist

Der Fehler ist seeehr eindeutig.
Bitte melden Sie sich an, um diesen Link zu sehen.

Zur Not die priv_settings files löschen und die Table neu erstellen.

Die Tabelle funktioniert wieder.

Aber was obere?

Manecko · 8. Mai 2020

Servus.

jemand ne Lösung für? :>

Hostname.err

Code

200508 17:47:06 mysqld_safe mysqld from pid file /var/db/mysql/Projekt.pid ended
200508 17:48:17 mysqld_safe Logging to '/var/db/mysql/Projekt.err'.
200508 17:48:18 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2020-05-08 17:48:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-05-08 17:48:21 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.36) starting as process 724 ...
2020-05-08 17:48:22 724 [Note] Plugin 'FEDERATED' is disabled.
2020-05-08 17:48:22 724 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-05-08 17:48:22 724 [Note] InnoDB: The InnoDB memory heap is disabled
2020-05-08 17:48:22 724 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-08 17:48:22 724 [Note] InnoDB: Memory barrier is not used
2020-05-08 17:48:22 724 [Note] InnoDB: Compressed tables use zlib 1.2.8
2020-05-08 17:48:23 724 [Note] InnoDB: Not using CPU crc32 instructions
2020-05-08 17:48:23 724 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-05-08 17:48:23 724 [Note] InnoDB: Completed initialization of buffer pool
2020-05-08 17:48:24 724 [Note] InnoDB: Highest supported file format is Barracuda.
2020-05-08 17:48:25 724 [Note] InnoDB: 128 rollback segment(s) are active.
2020-05-08 17:48:25 724 [Note] InnoDB: Waiting for purge to start
2020-05-08 17:48:25 724 [Note] InnoDB: 5.6.36 started; log sequence number 1646681
2020-05-08 17:48:25 724 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2020-05-08 17:48:25 724 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2020-05-08 17:48:25 724 [Note] Server hostname (bind-address): '*'; port: 3306
2020-05-08 17:48:25 724 [Note] IPv6 is available.
2020-05-08 17:48:25 724 [Note] - '::' resolves to '::';
2020-05-08 17:48:25 724 [Note] Server socket created on IP: '::'.
2020-05-08 17:48:26 724 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
2020-05-08 17:48:26 724 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
2020-05-08 17:48:26 724 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
2020-05-08 17:48:26 724 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50560, now running 50636. Please use mysql_upgrade to fix this error.
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2020-05-08 17:48:26 724 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2020-05-08 17:48:26 724 [Note] Event Scheduler: Loaded 0 events
2020-05-08 17:48:26 724 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.36' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2020-05-08 17:55:00 724 [Warning] InnoDB: Cannot open table common/priv_settings from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2020-05-08 17:55:00 724 [Warning] InnoDB: Cannot open table common/priv_settings from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

Alles anzeigen

DB Syserr

Code

SYSERR: May 8 17:55:00 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist
query: DELETE FROM priv_settings WHERE value <= 0 OR duration <= NOW();
SYSERR: May 8 17:55:00 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist
query: SELECT priv_type, id, type, value, UNIX_TIMESTAMP(duration) FROM priv_settings

Danke!

Manecko · 7. Mai 2020

Zitat von Volvox

Zitat von Manecko

Hab jetzt mal mit ner neuen VDI gemacht.

Jetzt hab ich das ind der DB Syserr:

Code

SYSERR: May 7 13:04:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist

query: DELETE FROM priv_settings WHERE value <= 0 OR duration <= NOW();

SYSERR: May 7 13:04:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist

query: SELECT priv_type, id, type, value, UNIX_TIMESTAMP(duration) FROM priv_settings

Hab versucht die Tablle mit folgendem zu erstellen:

Code

CREATE TABLE `priv_settings` (

`priv_type` enum('PLAYER','GUILD','EMPIRE') NOT NULL DEFAULT 'EMPIRE' COMMENT 'GUILD and PLAYER are untested.' ,

`id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'this is for empire_id, player_id or guild_id' ,

`type` int UNSIGNED NOT NULL DEFAULT 4 COMMENT '1:item_drop, 2:gold_drop, 3:gold10_drop, 4:exp (1~4)' ,

`value` int NOT NULL DEFAULT 0 COMMENT '0~1000%' ,

`duration` datetime NOT NULL DEFAULT 0 ,

PRIMARY KEY (`priv_type`, `id`, `type`)

);

Aber irgendwie crasht die Tabelle immer.

Alles anzeigen
hat er die Table denn angelegt ?

Alles anzeigen

Er schrieb Table doesnt exist. In WinSCP war sie da, aber als .ibd.

Habe sie selber erstellt und rebootet.

Jetzt hab ich in Hostname.err folgendes:

Code

2020-05-07 13:19:53 82b521f00 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2020-05-07 13:19:53 82b521f00 InnoDB: Error: Fetch of persistent statistics requested for table "common"."priv_settings" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

EDIT: Sehe sie ist als .frm und .ibd da. Kann sie aber nun in Navicat öffnen.

Manecko · 7. Mai 2020

Hab jetzt mal mit ner neuen VDI gemacht.

Jetzt hab ich das ind der DB Syserr:

Code

SYSERR: May 7 13:04:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist
query: DELETE FROM priv_settings WHERE value <= 0 OR duration <= NOW();
SYSERR: May 7 13:04:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist
query: SELECT priv_type, id, type, value, UNIX_TIMESTAMP(duration) FROM priv_settings

Hab versucht die Tablle mit folgendem zu erstellen:

Code

CREATE TABLE `priv_settings` (
`priv_type` enum('PLAYER','GUILD','EMPIRE') NOT NULL DEFAULT 'EMPIRE' COMMENT 'GUILD and PLAYER are untested.' ,
`id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'this is for empire_id, player_id or guild_id' ,
`type` int UNSIGNED NOT NULL DEFAULT 4 COMMENT '1:item_drop, 2:gold_drop, 3:gold10_drop, 4:exp (1~4)' ,
`value` int NOT NULL DEFAULT 0 COMMENT '0~1000%' ,
`duration` datetime NOT NULL DEFAULT 0 ,
PRIMARY KEY (`priv_type`, `id`, `type`)
);

Aber irgendwie crasht die Tabelle immer.

Manecko · 6. Mai 2020

Zitat von xAmnezia

Das ist ein Zeichen dafür, die Finger von den Kori-Files zu lassen.

Hab nur kori vdi genommen, aber andere Files.

Evtl vdi wechseln?

Manecko · 6. Mai 2020

Zitat von Volvox

core down ? schau mal obs ne *.core file gibt

Eine Core File finde ich nicht.

Manecko · 6. Mai 2020

Hab noch nichts gemacht, nur aufgesetzt.

Ist ein lokaler Server.

Also login Ingame geht in der Zeit auch nicht.

Die core file such ich heut mittag wenn ich zu Hause bin!

EDIT: Hab das in der Hostname.err gefunden:

Code

200505 17:27:57 mysqld_safe mysqld from pid file /var/db/mysql/koridev.64.pid ended
200505 17:28:41 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2020-05-05 17:28:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-05-05 17:28:41 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.27) starting as process 621 ...
2020-05-05 17:28:41 621 [Note] Plugin 'FEDERATED' is disabled.
2020-05-05 17:28:41 621 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-05-05 17:28:41 621 [Note] InnoDB: The InnoDB memory heap is disabled
2020-05-05 17:28:41 621 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-05 17:28:41 621 [Note] InnoDB: Memory barrier is not used
2020-05-05 17:28:41 621 [Note] InnoDB: Compressed tables use zlib 1.2.3
2020-05-05 17:28:41 621 [Note] InnoDB: Not using CPU crc32 instructions
2020-05-05 17:28:41 621 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-05-05 17:28:42 621 [Note] InnoDB: Completed initialization of buffer pool
2020-05-05 17:28:42 621 [Note] InnoDB: Highest supported file format is Barracuda.
2020-05-05 17:28:42 621 [Note] InnoDB: 128 rollback segment(s) are active.
2020-05-05 17:28:42 621 [Note] InnoDB: Waiting for purge to start
2020-05-05 17:28:42 621 [Note] InnoDB: 5.6.27 started; log sequence number 1605069
2020-05-05 17:28:42 621 [Note] Server hostname (bind-address): '*'; port: 3306
2020-05-05 17:28:42 621 [Note] IPv6 is available.
2020-05-05 17:28:42 621 [Note] - '::' resolves to '::';
2020-05-05 17:28:42 621 [Note] Server socket created on IP: '::'.
2020-05-05 17:28:42 621 [Note] Event Scheduler: Loaded 0 events
2020-05-05 17:28:42 621 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.27' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2020-05-05 17:29:33 8291fe400 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2020-05-05 17:29:33 8291fe400 InnoDB: Error: Fetch of persistent statistics requested for table "common"."priv_settings" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
200506 15:59:29 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2020-05-06 15:59:31 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-05-06 15:59:31 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.27) starting as process 652 ...
2020-05-06 15:59:31 652 [Note] Plugin 'FEDERATED' is disabled.
2020-05-06 15:59:31 652 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-05-06 15:59:31 652 [Note] InnoDB: The InnoDB memory heap is disabled
2020-05-06 15:59:31 652 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-06 15:59:31 652 [Note] InnoDB: Memory barrier is not used
2020-05-06 15:59:31 652 [Note] InnoDB: Compressed tables use zlib 1.2.3
2020-05-06 15:59:31 652 [Note] InnoDB: Not using CPU crc32 instructions
2020-05-06 15:59:31 652 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-05-06 15:59:31 652 [Note] InnoDB: Completed initialization of buffer pool
2020-05-06 15:59:31 652 [Note] InnoDB: Highest supported file format is Barracuda.
2020-05-06 15:59:31 652 [Note] InnoDB: The log sequence numbers 1605069 and 1605069 in ibdata files do not match the log sequence number 1605079 in the ib_logfiles!
2020-05-06 15:59:31 652 [Note] InnoDB: Database was not shutdown normally!
2020-05-06 15:59:31 652 [Note] InnoDB: Starting crash recovery.
2020-05-06 15:59:31 652 [Note] InnoDB: Reading tablespace information from the .ibd files...
2020-05-06 15:59:31 652 [Note] InnoDB: Restoring possible half-written data pages
2020-05-06 15:59:31 652 [Note] InnoDB: from the doublewrite buffer...
2020-05-06 15:59:32 652 [Note] InnoDB: 128 rollback segment(s) are active.
2020-05-06 15:59:32 652 [Note] InnoDB: Waiting for purge to start
2020-05-06 15:59:32 652 [Note] InnoDB: 5.6.27 started; log sequence number 1605079
2020-05-06 15:59:32 652 [Note] Server hostname (bind-address): '*'; port: 3306
2020-05-06 15:59:32 652 [Note] IPv6 is available.
2020-05-06 15:59:32 652 [Note] - '::' resolves to '::';
2020-05-06 15:59:32 652 [Note] Server socket created on IP: '::'.
2020-05-06 15:59:32 652 [Note] Event Scheduler: Loaded 0 events
2020-05-06 15:59:32 652 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.27' socket: '/tmp/mysql.sock' port: 3306 Source distribution

Alles anzeigen

Manecko · 5. Mai 2020

Servus,

Habe beim Server das Problem, dass er nach 40-50 Sekunden offline geht.

Starte ich ihn und warte, gehen dann Auth, Ch1 und Ch99 off. Die DB läuft weiter.

Habe in keiner Syserr was drin stehen. Bleiben leer.

Wisst ihr woran das liegen könnte?

Danke

Manecko · 27. Juni 2019

Die Reiche kämpfen "unerbitterkich".

Beiträge von Manecko

DB Syserr

DB Syserr

DB Syserr

DB Syserr

DB Syserr

DB Syserr

Server Source Problem

Server Source Problem

Ephelion2 Client

unknown column 'shop_item.price_vnum' in 'field list'

Quests bei Multilangiage

Server startet nicht

Server startet nicht

Nach 40-50 Sekunden Absturz

Nach 40-50 Sekunden Absturz

Nach 40-50 Sekunden Absturz

Nach 40-50 Sekunden Absturz

Nach 40-50 Sekunden Absturz

Nach 40-50 Sekunden Absturz

Yumara2 - Ascension of the new era