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

[HELP] Mysql query error!


MANYAK

Question

Error writing server-side

Ch1 sysser:

account.messenger_list, account.safebox,account.quild

 

SYSERR: Apr 25 14:43:18 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.guild' doesn't exist
query: SELECT COUNT(*) FROM guild WHERE name = 'sadfsdfsdf'
SYSERR: Apr 25 14:43:41 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.guild' doesn't exist
query: SELECT COUNT(*) FROM guild WHERE name = 'TestGuild'
SYSERR: Apr 25 14:44:48 :: ChildLoop: AsyncSQL: query failed: Table 'account.safebox' doesn't exist (query: SELECT size FROM safebox WHERE account_id = 2 errno: 1146)
SYSERR: Apr 25 14:44:54 :: ChildLoop: AsyncSQL: query failed: Table 'account.messenger_list' doesn't exist (query: SELECT account, companion FROM messenger_list WHERE account='Shaman' errno: 1146)
SYSERR: Apr 25 14:45:46 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.guild' doesn't exist
query: SELECT COUNT(*) FROM guild WHERE name = 'TR'
SYSERR: Apr 25 14:46:48 :: ChildLoop: AsyncSQL: query failed: Table 'account.safebox' doesn't exist (query: SELECT size FROM safebox WHERE account_id = 2 errno: 1146)
SYSERR: Apr 25 14:46:53 :: ChildLoop: AsyncSQL: query failed: Table 'account.messenger_list' doesn't exist (query: SELECT account, companion FROM messenger_list WHERE account='Suraa' errno: 1146)
SYSERR: Apr 25 14:47:48 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.guild' doesn't exist
query: SELECT COUNT(*) FROM guild WHERE name = 'TRR'
SYSERR: Apr 25 14:48:49 :: ChildLoop: AsyncSQL: query failed: Table 'account.safebox' doesn't exist (query: SELECT size FROM safebox WHERE account_id = 2 errno: 1146)
SYSERR: Apr 25 14:48:51 :: ChildLoop: AsyncSQL: query failed: Table 'account.messenger_list' doesn't exist (query: SELECT account, companion FROM messenger_list WHERE account='Sorry' errno: 1146)
SYSERR: Apr 25 14:49:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.guild' doesn't exist
query: SELECT COUNT(*) FROM guild WHERE name = 'xxxx'

 

preventing the build guild ...

 

emergency solution  :(

Link to comment
Share on other sites

14 answers to this question

Recommended Posts

  • 0

 

 

PLAYER_SQL: localhost metin2 1234 account

your problem is here + check the account db config on the config file of the DB

 

I do not understand. Skype to add?

Link to comment
Share on other sites

  • 0

just change :

PLAYER_SQL: localhost metin2 1234 account

to

PLAYER_SQL: localhost metin2 1234 player

normaly you must check if the db name is correct

 

 

OK I'm testing

Link to comment
Share on other sites

  • 0

just change :

PLAYER_SQL: localhost metin2 1234 account

to

PLAYER_SQL: localhost metin2 1234 player

normaly you must check if the db name is correct

 

 

input. Account name or password is incorrect

Link to comment
Share on other sites

  • 0

login to mysql via ssh then add a user with the name:  metin2 and the pass :1234 check this for more info &do=embed' frameborder='0' data-embedContent>

 

OMG :o 

 

&do=embed' frameborder='0' data-embedContent>

 

Is it necessary? I am using the resources that already 6.4 GB (FreeBSD9.2_with_source.zip)

Link to comment
Share on other sites

  • 0
  • Moon

 

login to mysql via ssh then add a user with the name:  metin2 and the pass :1234 check this for more info &do=embed' frameborder='0' data-embedContent>

 

OMG :o

 

&do=embed' frameborder='0' data-embedContent>

 

Is it necessary? I am using the resources that already 6.4 GB (FreeBSD9.2_with_source.zip)

 

i dont mean all of it only how to make a user for mysql + by

input. Account name or password is incorrect

do you mean that in game or on the ssh?

Link to comment
Share on other sites

  • 0

 

 

login to mysql via ssh then add a user with the name:  metin2 and the pass :1234 check this for more info &do=embed' frameborder='0' data-embedContent>

 

OMG :o

 

&do=embed' frameborder='0' data-embedContent>

 

Is it necessary? I am using the resources that already 6.4 GB (FreeBSD9.2_with_source.zip)

 

i dont mean all of it only how to make a user for mysql + by

input. Account name or password is incorrect

do you mean that in game or on the ssh?

 

 

hey man. Support via Skype please

Link to comment
Share on other sites

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.