Pserver Assisntance

[ladylight]

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

[ismokedrow]

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

[ladylight]

ok thanks, i'll check to see if i can find that in the game server

[Shaddo1]

i have the same prob and i have the table of dbo any help plz

[c1ph3r]

1. Check your Authserver.opt it has to be:

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:

 Spoiler

USE [Auth]
GO

/****** Object: Table [dbo].[Accounts] Script Date: 29.11.2012 22:12:05 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Accounts](
[account_id] [int] IDENTITY(1,1) NOT NULL,
[login_name] [nvarchar](31) NULL,
[password] [nvarchar](32) NULL,
[block] [int] NULL,
[withdraw_remain_time] [int] NULL,
[age] [int] NULL,
[auth_ok] [int] NULL,
[pcbang] [int] NULL,
[last_login_server_idx] [int] NULL,
[event_code] [int] NULL,
[server_list_mask] [nvarchar](31) NULL,
[result] [int] NULL,
[ip] [int] NULL,
[game_code] [nvarchar](50) NULL,
[gamecode] [varchar](50) NULL,
[email] [nchar](300) NULL,
[e-mail] [varchar](50) NULL,
PRIMARY KEY CLUSTERED
(
[account_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

[ladylight]

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...

[mongreldogg]

4502 - try

[ladylight]

Originally Posted by mongreldogg

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.

[gr4ph0s]

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

[ladylight]

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

[gr4ph0s]

Just use this file =>

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