Syserr

[MUSCLE21]

Kód Kijelölés Kibont

Sziasztok! Ez mért lehet? :O
syserr:
[codeSYSERR: Mar  9 23:37:11.321128 :: pid_init:
Start of pid: 881

SYSERR: Mar  9 23:37:42.891261 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Mar  9 23:37:42.891384 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Mar  9 23:37:43.658227 :: heart_idle: losing 30 seconds. (lag occured)
SYSERR: Mar  9 23:40:23.305891 :: heart_idle: losing 159 seconds. (lag occured)
SYSERR: Mar  9 23:40:32.202533 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68650, 959455, 268828, 0, 'LOGIN', '84.2.156.213 1989710563 1 41 80000', '84.2.156.213') errno: 1406)
SYSERR: Mar  9 23:40:32.206057 :: ChildLoop: AsyncSQL: query failed: Incorrect integer value: 'Y' for column 'is_gm' at row 1 (query: INSERT INTO loginlog2(type, is_gm, login_time, channel, account_id, pid, ip, client_version) VALUES('INVALID', 'Y', NOW(), 1, 1, 68650, inet_aton('84.2.156.213'), '') errno: 1366)
SYSERR: Mar  9 23:40:32.252098 :: PointChange: CHARACTER::PointChange: [SA]Admin: unknown point change type 119
SYSERR: Mar  9 23:40:41.276719 :: PointChange: CHARACTER::PointChange: [SA]Admin: unknown point change type 119
SYSERR: Mar  9 23:41:55.731790 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68650, 958620, 273966, 0, 'WARP', '[SA]Admin MapIdx 41 DestMapIdx0 DestX0 DestY1203200 Empire3', '84.2.156.213') errno: 1406)
SYSERR: Mar  9 23:41:55.890929 :: PointChange: CHARACTER::PointChange: [SA]Admin: unknown point change type 119
SYSERR: Mar  9 23:41:55.891075 :: PointChange: CHARACTER::PointChange: [SA]Admin: unknown point change type 119
SYSERR: Mar  9 23:41:55.891244 :: PointChange: CHARACTER::PointChange: [SA]Admin: unknown point change type 119
SYSERR: Mar  9 23:41:55.894653 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 68650, 958620, 273966, 0, 'LOGOUT', '84.2.156.213 1989710563 1 41 80000', '84.2.156.213') errno: 1406)



[hunti]

A hint mező méretét kellene megnövelni, azzal az adatbázis kezelő szoftverrel amit használsz (navicat, phpmyadmin, stb). Most én megnéztem egy helyen, ott elvileg varchar(20), tehát varchar típusú és 20 karaktert(betűt) tud tárolni. Ha megnöveled az értékét, akkor jó lesz. Maximum érték varchar esetén 255. Ha jelenleg 20-nál kisebb, akkor szerintem írd át először 20-ra, ha így se jó, akkor növeld 50-re, és így tovább amíg jó nem lesz.

[MUSCLE21]

És azt mégis hol birom növelni? :O 

[mikee0121]

Navicat azon belül log tábla jobb egér gomb design table és ott megkeresed és a 20-at átírod 100-ra ennyi az egész.

De hát google a barátom megmondta volna

[MUSCLE21]

Köszönöm Szépen!
Üzenet összefésülés: 2017-03-10, 00:02:07
Syser:

Kód Kijelölés Kibont

SYSERR: Mar  9 23:50:30.185918 :: pid_init:
Start of pid: 875

SYSERR: Mar  9 23:51:58.675041 :: Show: cannot find sectree by 984013x273270 mapindex 41
SYSERR: Mar  9 23:52:00.397085 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 0 mob 3596 skill 257
SYSERR: Mar  9 23:52:00.397222 :: LoadSkillMotion: Motion: Skill exist but no motion data for index 1 mob 3596 skill 258
SYSERR: Mar  9 23:52:01.178158 :: heart_idle: losing 90 seconds. (lag occured)


DB SYSERR:

Kód Kijelölés Kibont

SYSERR: Mar  9 23:49:50.179053 :: pid_init:
Start of pid: 860

SYSERR: Mar  9 23:49:50.179131 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Mar  9 23:49:50.769058 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x9A?' 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 (2071, "?ç???î ??????°?
SYSERR: Mar  9 23:49:50.769643 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x9A?' 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 (2072, "?ç???î ¸Í??°?š?
SYSERR: Mar  9 23:49:50.770217 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x9A?' 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 (2073, "?ç???î ?Ó??¸Í??
SYSERR: Mar  9 23:49:50.770745 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x9A?' 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 (2074, "?ç???î Áý°Ô??°?
SYSERR: Mar  9 23:49:50.771288 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x9A?' 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 (2075, "?ç???î ?´Á¤??°?
SYSERR: Mar  9 23:49:50.771808 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x9A?' 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 (2076, "?ç???î Á??´Á¤??
SYSERR: Mar  9 23:49:50.772366 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x8A??\xB0?\x9A...' 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 (2091, "?Š
SYSERR: Mar  9 23:49:50.772908 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x9A?' 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 (2092, "´ë??°?š?", "Pók
SYSERR: Mar  9 23:49:50.773480 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x8A??\xB0?\x9A...' 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 (2093, "Á?
SYSERR: Mar  9 23:49:50.774118 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x8A??\xB0?\x9A...' 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 (2094, "Á?
SYSERR: Mar  9 23:49:50.774593 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x9A??\xC7 \x9E...' 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 (2095, "°?
SYSERR: Mar  9 23:49:50.822860 :: ChildLoop: AsyncSQL: query failed: Incorrect string value: '\x9A\xFD?\xE7' 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,

Üzenet összefésülés: 2017-03-10, 00:06:02
Ugyan ugy  Rossz! Ugyan ugy irja a fenti hibát is.. Pedig át irtam a log táblában a hintet.

[hunti]

Én most nem látom benne a log-os hibát, csak új hibákat. Jelenleg nem tudom megnézni hogy ennek hogyan kellene beállítva lenni, el tudnád küldeni hogy mob_proto tábla szerkezete hogy néz ki? (navicat, design table ahogy mikee0121 írta)

[mikee0121]

de értetlen vagy megint ne haragudj ezért írtam is hogy ez miért van és mit csinálj megnyitod a mob protot és átírod azoknak a sorokba a neveket amire panaszkodik.

de akkor írok egy példát:

így néz ki egy sor amire panaszkodik:

Kód Kijelölés Kibont


2071 ?ç???î ?´Á¤??°? KING NPC MELEE 1 NOMOVE 0 STUN,SLOW,CURSE,TERROR 0 2 0 0 0 0 0 0 120 3 1 0 0 100 4 100 100 0 2000 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0





ás fogod megcsinálod ilyenre:

Kód Kijelölés Kibont

2071 ?? ??? KING NPC MELEE 1 NOMOVE 0 STUN,SLOW,CURSE,TERROR 0 2 0 0 0 0 0 0 120 3 1 0 0 100 4 100 100 0 2000 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0


[MUSCLE21]

Köszönöm.
Üzenet összefésülés: 2017-03-10, 15:55:04
Ugyan ugy irja és át állitotam az összeset ??
Üzenet összefésülés: 2017-03-10, 16:44:04
Naviba hiába irom át... vissza irja a rosszra...

[OneCharakter]

Szia !Ha 40k-t használsz akkor a txt-ből olvassa ki a mob_protot és nem naviból.

[MUSCLE21]

Szia! Ha txt ben bármit modositok akkor nem Müködik a szerver! Connection refusedet ir Másodpercenként.

[mikee0121]

HAgyd 2 órája már leírtam neki hogy hol kell de nem akarja elhinni hogy ott kell nem naviba mivel txt-s protokat használ

[MUSCLE21]

oké miki...  db,ben és ott a mob proto.txt ben ha át irom a neveket ?? re akkor mondom hogy szar lesz az egész...

[mikee0121]

én meg még miondig azt mondom hogy elrontasz valamit túlsokat törölsz ki vagy nem tudom mit de másold be ide a hibáés sorokat kijavítom neked lásd rendes vagyok azért én is.

[MUSCLE21]

igy jó miki? :O

[mikee0121]

Az ember a kisúját nyújtja és neked kell az egész karom. Ember ne legyél már annyira lusta hogy kikeresd syser alapján a rossz sorokat.

[MUSCLE21]

Az a baj nem engedi ide be irni mert Túl haladom az üzenetet