Register for your free account! | Forgot your password?

You last visited: Today at 22:06

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

DB error

Discussion on DB error within the Metin2 Private Server forum part of the Metin2 category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2012
Posts: 20
Received Thanks: 4
DB error

syserr

Code:
SYSERR: Dec 16 11:04:23 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Dec 16 11:04:23 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Dec 16 11:04:23 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Dec 16 11:04:25 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Dec 16 11:04:27 :: Process: FDWATCH: peer null in event: ident 21
syslog

Code:
SYSERR: Dec 16 11:04:23 :: Start: TABLE_POSTFIX not configured use default
Dec 16 11:04:23 :: connecting to MySQL server (player)
Dec 16 11:04:23 :: CREATING DIRECT_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 ::     --mysql_set_character_set(euckr)
Dec 16 11:04:23 :: CREATING MAIN_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 :: CREATING ASYNC_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 ::    OK
Dec 16 11:04:23 :: connecting to MySQL server (account)
Dec 16 11:04:23 :: CREATING DIRECT_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 ::     --mysql_set_character_set(euckr)
Dec 16 11:04:23 ::     --mysql_set_character_set(euckr)
Dec 16 11:04:23 ::     --mysql_set_character_set(euckr)
Dec 16 11:04:23 :: CREATING MAIN_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 :: CREATING ASYNC_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 ::    OK
Dec 16 11:04:23 :: connecting to MySQL server (common)
Dec 16 11:04:23 :: CREATING DIRECT_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 ::     --mysql_set_character_set(euckr)
Dec 16 11:04:23 :: CREATING MAIN_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 :: CREATING ASYNC_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 ::    OK
Dec 16 11:04:23 :: connecting to MySQL server (hotbackup)
Dec 16 11:04:23 :: CREATING DIRECT_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 ::     --mysql_set_character_set(euckr)
Dec 16 11:04:23 ::     --mysql_set_character_set(euckr)
Dec 16 11:04:23 ::     --mysql_set_character_set(euckr)
Dec 16 11:04:23 :: CREATING MAIN_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 :: CREATING ASYNC_SQL
Dec 16 11:04:23 :: AsyncSQL: locale euckr
Dec 16 11:04:23 ::    OK
Dec 16 11:04:23 :: ClientManager initialization.. 
Dec 16 11:04:23 ::     --mysql_set_character_set(euckr)
Dec 16 11:04:23 ::     --mysql_set_character_set(euckr)
Dec 16 11:04:23 :: InitializeLocalization() - LoadLocaleTable(count:13)
Dec 16 11:04:23 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE0)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec 16 11:04:23 :: locale[LOCALE] = romania
Dec 16 11:04:23 :: Changed g_stLocale euckr to euckr
Dec 16 11:04:23 :: SetLocale start
Dec 16 11:04:23 :: End setlocale latin2
Dec 16 11:04:23 :: locale[DB_NAME_COLUMN] = locale_name
Dec 16 11:04:23 :: locale[UNKNOWN_KEY(SKILL_DAMAGE_BY_LEVEL_UNDER_90)] = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Dec 16 11:04:23 :: locale[UNKNOWN_KEY(SKILL_DAMAGE_BY_LEVEL_UNDER_45)] = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Dec 16 11:04:23 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL)] = 0 5 6 8 10 12 14 16 18 20 22 24
Dec 16 11:04:23 :: GetParam 2000000000
Dec 16 11:04:23 :: GetParam 2100000000
Dec 16 11:04:23 :: ItemRange From File 2000000000 ~ 2100000000 
Dec 16 11:04:23 ::     --mysql_set_character_set(latin2)
Dec 16 11:04:23 ::     --mysql_set_character_set(latin2)
Dec 16 11:04:23 :: ItemIDRange: Build: 2000000000 ~ 2100000000 start:2000000000
Dec 16 11:04:23 ::  Init Success Start 2000000000 End 2100000000 Now 2000000000


Dec 16 11:04:23 :: MOB #101   Wildhund                 level: 1   rank: 0 empire: 0
Dec 16 11:04:23 :: MOB #102   Wolf                     level: 3   rank: 0 empire: 0
Dec 16 11:04:23 :: MOB #103   Alpha-Wolf               level: 4   rank: 0 empire: 0
Dec 16 11:04:23 :: ITEM: #1     Yang                     VAL: 0 0 0 0 0 0 WEAR 0 ANTI 0 IMMUNE 0 REFINE 0 REFINE_SET 0 MAGIC_PCT 0
Dec 16 11:04:23 :: ITEM: #2     Versiune în limba Româna VAL: 0 0 0 0 0 0 WEAR 0 ANTI 0 IMMUNE 0 REFINE 0 REFINE_SET 0 MAGIC_PCT 0
Dec 16 11:04:23 :: ITEM: #10    Sabie+0                  VAL: 0 15 19 13 15 0 WEAR 16 ANTI 32 IMMUNE 0 REFINE 11 REFINE_SET 1 MAGIC_PCT 15


Dec 16 11:04:23 :: SHOP: #1 items: 23


Dec 16 11:04:23 :: SKILL: #1 »ï¿¬Âü flag 3 point HP affect 0 cooldown 12


Dec 16 11:04:23 :: REFINE: id 1 cost 600 prob 90 mat1 0 cnt1 0
Dec 16 11:04:23 :: ITEM_ATTR: MAX_HP                 35 { 500 500 100 1500 2000 } { 0 5 5 5 5 0 0 }
Dec 16 11:04:23 :: BANWORD: total 111
Dec 16 11:04:23 :: OBJ_PROTO: vnum 14013 price 20000000 mat 90010 2


Dec 16 11:04:23 :: OBJ: 116 vnum 14120 map 41    994862x268238  life 0
SYSERR: Dec 16 11:04:23 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
Dec 16 11:04:23 :: SYSTEM: BINDING TCP PORT ON [15000]
Dec 16 11:04:23 :: ACCEPT_HANDLE: 19
Dec 16 11:04:23 :: PLAYER_DELETE_LEVEL_LIMIT set to 70
Dec 16 11:04:23 :: PLAYER_DELETE_LEVEL_LIMIT_LOWER set to 0
Dec 16 11:04:23 :: CHINA_EVENT_SERVER false
Dec 16 11:04:23 :: EventFlag Load oxevent_status 0
Dec 16 11:04:23 ::    OK
Dec 16 11:04:23 :: POWER_POLY: 
Dec 16 11:04:23 :: HANDICAP_POLY: 
Dec 16 11:04:23 :: MarriageList(size=0)
SYSERR: Dec 16 11:04:23 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
Dec 16 11:04:23 :: ItemIDRange: Build: 10000001 ~ 20000000 start:10000149
Dec 16 11:04:23 :: Metin2DBCacheServer Start
Dec 16 11:04:23 :: ClientManager pointer is 0xbfbfe3c8
Dec 16 11:04:24 :: Connection accepted. (host: 127.0.0.1 handle: 1 fd: 20)
Dec 16 11:04:24 :: ACCEPT FROM 127.0.0.1
Dec 16 11:04:24 :: ItemIDRange: SET  10000001 ~ 20000000 start: 10000149
Dec 16 11:04:24 :: ItemIDRange: SPARE SET  20000001 ~ 30000000 start: 20000001
Dec 16 11:04:24 :: GMHosts 86.121.96.192
Dec 16 11:04:24 :: Admin name C'estMagnifique ConntactIP 
Dec 16 11:04:24 :: Admin name Tomy ConntactIP 
Dec 16 11:04:24 :: SETUP: channel 1 listen 13001 p2p 14001 count 1
Dec 16 11:04:24 :: HEADER_GD_SET_EVENT_FLAG : No Changed CClientmanager::SetEventFlag(oxevent_status 0) 
Dec 16 11:04:25 :: Connection closed. (host: 127.0.0.1)
Dec 16 11:04:25 :: ItemIDRange: returned. 10000001 ~ 20000000
Dec 16 11:04:25 :: ItemIDRange: Build: 10000001 ~ 20000000 start:10000149
SYSERR: Dec 16 11:04:25 :: Process: FDWATCH: peer null in event: ident 20
Dec 16 11:04:26 :: Connection accepted. (host: 127.0.0.1 handle: 2 fd: 20)
Dec 16 11:04:26 :: ACCEPT FROM 127.0.0.1
Dec 16 11:04:26 :: HEADER_GD_SET_EVENT_FLAG : No Changed CClientmanager::SetEventFlag(oxevent_status 0) 
Dec 16 11:04:26 :: AUTH_PEER ptr 0x28848600
Dec 16 11:04:26 :: Connection accepted. (host: 127.0.0.1 handle: 3 fd: 21)
Dec 16 11:04:26 :: ACCEPT FROM 127.0.0.1
Dec 16 11:04:26 :: GMHOST: 86.121.96.192
Dec 16 11:04:26 :: GM: PID 1 Login jesuistamer Character C'estMagnifique ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Dec 16 11:04:26 :: GM: PID 2 Login tomy Character Tomy ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Dec 16 11:04:26 :: QUERY_BOOT : AdminInfo (Request ServerIp 91.233.106.174) 
Dec 16 11:04:26 :: BOOT: PACKET: 1077819
Dec 16 11:04:26 :: BOOT: VERSION: 6
Dec 16 11:04:26 :: sizeof(TMobTable) = 255
Dec 16 11:04:26 :: ItemIDRange: SET  30000001 ~ 40000000 start: 30000089
Dec 16 11:04:26 :: ItemIDRange: SPARE SET  40000001 ~ 50000000 start: 40000001
Dec 16 11:04:26 :: GMHosts 86.121.96.192
Dec 16 11:04:26 :: Admin name C'estMagnifique ConntactIP 
Dec 16 11:04:26 :: Admin name Tomy ConntactIP 
Dec 16 11:04:26 :: SETUP: channel 99 listen 13099 p2p 14099 count 1
Dec 16 11:04:26 :: HEADER_GD_SET_EVENT_FLAG : No Changed CClientmanager::SetEventFlag(oxevent_status 0) 
Dec 16 11:04:27 :: Connection closed. (host: 127.0.0.1)
Dec 16 11:04:27 :: ItemIDRange: returned. 30000001 ~ 40000000
Dec 16 11:04:27 :: ItemIDRange: Build: 30000001 ~ 40000000 start:30000089
SYSERR: Dec 16 11:04:27 :: Process: FDWATCH: peer null in event: ident 21
Dec 16 11:04:28 :: [       50] return 0/0/0 async 0/0/0

wie kann ich das Problem lösen? ( how can i solve this problem? ) : Handsdown:
tomygus is offline  
Old 12/16/2012, 11:52   #2
 
elite*gold: 0
The Black Market: 43/0/0
Join Date: Dec 2012
Posts: 284
Received Thanks: 37
Was hast du denn als letztes an deiner DB geändert ?
⁂№Delorm⁂ is offline  
Old 12/16/2012, 14:11   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2012
Posts: 20
Received Thanks: 4
Ich änderte mob_proto ,aber dann habe ich habe es wieder und immer noch nicht funktioniert

( I changed mob_proto , but after i saw the server doesn't start i've installed back old mob_proto and still doesn't work )
tomygus is offline  
Reply

« Quest Give item ?? | Interfaces Help »

Similar Threads Similar Threads
ERROR: GAME DB INIT ERROR : [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL serv
08/06/2013 - Rappelz Private Server - 5 Replies
Hallo :D:D ich habe ein Problem, und zwar kommt bei mir immer diese Fehlermeldung wenn ich den CaptainHerlockServer starte ,,ERROR: GAME DB INIT ERROR : Ungültige Autorisierungsangab." Ich habe zwar schon etwas darüber gelesen, doch nur auf englisch und die meinte etwas über die DB files :confused::confused::confused: doch ich habe keine ahnung wo ich diese Files herbekomme, bitte um schnelle Hilfe Danke! :):)
İbot Error-Error Video- Error İmages-HELP
04/10/2012 - DarkOrbit - 11 Replies
SORRY, MY ENGLİSH VERY BAD.I USE TO GOOGLE TRANSLATE :) Most people trying to ibot but in my computer İbot not working. Declared out this error everywhere but I do not get answers Here's the error Video http://youtu.be/q0fK09v-K3c
API Error Code: 100 API Error Description: Invalid parameter Error Message: redirect_
04/08/2012 - elite*gold Trading - 2 Replies
API Error Code: 100 API Error Description: Invalid parameter Error Message: redirect_uri URL is not properly formatted Das bekomme ich wenn ich ne App installiere... ich habe schon 3 Apps richtig installiert, danach kam immer das bei anderen Apps die ich installiert habe.. was heisst das? redirect_uri URL is not properly formatted



All times are GMT +1. The time now is 22:06.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.