Register for your free account! | Forgot your password?

Go Back   elitepvpers › Popular Games › Metin2 › Metin2 Private Server
2010 "us" (uk) database 2010 "us" (uk) database
You last visited: Today at 02:17

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

Advertisement


Advertise with us!

2010 "us" (uk) database

Discussion on 2010 "us" (uk) database within the Metin2 Private Server forum part of the Metin2 category.

Closed Thread
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2010
Posts: 827
Received Thanks: 153
2010 "us" (uk) database

When I add the "db2010.US.tar" to the daroo files the server will not start right. I try to login and only get kicked to login screen.

I already used search and I already saw this:

It didn't help...

Here's my CONFIG/conf.txt files:

auth

channel1

db conf.txt


syserr:

db
Code:
SYSERR: May  2 02:17:04 :: Start: TABLE_POSTFIX not configured use default
SYSERR: May  2 02:17:05 :: 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: May  2 02:17:05 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: May  2 02:17:05 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
auth
Code:
SYSERR: May  2 02:17:06 :: socket_connect: HOST 220.95.239.40:7120, could not connect.
channel1

I did not include game99 beacuse I know 100% that it is not the problem, it is full of only things about "NOT_EXIST_GROUP_GROUP_VNUM(2431) MAP(184)". And it has always been like this but the server always started with that too.

So someone please help me out here on how to make server start again
RumorUS is offline  
Thanks
1 User
Old   #2
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2010
Posts: 827
Received Thanks: 153
bump
RumorUS is offline  
Old   #3

 
¢ýL's Avatar
 
elite*gold: 1
The Black Market: 17/0/0
Join Date: Aug 2010
Posts: 1,264
Received Thanks: 363
Well,what was the vnum in the error(wich item)from your old db not from the Usdaroo... Because in daroo us files it serms a map tobe in the server but not in the mysql database
¢ýL is offline  
Thanks
1 User
Old   #4
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2010
Posts: 827
Received Thanks: 153
Quote:
Originally Posted by Overloard007 View Post
Well,what was the vnum in the error(wich item)from your old db not from the Usdaroo... Because in daroo us files it serms a map tobe in the server but not in the mysql database
I don't really understand your question but I know this is not a problem relating to a map... I only inserted the "item_proto.fym", "item_proto.MYD", and "item_proto.MYI" to the database.. This is what is causing the problem not the maps..
RumorUS is offline  
Old   #5
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2010
Posts: 827
Received Thanks: 153
anyone?
RumorUS is offline  
Old   #6

 
¢ýL's Avatar
 
elite*gold: 1
The Black Market: 17/0/0
Join Date: Aug 2010
Posts: 1,264
Received Thanks: 363
okay,items,but i think in the item_proto table are stored some warp commands adn maps ,too.do you have your old item_proto.myd/myi/fym?
¢ýL is offline  
Thanks
1 User
Old   #7
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2010
Posts: 827
Received Thanks: 153
yes I have restored the old one.. It is the one from Daroo 1675 files..

The server will only start with this itemproto :S
RumorUS is offline  
Old   #8
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2010
Posts: 827
Received Thanks: 153
I found a problem when I login.. in "syslog" for "auth"...

Code:
May  5 07:37:02 :: SetRemainSecs kklmsfk 0 type 2
May  5 07:37:02 :: SendAuthLogin kklmsfk key 52164
May  5 07:37:02 :: AuthLogin result 1 key 1035307887
kklmsfk - my ID for login


db syserr:

Code:
SYSERR: May  5 07:21:28 :: Start: TABLE_POSTFIX not configured use default
SYSERR: May  5 07:21:28 :: 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: May  5 07:21:28 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: May  5 07:21:28 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: May  5 07:22:51 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: May  5 07:22:51 :: Process: FDWATCH: peer null in event: ident 22
This is what happens when I try to login.. and I get kicked to the screen to pick a channel/server. It's ONLY when I add the 2010 english item_proto table..
RumorUS is offline  
Old   #9
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2010
Posts: 827
Received Thanks: 153
bump..........
cmon people its ******* simple i know you know the answer because there are servers who have it working

take out 10 seconds from your time to reply ?
RumorUS is offline  
Old   #10
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2011
Posts: 41
Received Thanks: 2
i had the same problem i coun;t not find any help 2-3 weeks searching and then i changed server files.i think the problem maybe in db conf where it says #NAME_COLUMN = "gb2312name" i think you have to change the gb2312name, but i don't know what put instead of it :/
LookAtMeLuz is offline  
Old   #11
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2010
Posts: 827
Received Thanks: 153
They will cry because you replied to the topic which was last replied to in may.

I ended up having to setup a custom python script and executing it in freebsd to merge the database tables.
RumorUS is offline  
Old   #12
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2011
Posts: 41
Received Thanks: 2
Let them cry.
I answered this thread because even if it's on May. Maybe someone will have this problem too and he will not be able to find a solution so that's the reason, let them cry
and finaly i found the solution.In daroo 2011 files you have to change in the conf.txt of db the collum name ="gb2312name" to collum name = "locale_name"
LookAtMeLuz is offline  
Old   #13
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2010
Posts: 827
Received Thanks: 153
Quote:
Originally Posted by LookAtMeLuz View Post
Let them cry.
I answered this thread because even if it's on May. Maybe someone will have this problem too and he will not be able to find a solution so that's the reason, let them cry
and finaly i found the solution.In daroo 2011 files you have to change in the conf.txt of db the collum name ="gb2312name" to collum name = "locale_name"
I was referring to the "1675 noob edition" 2010 files. In those the db.conf change will not fix the problem..
RumorUS is offline  
Closed Thread

« Frage zum entpacken | Metin2 Design »

Similar Threads Similar Threads
Mehrere Channel 2010 Files (Frage zur Anzeige "norm" / "...")
02/11/2011 - Metin2 Private Server - 1 Replies
Guten Tag liebe Community, ich habe mir gestern (mehr aus lw) mal 6 Channels gemacht. Hier für habe ich Serverside den Channel1 (kp wie der vorher hieß, glaube game) kopiert und dann immer in Channel1/2/3/4 usw umbenannt. In diesen Channels hab ich jeweils die Ports erhöht, so dass diese funktionieren. Dann habe ich im Client in der Serverinfo.py den einen Channel der bisher da war 5 mal kopiert und auch die Ports umgeändert und diese 11 in 12/13/14 usw erhöht. Nun kann man auf die Channels...
Kann mir bitte jemmand eine Hmachi HP erstellen """""SOS HELP""""
09/15/2010 - Metin2 Private Server - 11 Replies
SO wie der Titel schon sagt ich suche einen der mir per Teamviwer eine hp machen kann habe schon alles ausprobiert aber es klappt nie!!!! PLS HELP...



All times are GMT +2. The time now is 02:18.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

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