src pomocy

[kondzio299]

Mam problem bo odpala mi game i db niby wszystko okej ale blad polaczeniem z serwerem, i teraz mam pytanie jak to naprawic 

syser db:

http://wklej.to/TWcmW(i tak dalej z tymi ChildLoop: AsyncSQL: ....)

syser game:

http://wklej.to/zWEjs

syser auth:

http://wklej.to/SSwaf

 

[Activ omom]

­Wrzuć dragon_soul_table.txt

ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist

[kondzio299]

dodałe dragon_soul_table.txt tam gdzie trzeba dalem chmody i teraz w game dostaje taki syser:

 

SYSERR: Nov 21 12:10:30 :: pid_init: 

Start of pid: 1428

 

SYSERR: Nov 21 12:10:50 :: CheckDragonSoulExtTables: In ąé·ćĽ® group of DragonSoulExtTables, ByProduct(30270) of Grade grade_normal is not exist.

SYSERR: Nov 21 12:10:50 :: ReadDragonSoulTableFile: DragonSoul table Check failed.

SYSERR: Nov 21 12:10:50 :: Boot: cannot load DragonSoulTable: locale/poland/dragon_soul_table.txt

[kondzio299]

reff

[NoName#2]

@kondzio299

A ten plik dragon_soul_table.txt skąd wziąłeś? W moim temacie masz poprawny.

[kondzio299]

ten plik wzialem z tematu kod źródłowy gry metin2 czyli z twojego i mi takie bledy wywala

[NoName#2]

@kondzio299

Pojebałem, nie masz przedmiotu o ID 30270 w bazie i dlatego

 

 

Ps. Tu masz wpisy do bazy w txt

item_name.txt

 

30270 Odłamek Smocz. Kamienia

oraz item_proto.txt

 

30270 ??? ??? ITEM_QUEST 0 1 NONE ITEM_STACKABLE NONE NONE 0 0 0 0 0 REAL_TIME 86400 LIMIT_NONE 0 APPLY_NONE 0 APPLY_NONE 0 APPLY_NONE 0 0 0 0 0 0 0 0 0 0

[kondzio299]

okej teraz syserr auth:

SYSERR: Nov 22 13:29:25 :: pid_init: 

Start of pid: 1490

 

SYSERR: Nov 22 13:29:25 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)

 

i db: 

SYSERR: Nov 22 13:29:22 :: pid_init: 

Start of pid: 1488

 

SYSERR: Nov 22 13:29:22 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Nov 22 13:29:22 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' 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 Dog", 0, 0, 1, 1, 0, 0, 1, 0,

 

(tego jest z 900 linijek) 

[kondzio299]

reff iii

 

db zostaje bez zmian a auth i game maja taki sam syserr:

 

Start of pid: 1404

 

SYSERR: Nov 23 00:26:55 :: socket_connect: HOST localhost:15000, could not connect. (probowalem zmienic port bazy danych na inny i nic)

[kondzio299]

reff

[Noresta]

W bazie account stwórz tabele string. Nie czyta Ci mob_proto.txt wgraj czyste i zobacz czy Ci pójdzie.

[kondzio299]

do zamkniecia