MasterSticQ

You were right, thank for fixing this, but there's another problem. The DB starts only if i delete table "iptocountry". If i put it back in MySQL, then db won't launch.. Any ideas how to fix this? :-/ I tried to repair the table or put some lines in it and without any result. DB file always gets aborted..

check start.sh

I am not a real dumb and this message really won't help me  

Thanks for some help.. Here's the the output:

#0  0x2839591b in thr_kill () from /usr/lib32/libc.so.7
No symbol table info available.
#1  0x28321b4b in raise () from /usr/lib32/libthr.so.3
No symbol table info available.
#2  0x2846f626 in abort () from /usr/lib32/libc.so.7
No symbol table info available.
#3  0x0804ea74 in emergency_sig (sig=<value optimized out>) at Main.cpp:61
No locals.
#4  0x28322507 in swapcontext () from /usr/lib32/libthr.so.3
No symbol table info available.
#5  0x28321f88 in sigaction () from /usr/lib32/libthr.so.3
No symbol table info available.
#6  0xffffe194 in ?? ()
No symbol table info available.
#7  0x0000000b in ?? ()
No symbol table info available.
#8  0x283b5830 in strdup () from /usr/lib32/libc.so.7
No symbol table info available.
#9  0x0809ab7c in CBlockCountry::Load (this=0xffffdb7c) at BlockCountry.cpp:92
        login = 0x0
        szQuery = "SELECT login FROM block_exception000E FROM iptocountry000▒▒▒metin2000▒201▒034(000]3(000]3(▒204 b▒0G(▒▒035(▒▒▒▒▒f034(t▒035(h▒▒▒▒▒▒▒001000000000000000000000h▒▒▒hotbackup000000000▒035(001000000000'f034(▒▒035(<▒▒▒▒▒▒▒▒035(h▒▒▒177022000000200▒▒(PP▒(000000000000000000000000localhost000035(200P▒("...
        pMsg = (SQLMsg *) 0x2b26e850

Hi..

Firstly i would thank you for opening this thread. I have problem with starting database in server files. Connect to MySQL is working. My problem is that when i use ./db then output is:

root@Tora:/usr/metin2/game/db # ./db
Test Server
Log OffAsyncSQL: connected to localhost (reconnect 1)
Success PLAYER
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success ACCOUNT
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success COMMON
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
Success HOTBACKUP
AsyncSQL: connected to localhost (reconnect 1)
AsyncSQL: connected to localhost (reconnect 1)
▒׽▒Ʈ ▒▒▒▒▒▒ ▒▒▒ϴ▒. ▒״▒▒ ▒▒▒▒▒մϴ▒.
▒׽▒Ʈ ▒▒▒▒▒▒ ▒▒▒ϴ▒. ▒״▒▒ ▒▒▒▒▒մϴ▒.
item_proto_test.txt ▒▒▒▒▒ ▒о▒▒▒▒ ▒▒▒߽▒ϴ▒
item_proto_test.txt ▒▒▒▒▒ ▒о▒▒▒▒ ▒▒▒߽▒ϴ▒
Abort (core dumped)

If i use "sh run.sh" then db tries to start over and over again and does the same thing. 

Syserr ->

SYSERR: Apr  7 19:04:30 :: pid_init: 
Start of pid: 29916

SYSERR: Apr  7 19:04:30 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr  7 19:04:30 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'setImmuneFlag' 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, "´ë¿Õ°Å¹Ì", "Spider King", 0, 5

Last lines of sysout(before loading of mobs and others):

Apr  7 19:04:31 :: SYSTEM: BINDING TCP PORT ON [15500] (fd 19)
Apr  7 19:04:31 :: ACCEPT_HANDLE: 19
Apr  7 19:04:31 :: PLAYER_DELETE_LEVEL_LIMIT set to 70
Apr  7 19:04:31 :: PLAYER_DELETE_LEVEL_LIMIT_LOWER set to 0
Apr  7 19:04:31 :: CHINA_EVENT_SERVER false
Apr  7 19:04:31 :: EventFlag Load oxevent_status 0
Apr  7 19:04:31 ::    OK
Apr  7 19:04:31 :: POWER_POLY: 
Apr  7 19:04:31 :: HANDICAP_POLY: 
Apr  7 19:04:31 :: MarriageList(size=0)
Apr  7 19:04:31 :: BLOCKED_IP : 127 - 127
Apr  7 19:04:31 :: SIGNAL: SIGSEGV

I would be really grateful if someone know how to help me with this. If someone want a better communication, then you can add me on skype: mastersticq

Can someone reupload it please? It seems pretty nice