-
Cant Open Locator
I can not opens my locator to opens my GunZ Server
when I go to log and I open one file note-pad:
start init locator.
MLocatorDBMgr::StartUpLocaterStauts - Could not find stored procedure 'spStartUpLocatorStatus'.
MLocator::Create - init DB fail
( sorry for my Bad english ^^ )
-
Re: Cant Open Locator
Execute this on your database:
Code:
GO
/****** Object: StoredProcedure [dbo].[spStartUpLocatorStatus] Script Date: 11/17/2010 14:36:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spStartUpLocatorStatus]
@LocatorID int
, @IP varchar(15)
, @Port int
, @UpdateElapsedTime int
AS
SET NOCOUNT ON
IF EXISTS (SELECT LocatorID FROM LocatorStatus(NOLOCK)
WHERE LocatorID = @LocatorID) BEGIN
UPDATE LocatorStatus
SET IP = @IP, Port = @Port, UpdateElapsedTime = @UpdateElapsedTime,
LastUpdatedTime = GETDATE()
WHERE LocatorID = @LocatorID
END
ELSE BEGIN
INSERT INTO LocatorStatus(LocatorID, IP, Port, UpdateElapsedTime, LastUpdatedTime)
VALUES (@LocatorID, @IP, @Port, @UpdateElapsedTime, GETDATE())
END
-
Re: Cant Open Locator