PS_UserLog error

Page 1 of 2 1 2
02/14/2018 22:42 dorado1234#1
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?
02/14/2018 22:51 XareL#2
Check this query from in DB > usp_Try_GameLogout_R
02/14/2018 23:17 dorado1234#3
I find it. Now, what i need do?
02/15/2018 01:39 [MXD]Takeshi#4
Quote:
Originally Posted by dorado1234 View Post
I find it. Now, what i need do?
you missing this table, you can add it, or check proc for delete string
02/15/2018 02:01 killer2p#5
your missing your userlog
02/15/2018 02:25 dorado1234#6
Thanks for your answers, but what should I do to fix this error?
02/15/2018 08:30 {Skrillex}#7
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 
02/15/2018 14:09 dorado1234#8
Hellow, this script don't work for me :/ i don't know that do
02/15/2018 15:01 {Skrillex}#9
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
02/15/2018 15:22 dorado1234#10
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
02/15/2018 19:55 {Skrillex}#11
Okay. Do you have added linked server to SQL Server?

Itīs better when you post your PS_DBAGENT Log here.
02/15/2018 23:20 dorado1234#12
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=
02/16/2018 00:25 {Skrillex}#13
Okay. Then you need to encrypt the NpcQuest.Sdata.

But in your logs PS_Session it sais cant connect to iniserver
02/16/2018 00:34 dorado1234#14
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. :/
02/16/2018 00:52 {Skrillex}#15
Then you imported the NpcQuest.SData wrong. Client side needs to be decrypted
Page 1 of 2 1 2