[Problem]start on local 2010er SF's

[agadan]

Hi community,
By starting on local (with loopback) I cannot login into my server.
I use Official Metin2 patched client (Gameforge), I changed the Pong too (1234abcd5678efgh.1234abcd5678efgh) into auth and game files on FTP, and on the executable file too.
By the way, the problem is that when I try to login on the server it stays on: "You are being connected to server" and then it doesn't go on.
I use Portmap too with localhost address and the ports that I use for the Auth (13373) and for game and game99 (13000 and 13001).
Someone could help me by solving this, please?

[IgorGlock]

You are being connected to server

Du bist bereits mit den Server verbunden

Ah... something is wrong... upload your syslog from your auth and game (first)

[agadan]

Thanks for the help .
In the Auth folder there were no syslog.
In the game folder there's this:

SYSERR: Jan  8 01:04:33 :: ChildLoop: AsyncSQL: query failed: Table 'common.spam_db' doesn't exist (query: SELECT word, score FROM spam_db WHERE type='SPAM' errno: 1146)
SYSERR: Jan  8 01:05:23 :: Boot: cannot load MOBDropItemFile: locale/germany/mob_drop_item.txt

[AllesBelegt]

eine frage wie hat er den de 2010er clienten benutzt?=

kann mir einer genau erklären wie es geht und welche files man nehmen muss

[IgorGlock]

Your server doesn't work because your locale doesn't exist (germany).
You must rename your "hongkong" locale to "germany" :>
locale/germany/mob_drop_item.txt

[agadan]

I already use locale/germany cause I use NW3 SF's.
I solved the mob_drop_item.txt problem, but now i have another error :S

SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(201) MAP(43)
SYSERR: Jan  8 02:13:30 :: SpawnMob: SpawnMob: no mob data for vnum 20362
SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(203) MAP(43)
SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(102) MAP(1)
SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(203) MAP(43)
SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(206) MAP(43)
SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(204) MAP(43)
SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(203) MAP(43)
SYSERR: Jan  8 02:13:30 :: SpawnGroup: NOT_EXIST_GROUP_VNUM(2312) Map(11) 
SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(206) MAP(43)
SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(204) MAP(43)
SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(204) MAP(43)
SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(204) MAP(43)
SYSERR: Jan  8 02:13:30 :: SpawnGroupGroup: NOT_EXIST_GROUP_GROUP_VNUM(204) MAP(43)

[IgorGlock]

But now you can login and play / move / ???
Tip: Use your old locale folder and rename some files / folders... than it works.

Read syslog & repair your files by yourself. Don't ask anything :<

[agadan]

I posted the new error cause I already replaced the files (such as group and group_group) but it gives to me the same error :S.
Maybe I need the english DB but i don't know where i could find it, or best 2010 SF's.
EDIT: it gives me this error too:

SYSERR: Jan  8 02:10:15 :: ChildLoop: AsyncSQL: query failed: Table 'common.spam_db' doesn't exist (query: SELECT word, score FROM spam_db WHERE type='SPAM' errno: 1146)

This probably means that I need a new db, someone could give me a link for best 2010 SF's and new db?
I'm sorry, but I don't know how to solve the last error, maybe new files are the only solution
Ps: @IgorGlock: no, I can't login

EDIT: I Solved by downloading the english unbugged clean database, now I can play on my local server.