[Error] Disconnect.

07/24/2014 13:22 bar2eldad#1
EDIT : Its new problem came so i show it instead of old .

Sometimes i am getting Dissconect i watch log and i see it .
07/24/2014 17:01 Cansas59#2
The item Mall is not the same in DB and Client?
07/24/2014 19:27 bar2eldad#3
Quote:
Originally Posted by Cansas59 View Post
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 ?
07/24/2014 23:18 Cansas59#4
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
07/26/2014 13:52 Autrux#5
#moved
07/27/2014 16:26 bar2eldad#6
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
07/28/2014 09:17 Cansas59#7
maybe, delete all the tables and install again, this will helps maybe
07/28/2014 10:31 [Admin]Slice#8
Quote:
Originally Posted by bar2eldad View Post
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.