server crash

yahshuah · Feb 21, 2007

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?

Crypto37 · Feb 21, 2007

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

Rotana · Feb 21, 2007

what are the errors in the log file?

yahshuah · Feb 21, 2007

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

Rotana · Feb 21, 2007

is there any error in the log file?

yahshuah · Feb 21, 2007

Rotana said:
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 · Feb 21, 2007

yashua said:
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 · Feb 21, 2007

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 · Feb 21, 2007

the error report says its on the address 0x000000000043f05b

Rotana · Feb 21, 2007

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

Crypto37 · Feb 22, 2007

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 · Feb 22, 2007

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

Crypto37 · Feb 22, 2007

yashua said:
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 · Feb 22, 2007

Crypto37 said:
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 · Feb 22, 2007

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 · Feb 23, 2007

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

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

Crypto37 · Feb 23, 2007

Linear88 said:
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 · Feb 23, 2007

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

server crash

Junior Spellweaver

Junior Spellweaver

The beer?? Its here !!!

Junior Spellweaver

The beer?? Its here !!!

Junior Spellweaver

The beer?? Its here !!!

Junior Spellweaver

Junior Spellweaver

The beer?? Its here !!!

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

`-`

Junior Spellweaver

Junior Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners