server crash

**yahshuah** · 21-02-07

Hey my server keeps crashing and it says send error report thing pops up it happends randomly at diffrent times now its becoming a bit of a problem could somone please help me?

**MentaL**

**Crypto37** · 21-02-07

their is an error with your client, somtimes it happens if you do not have the correct map files.

**Rotana** · 21-02-07

what are the errors in the log file?

**yahshuah** · 21-02-07

What do i need to do the glitch is happening a lot now

**Rotana** · 21-02-07

is there any error in the log file?

**yahshuah** · 21-02-07

Originally Posted by Rotana

is there any error in the log file?

yes here is the last log file from the last crash

USE [GunzDB]
GO
/****** Object: Table [dbo].[ServerStatus] Script Date: 02/19/2007 20:45:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ServerStatus](
[ServerID] [int] NULL,
[ServerName] [nvarchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PlayerCount] [int] NULL,
[MaxPlayer] [int] NULL,
[CurrPlayer] [int] NULL,
[Time] [datetime] NULL,
[IP] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Port] [int] NULL,
[Opened] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StatusTime] [int] NULL,
[UpdateTime] [int] NULL,
[RecvUDP] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SendUDP] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BlockUDP] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spUpdateLocatorStatus]
@nServerID INT,
@RecvUDP VARCHAR,
@SendUDP VARCHAR,
@BlockUDP INT,
@UpdateTime INT
AS
BEGIN
SET NOCOUNT ON;
-- Update UDP Status
UPDATE ServerStatus
SET RecvUDP = @RecvUDP, SendUDP = @SendUDP, BlockUDP = @BlockUDP, UpdateTime = @UpdateTime
WHERE ServerID = @nServerID

END

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spStartUpLocatorStatus]
@nServerID int,
@nIP varchar(50),
@nPort int,
@nStatusTime varchar(4000)
AS
-- Remove old server.
DELETE FROM ServerStatus WHERE ServerID = @nServerID
-- Add new server.
INSERT INTO ServerStatus (ServerID,IP,Port,StatusTime) VALUES (@nServerID,@nIP,@nPort,@nStatusTime)

**Rotana** · 21-02-07

Originally Posted by yashua

yes here is the last log file from the last crash

USE [GunzDB]
GO
/****** Object: Table [dbo].[ServerStatus] Script Date: 02/19/2007 20:45:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ServerStatus](
[ServerID] [int] NULL,
[ServerName] [nvarchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PlayerCount] [int] NULL,
[MaxPlayer] [int] NULL,
[CurrPlayer] [int] NULL,
[Time] [datetime] NULL,
[IP] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Port] [int] NULL,
[Opened] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StatusTime] [int] NULL,
[UpdateTime] [int] NULL,
[RecvUDP] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SendUDP] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BlockUDP] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spUpdateLocatorStatus]
@nServerID INT,
@RecvUDP VARCHAR,
@SendUDP VARCHAR,
@BlockUDP INT,
@UpdateTime INT
AS
BEGIN
SET NOCOUNT ON;
-- Update UDP Status
UPDATE ServerStatus
SET RecvUDP = @RecvUDP, SendUDP = @SendUDP, BlockUDP = @BlockUDP, UpdateTime = @UpdateTime
WHERE ServerID = @nServerID

END

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spStartUpLocatorStatus]
@nServerID int,
@nIP varchar(50),
@nPort int,
@nStatusTime varchar(4000)
AS
-- Remove old server.
DELETE FROM ServerStatus WHERE ServerID = @nServerID
-- Add new server.
INSERT INTO ServerStatus (ServerID,IP,Port,StatusTime) VALUES (@nServerID,@nIP,@nPort,@nStatusTime)

This an server log file??? No this is a part of your database
i mean the txt file in the folder MatchServer\Log\

**yahshuah** · 21-02-07

LOL sorry wrong copy and paste

[02/21/07 14:21:30] Release Date : Dec 19 2005

[02/21/07 14:21:32] DBMS connected
[02/21/07 14:21:32] Command registeration completed
[02/21/07 14:21:32] Match Server Created (Port:6000)
MMatchDBMgr::InsertConnLog - Could not find stored procedure 'spInsertConnLog'.

MMatchDBMgr::InsertConnLog - Could not find stored procedure 'spInsertConnLog'.

MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

MMatchDBMgr::InsertGameLog - Could not find stored procedure 'spInsertGameLog'.
Query:{CALL spInsertGameLog ('Come all', 'Mansion', 'Death Match(°³ÀÎ)', 10, 1305, 1, 'Jessica ')}
MMatchDBMgr::InsertPlayerLog - Could not find stored procedure 'spInsertPlayerLog'.

[14:23:31] Async DB Query(OnAsyncCharFinalize) Failed
MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

MMatchDBMgr::InsertConnLog - Could not find stored procedure 'spInsertConnLog'.

[02/21/07 14:24:32] GARBAGE SESSION CLEANING : ClientCount=2, SessionCount=2, AgentCount=0
MMatchDBMgr::InsertServerLog - Could not find stored procedure 'spInsertServerLog'.

MMatchDBMgr::InsertCharMakingLog - Could not find stored procedure 'spInsertCharMakingLog'.

**yahshuah** · 21-02-07

the error report says its on the address 0x000000000043f05b

**Rotana** · 22-02-07

your database is messed up. you need al the procedures
InsertCharMakingLog
InsertServerLog
spInsertConnLog
spInsertPlayerLog
spInsertGameLog'

**Crypto37** · 22-02-07

Code:

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spInsertCharMakingLog]    Script Date: 02/21/2007 19:44:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[spInsertCharMakingLog]
	@test1 varchar(MAX),
	@test2 varchar(MAX),
	@test3 varchar(MAX)
AS
BEGIN
	INSERT INTO PlayerLog (ID1, ID2, ID3) VALUES (@test1,@test2,@test3)
END

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spInsertConnLog]    Script Date: 02/21/2007 19:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[spInsertConnLog]
	@test1 nvarchar(50),
	@test2 nvarchar(50),
	@test3 nvarchar(50),
	@test4 nvarchar(50),
	@test5 nvarchar(50),
	@test6 nvarchar(50)
AS
BEGIN
	INSERT INTO ServerConnLog (ID1,ID2,ID3,ID4,ID5,ID6) VALUES (@test1,@test2,@test3,@test4,@test5,@test6)
END

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spInsertServerLog]    Script Date: 02/21/2007 19:44:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[spInsertServerLog]
	@test1 varchar(MAX),
	@test2 varchar(MAX),
	@test3 varchar(MAX),
	@test4 varchar(MAX),
	@test5 varchar(MAX)
AS
BEGIN
	INSERT INTO ServerLog (ID1,ID2,ID3,ID4,ID5) VALUES (@test1,@test2,@test3,@test4,@test5)
END

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spInsertPlayerLog]    Script Date: 02/21/2007 19:44:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[spInsertPlayerLog]
	@test1 varchar(MAX),
	@test2 varchar(MAX),
	@test3 varchar(MAX),
	@test4 varchar(MAX),
	@test5 varchar(MAX),
	@test6 varchar(MAX)
AS
BEGIN
	INSERT INTO PlayerLog (ID1, ID2, ID3, ID4, ID5, ID6) VALUES (@test1,@test2,@test3,@test4,@test5,@test6)
END

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spInsertGameLog]    Script Date: 02/21/2007 19:44:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[spInsertGameLog]
	@test   nvarchar(50),
	@test2  nvarchar(50),
	@test3  nvarchar(50),
	@test4  nvarchar(50),
	@test5  nvarchar(50),
	@test6  nvarchar(50),
	@test7  nvarchar(50)
AS
BEGIN
	INSERT INTO locatorlog (ID1,ID2,ID3,ID4,ID5,ID6,ID7) VALUES (@test,@test2,@test3,@test4,@test5,@test6,@test7)
END

Welcome. ^.^
Your log was telling you that your missing files.

**yahshuah** · 22-02-07

none of the databases come with them in it???????????????????????????????????? why does my server keep crashing

**Crypto37** · 22-02-07

Originally Posted by yashua

none of the databases come with them in it???????????????????????????????????? why does my server keep crashing

We dont know that, and No no databases come with it. Put it in your self -.- Your not that lazy and if you are. i feel sorry for you.

**yahshuah** · 22-02-07

Originally Posted by Crypto37

We dont know that, and No no databases come with it. Put it in your self -.- Your not that lazy and if you are. i feel sorry for you.

Where can I find a database with it in I checked the database in the TUT on how to set the server it self up and they were not in it.?

**Crypto37** · 22-02-07

Dude, They WONT Be in it. i already said that.
YOU HAVE TO PUT IT IN THEIR YOURSELF. Holy smokes, ive said this twice.

**Linear88** · 23-02-07

MMatchDBMgr::InsertServerLog - Invalid object name 'ServerLog'.

Isn't it called dbo.ServerLog and not ServerLog?

**Crypto37** · 23-02-07

Originally Posted by Linear88

MMatchDBMgr::InsertServerLog - Invalid object name 'ServerLog'.

Isn't it called dbo.ServerLog and not ServerLog?

No. After you create a Table, it removes the dbo. but Once you do the dropdown menus on the left side, it shows the dbo. stuff

**yahshuah** · 23-02-07

What do i pur in side of the dattabases??????? and how do i make them?

server crash

Thread Tools

Search Thread

server crash

Advertisement