Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

server crash

Y

yahshuah

Junior Spellweaver
Joined
Jan 27, 2007
Messages
109
Reaction score
0
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?
 
Sort by date Sort by votes
Crypto37

Crypto37

Junior Spellweaver
Joined
Jan 13, 2007
Messages
193
Reaction score
0
their is an error with your client, somtimes it happens if you do not have the correct map files.
 
Upvote 0
The Best DDoS Protected Servers
Y

yahshuah

Junior Spellweaver
Joined
Jan 27, 2007
Messages
109
Reaction score
0
Rotana said:
is there any error in the log file?
Click to expand...
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)
 
Upvote 0
Rotana

Rotana

The beer?? Its here !!!
Loyal Member
1000 Posts 10 Happy Years
Joined
Jan 9, 2007
Messages
1,621
Reaction score
104
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)
Click to expand...


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

yahshuah

Junior Spellweaver
Joined
Jan 27, 2007
Messages
109
Reaction score
0
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'.
 
Upvote 0
Crypto37

Crypto37

Junior Spellweaver
Joined
Jan 13, 2007
Messages
193
Reaction score
0
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.
 
Upvote 0
Y

yahshuah

Junior Spellweaver
Joined
Jan 27, 2007
Messages
109
Reaction score
0
none of the databases come with them in it???????????????????????????????????? why does my server keep crashing
 
Upvote 0
Crypto37

Crypto37

Junior Spellweaver
Joined
Jan 13, 2007
Messages
193
Reaction score
0
yashua said:
none of the databases come with them in it???????????????????????????????????? why does my server keep crashing
Click to expand...

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.
 
Upvote 0
Y

yahshuah

Junior Spellweaver
Joined
Jan 27, 2007
Messages
109
Reaction score
0
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.
Click to expand...
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.?
 
Upvote 0
Crypto37

Crypto37

Junior Spellweaver
Joined
Jan 13, 2007
Messages
193
Reaction score
0
Dude, They WONT Be in it. i already said that.
YOU HAVE TO PUT IT IN THEIR YOURSELF. Holy smokes, ive said this twice.
 
Upvote 0
Crypto37

Crypto37

Junior Spellweaver
Joined
Jan 13, 2007
Messages
193
Reaction score
0
Linear88 said:
MMatchDBMgr::InsertServerLog - Invalid object name 'ServerLog'.

Isn't it called dbo.ServerLog and not ServerLog?
Click to expand...

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
 
Upvote 0
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Forum statistics

Threads
431,689
Messages
4,604,160
Members
294,681
Latest member
maple__1
Most visitors online was 18079 , on 7 Jul 2024

Partners

    nongamstopbets.com Non-GamStop CasinoGap Casino Deps NZ
Back
Top