Bug metin2

[xGoogle 0]

Hello, I have a problem in my server..

Why want you teleport or logout from the game, disappears guild and friends and when I make a new guild say that I already a guild.

When can I fix this problem?

[Fazer 686]

check if you sql folder is ready only

[xGoogle 0]

14 hours ago, Fazer said:

check if you sql folder is ready only

I don't understand.

[Fazer 686]

chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql

Run this

 

[xGoogle 0]

3 hours ago, Fazer said:

chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql

Run this

 

It did not work.. How can I chance with table guild, safebox and message_list to read it from db player ?

SYSERR: Dec  3 17:56:43 :: ChildLoop: AsyncSQL: query failed: Table 'account.safebox' doesn't exist (query: SELECT size FROM safebox  WHERE account_id = 3 errno: 1146)
SYSERR: Dec  3 17:58:29 :: ChildLoop: AsyncSQL: query failed: Table 'account.messenger_list' doesn't exist (query: SELECT account, companion FROM messenger_list  WHERE account='Test231' errno: 1146)
SYSERR: Dec  3 17:59:14 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.guild' doesn't exist

 

[Fazer 686]

do you have source?

 

[wezt 93]

@xGoogle you've made mistakes in config files, check them

[xGoogle 0]

11 hours ago, Fazer said:

do you have source?

 

Yes, I have source.

 

11 hours ago, wezt said:

@xGoogle you've made mistakes in config files, check them

I don't understand.

P.S

My setting for connection with database it's:

Auth:

HOSTNAME: auth
CHANNEL: 1
PORT: 11900
P2P_PORT: 12900
DB_PORT: 15900
DB_ADDR: 127.0.0.1
TABLE_POSTFIX:
ITEM_ID_RANGE: 000000001 000000002
PASSES_PER_SEC: 25
SAVE_EVENT_SECOND_CYCLE: 180
PING_EVENT_SECOND_CYCLE: 180
AUTH_SERVER: master
PLAYER_SQL: localhost user thor account
COMMON_SQL: localhost user thor common
LOG_SQL: localhost user thor log
LOCALE_SERVICE: germany

Channel1

TEST_SERVER: 0
HOSTNAME: ch1_core1
CHANNEL: 1
PORT: 13900
P2P_PORT: 14900
DB_PORT: 15900
DB_ADDR: localhost
MAP_ALLOW: 1 3 4 5 21 23 24 25 26 41 43 44 45 61 62 63 64 65 66 67 68 69 70 71 72 73 80 81 87 103 104 105 107 
TABLE_POSTFIX:  
PASSES_PER_SEC: 25
SAVE_EVENT_SECOND_CYCLE: 180
PING_EVENT_SECOND_CYCLE: 180
PLAYER_SQL: localhost user thor account
COMMON_SQL: localhost user thor common
LOG_SQL: localhost user thor log
LOCALE_SERVICE: germany

MALL_URL: www.name-web.com

VIEW_RANGE: 10000

RELAY_ADDR: 192.168.10.73
RELAY_PORT: 12121

ADMINPAGE_IP: 127.0.0.1
ADMINPAGE_PASSWORD: admintest
SPAM_BLOCK_MAX_LEVEL: 90

GOLD_DROP_LIMIT_TIME: 10

MAX_LEVEL: 225

 

Database:

WELCOME_MSG = "DB Server has been started"

SQL_ACCOUNT = "localhost account user thor 0"
SQL_PLAYER = "localhost player user thor  0"
SQL_COMMON = "localhost common user thor 0"
SQL_HOTBACKUP = "localhost hotbackup user thor 0"

TABLE_POSTFIX = ""

BIND_PORT               = 15900
DB_SLEEP_MSEC           = 10
CLIENT_HEART_FPS        = 10
HASH_PLAYER_LIFE_SEC    = 600
BACKUP_LIMIT_SEC        = 3600
PLAYER_ID_START = 100
PLAYER_DELETE_LEVEL_LIMIT = 80

ITEM_ID_RANGE = 2000000000 2100000000

DATABASE_TXT = 1

 

[wezt 93]

@xGoogle, in ch1 config change PLAYER_SQL to:

PLAYER_SQL: localhost user thor player

Regards

[xGoogle 0]

25 minutes ago, wezt said:

@xGoogle, in ch1 config change PLAYER_SQL to:

PLAYER_SQL: localhost user thor player

Regards

Thanks man.