Pserver Assisntance

11/29/2012 19:00 ladylight#1
I have been searching for a few days now for a fix and have not had any success.

Everything I have going works, but when I go to log in it does nothing. Then in the auth server window it shows DB_Account: Invalid object name 'Account'

I have looked over the SQL Manager and did not see anything that would be amiss.

I have opened:

TCP 80
TCP 1433
TCP 4514
TCP 3516
TCP 4500
TCP 4518
TCP 4080

thinking it may have helped but it did not. If you have a fix please post.

Also I do use

start_service
set game.open_external1

in the Auth Server window. It does not work.

Please don't flame the thread.

Thank you
11/29/2012 19:54 ismokedrow#2
Er invalid object is saying the dbo. or table the AS has specified doesn't exist and it goes further to say it sought a table in the auth called dbo.Account
11/29/2012 20:17 ladylight#3
ok thanks, i'll check to see if i can find that in the game server
11/29/2012 21:13 Shaddo1#4
i have the same prob and i have the table of dbo any help plz
11/29/2012 22:07 c1ph3r#5
1. Check your Authserver.opt it has to be:
Code:
S db.auth.name:Auth
(Or the name of your Auth DB)

2. Check your Auth DB. A Table called "Accounts" has to be in it! If not use this:
11/29/2012 22:47 ladylight#6
checked both and both are as you stated. I have a dbo.Account under tables in the Auth DB. and my auth server opt has S db.auth.name:Auth which is my db name.

I still have the same issue. Im not sure what the heck is going on...
11/29/2012 22:58 mongreldogg#7
4502 - try
11/29/2012 23:17 ladylight#8
Quote:
Originally Posted by mongreldogg View Post
4502 - try
on what? not sure what you mean.

thanks

not sure if this makes a difference..

I'm not sure if I was mistaken at first but now I receive the following message.

DB COM ERROR(Thread 0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_Account: Invalid column name 'account'

That's the exact message

i went into the table and edited the account column and changed it to login_name

I then tried to log in again after rebooting and still receive the same message.
11/30/2012 00:30 gr4ph0s#9
DB_Account: Invalid column name 'account'

That mean you don't have the collumn 'account' into your table.
Rename login_name into account

DB have structure if you changed it the Auth server will not recognize the data and will be not able to work correctly ;)
11/30/2012 00:45 ladylight#10
it was account and i changed it when i got the error. had a error either way

which table should it be in? it is in account ?
if so thats where it was
11/30/2012 09:24 gr4ph0s#11
Just use this file => [Only registered and activated users can see links. Click Here To Register...]

Delete your Auth DB.
Create New DB called Auth restore with the file ;)