Re: Cannot Access Server o.O
Quote:
Originally Posted by
Phoenix
See? You have errors in your database. I'd suggest you to use the one that I released (sticky thread) or just execute this if you don't want to lose your data.
Code:
/****** Object: StoredProcedure [dbo].[spGetAccountInfo] Script Date: 11/17/2010 14:36:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetAccountInfo]
@AID int
, @ServerID int = 0
AS
BEGIN
SET NOCOUNT ON
SELECT AID, UserID, UGradeID, Name, HackingType
, DATEPART(yy, EndHackingBlockTime) AS HackBlockYear, DATEPART(mm, EndHackingBlockTime) AS HackBlockMonth
, DATEPART(dd, EndHackingBlockTime) AS HackBlockDay, DATEPART(hh, EndHackingBlockTime) AS HackBlockHour
, DATEPART(mi, EndHackingBlockTime) AS HackBlockMin
FROM Account(NOLOCK) WHERE AID = @AID
update Account set LastLoginTime = getdate(), ServerID = @ServerID where aid = @aid
END
i am using your db and it won't work ;o?
Re: Cannot Access Server o.O
Quote:
Originally Posted by
Phoenix
See? You have errors in your database. I'd suggest you to use the one that I released (sticky thread) or just execute this if you don't want to lose your data.
Code:
/****** Object: StoredProcedure [dbo].[spGetAccountInfo] Script Date: 11/17/2010 14:36:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetAccountInfo]
@AID int
, @ServerID int = 0
AS
BEGIN
SET NOCOUNT ON
SELECT AID, UserID, UGradeID, Name, HackingType
, DATEPART(yy, EndHackingBlockTime) AS HackBlockYear, DATEPART(mm, EndHackingBlockTime) AS HackBlockMonth
, DATEPART(dd, EndHackingBlockTime) AS HackBlockDay, DATEPART(hh, EndHackingBlockTime) AS HackBlockHour
, DATEPART(mi, EndHackingBlockTime) AS HackBlockMin
FROM Account(NOLOCK) WHERE AID = @AID
update Account set LastLoginTime = getdate(), ServerID = @ServerID where aid = @aid
END
I am using your db.
I have compiled the script got some error:
Code:
Msg 137, Level 15, State 2, Procedure spGetAccountInfo, Line 14
Must declare the scalar variable "@aid".
And the same problem..
"Cannot Access Server"
Re: Cannot Access Server o.O
My database doesn't give such errors. You probably executed some scripts on it like X-Weaver's database or something.
Re: Cannot Access Server o.O
Quote:
Originally Posted by
Phoenix
My database doesn't give such errors. You probably executed some scripts on it like X-Weaver's database or something.
I have used your db I am sure because I have downloaded repack 3.
Anyway trying to delete and restore your .bak file..
Edit:
Same Message.
Re: Cannot Access Server o.O
What other scripts did you execute on your database?
Re: Cannot Access Server o.O
Quote:
Originally Posted by
Phoenix
What other scripts did you execute on your database?
Nothing.
Just restored database and tried..
Re: Cannot Access Server o.O
Check 8900 in dbo.LocatorStatus and 6000 in dbo.ServerStatus.
Re: Cannot Access Server o.O
Quote:
Originally Posted by
gatsu
Check 8900 in dbo.LocatorStatus and 6000 in dbo.ServerStatus.
Checked and everything is ok..?
Re: Cannot Access Server o.O
HeLMaX it's not possible to have this error if you've done everything correctly you made just a simple mistake, otherwise reinstall everything again.
Re: Cannot Access Server o.O
Quote:
Originally Posted by
llMafiall
HeLMaX it's not possible to have this error if you've done everything correctly you made just a simple mistake, otherwise reinstall everything again.
I don't know whats the problem exactly but I am sure that on db..
Match server log:
Code:
MMatchDBMgr::GetAccountInfo - Could not find stored procedure 'spGetAccountInfo'.
MMatchDBMgr::UpdateAccountLastLoginTime - Error converting data type numeric to int.
[12/18/10 15:52:31] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1, CommandPool=5, objHistoryCount=3
Once again.. Thats Phoenix's database.
---------- Post added at 08:00 PM ---------- Previous post was at 06:36 PM ----------
Fixed.
/Close please.
Re: Cannot Access Server o.O
Mind telling me how it happened and how you fixed it? Because my database seriously doesn't give these errors.
Re: Cannot Access Server o.O
Quote:
Originally Posted by
Phoenix
Mind telling me how it happened and how you fixed it? Because my database seriously doesn't give these errors.
i want to know it too, if you don't mind telling?
Re: Cannot Access Server o.O
I dont want to quote his post that this community never helps. But take a look at him o.O
Re: Cannot Access Server o.O
Quote:
Originally Posted by
llMafiall
I dont want to quote his post that this community never helps. But take a look at him o.O
yeh true..
fixed
/close please..
and he is saying the comunity won't help..
fine you tell us how u fixed >.<
Re: Cannot Access Server o.O
Quote:
Originally Posted by
Phoenix
Mind telling me how it happened and how you fixed it? Because my database seriously doesn't give these errors.
Yea sure..
The cod should be:
Code:
/****** Object: StoredProcedure [dbo].[spGetAccountInfo] Script Date: 11/17/2010 14:36:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetAccountInfo]
@AID int
, @ServerID int = 0
AS
BEGIN
SET NOCOUNT ON
SELECT AID, UserID, UGradeID, Name, HackingType
, DATEPART(yy, EndHackingBlockTime) AS HackBlockYear, DATEPART(mm, EndHackingBlockTime) AS HackBlockMonth
, DATEPART(dd, EndHackingBlockTime) AS HackBlockDay, DATEPART(hh, EndHackingBlockTime) AS HackBlockHour
, DATEPART(mi, EndHackingBlockTime) AS HackBlockMin
FROM Account(NOLOCK) WHERE AID = @AID
update Account set LastLoginTime = getdate(), ServerID = @ServerID where AID = @AID
END
Quote:
Originally Posted by
llMafiall
I dont want to quote his post that this community never helps. But take a look at him o.O
Take a look at your self nab.
Quote:
Originally Posted by
jur13n
yeh true..
fixed
/close please..
and he is saying the comunity won't help..
fine you tell us how u fixed >.<
Don't break your ass.. Just ask for it why QQ ?
