[Error] Disconnect.

~~bar2eldad~~ · 07/24/2014, 13:22

EDIT : Its new problem came so i show it instead of old .

Sometimes i am getting Dissconect i watch log and i see it .

Cansas59 · 07/24/2014, 17:01

The item Mall is not the same in DB and Client?

~~bar2eldad~~ · 07/24/2014, 19:27

Quote:

Originally Posted by Cansas59

The item Mall is not the same in DB and Client?

Yeah it is . I match everything with client after i am editing i just import > run .sql . On my logs seems like PS_UserData.dbo.UserLoginStatus Table Is Missing ? There's Table named UserLoginStatus on PS_UserData ?

Cansas59 · 07/24/2014, 23:18

yes try this:

USE [PS_UserData]
GO

/****** Object: Table [dbo].[UserLoginStatus] Script Date: 07/24/2014 23:18:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[UserLoginStatus](
[UserUid] [int] NOT NULL,
[Userid] [char](18) NOT NULL,
[LoginStatus] [tinyint] NOT NULL,
[LoginTime] [datetime] NULL,
[LogoutTime] [datetime] NULL,
[LoginSession] [bigint] NULL,
[LogoutSession] [bigint] NULL,
[LastPlayTime] [int] NULL,
CONSTRAINT [PK_UserLoginStatus] PRIMARY KEY CLUSTERED
(
[UserUid] 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

SET ANSI_PADDING OFF
GO

Autrux · 07/26/2014, 13:52

#moved

~~bar2eldad~~ · 07/27/2014, 16:26

Cansas59 Thank you . i dont know how this table was Missing

There is one more my DB is missing maybe you have it ?

PS_GameLog.dbo.UserLog .. this 1 is miss . who have please put query to create this object . Thanks

Cansas59 · 07/28/2014, 09:17

maybe, delete all the tables and install again, this will helps maybe

[Admin]Slice · 07/28/2014, 10:31

Quote:

Originally Posted by bar2eldad

Cansas59 Thank you . i dont know how this table was Missing

There is one more my DB is missing maybe you have it ?

PS_GameLog.dbo.UserLog .. this 1 is miss . who have please put query to create this object . Thanks

USE [PS_GameLog]
GO

/****** Object: Table [dbo].[UserLog] Script Date: 7/28/2014 4:31:32 AM ******/
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

There ya go.