PS_UserLog error

[dorado1234]

Hellow guys, when I select my character gives me this error: "Game data load error"
PS_UserLog:
2018-02-14 17:54:42 PS_USERLOG__system log start (UserLog)

2018-02-14 17:54:46 connect

2018-02-14 17:55:03 connect

2018-02-14 17:55:05 connect

2018-02-14 17:55:58 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'PS_GameLog.dbo.UserLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2018-02-14 17:55:58 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 1,5232371168509427713,4,'64'

2018-02-14 17:55:58 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'PS_GameLog.dbo.UserLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2018-02-14 17:55:58 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 1,5232371168509427713,4,'64'


if somebody can help me with where are the problem?

[XareL]

Check this query from in DB > usp_Try_GameLogout_R

[dorado1234]

I find it. Now, what i need do?

[[MXD]Takeshi]

Originally Posted by dorado1234

I find it. Now, what i need do?

you missing this table, you can add it, or check proc for delete string

[killer2p]

your missing your userlog

[dorado1234]

Thanks for your answers, but what should I do to fix this error?

[{Skrillex}]

Maybe the full database is missing. If not
execute this query below:

PHP Code:

USE [PS_GameLog]
GO

/****** Object:  Table [dbo].[UserLog]    Script Date: 02/15/2018 08:30:18 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[UserLog](
    [row] [int] IDENTITY(1,1) NOT NULL,
    [UserUID] [int] NULL,
    [SessionID] [bigint] NULL,
    [LogoutType] [smallint] NULL,
    [ErrType] [int] NULL,
    [LogType] [int] NULL,
    [LogTime] [datetime] NULL,
 CONSTRAINT [PK_UserLog] PRIMARY KEY CLUSTERED 
(
    [row] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO 


[dorado1234]

Hellow, this script don't work for me :/ i don't know that do

[{Skrillex}]

Men, then please descripe what the problem is.
The Log says clearly that your .dbo.UserLog is missing. When you want help then tell us what says SQL Server after executing? Are you share that you have PS_GameLog DATABASE?

Regards

[dorado1234]

Sorry, i'm having error when i want enter with my character : " Game Data Load Error" i have ep 4.5 and my register are clean
your script work but i'm having game data load error.i was editing npcquest.data before of that error
PS_SESSION
2018-02-15 11:19:02 PS_SESSION__system log start (Session)

2018-02-15 11:19:03 userlog connect failed

2018-02-15 11:19:03 initserver() failed

2018-02-15 11:19:03 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2018-02-15 11:19:03 PS_SESSION__system log end (Session)

2018-02-15 11:19:03 3 1 SService::ServiceCtrlDispatcher(): service shutdown




PS_LOGIN:
2018-02-15 11:19:19 PS_LOGIN__system log start (Login01)

2018-02-15 11:19:21 session connect failed

2018-02-15 11:19:21 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2018-02-15 11:19:21 PS_LOGIN__system log end (Login01)

2018-02-15 11:19:21 3 1 SService::ServiceCtrlDispatcher(): service shutdown

[{Skrillex}]

Okay. Do you have added linked server to SQL Server?

It´s better when you post your PS_DBAGENT Log here.

[dorado1234]

I have error "game data load error". i was editing npcquest.sdata and i was put him on my shaiya server file > PS_CLIENT > BIN > DATA > HERE and now i have this error and i was import him with shaiya data tool to my client.

PS_DBAGENT:
2018-02-15 19:16:55 PS_DBAGENT__system log start (DBAgent01)

2018-02-15 19:17:06 connect game, Name=



2018-02-15 19:17:06 connect game, Name=

[{Skrillex}]

Okay. Then you need to encrypt the NpcQuest.Sdata.

But in your logs PS_Session it sais cant connect to iniserver

[dorado1234]

PS_SESSION:
2018-02-15 19:16:47 PS_SESSION__system log start (Session)

2018-02-15 19:17:04 connect login

2018-02-15 19:17:06 connect game


i was fix it. but i have this error " game data load error" now i change this npcquest.data but i have the error too. :/

[{Skrillex}]

Then you imported the NpcQuest.SData wrong. Client side needs to be decrypted