2010 "us" (uk) database

05/02/2011 09:22 RumorUS#1
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: [Only registered and activated users can see links. Click Here To Register...]

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 :)
05/03/2011 01:47 RumorUS#2
bump
05/03/2011 08:32 ¢ýL#3
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
05/03/2011 17:12 RumorUS#4
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..
05/04/2011 02:16 RumorUS#5
anyone?
05/04/2011 07:08 ¢ýL#6
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?
05/04/2011 22:22 RumorUS#7
yes I have restored the old one.. It is the one from Daroo 1675 files..

The server will only start with this itemproto :S
05/05/2011 14:44 RumorUS#8
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..
05/06/2011 22:34 RumorUS#9
bump..........
cmon people its fucking simple i know you know the answer because there are servers who have it working

take out 10 seconds from your time to reply ?
12/29/2011 17:01 LookAtMeLuz#10
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 :/
12/31/2011 10:11 RumorUS#11
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.
01/02/2012 14:14 LookAtMeLuz#12
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" :)
01/04/2012 22:59 RumorUS#13
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..