Jump to content
×
×
  • Create New...
  • 0

Bug metin2


xGoogle

Question

9 answers to this question

Recommended Posts

  • 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

 

Link to comment
  • 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

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.