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!

Item Server Log of Death?

Tantra Freelancer
Joined
Apr 9, 2014
Messages
541
Reaction score
23
I am wondering what does this log indicates?

sql [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'hb_tan_gp_userinfo_se'.

..and how to avoid this..

Ciao!
 
Banned
Banned
Joined
Mar 9, 2008
Messages
93
Reaction score
20
Create a ODBC to billcrux_phil Data Base and configure config.txt with this ODBC.

The problem is the hb_tan_gp_userinfo_se store procedure, if you still have the same problem you can execute the next code in your billcrux_phil Data Base.

Code:
/****** Object:  StoredProcedure [dbo].[hb_tan_gp_userinfo_se]    Script Date: 09/21/2014 18:05:14 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[hb_tan_gp_userinfo_se]
    [USER=1335]user[/USER]Id    AS    nvarchar(64)
AS
DECLARE [USER=315880]cas[/USER]hBalance    AS    INT
SELECT [USER=315880]cas[/USER]hBalance = cashBalance FROM tblUserInfo WHERE userId = [USER=1335]user[/USER]Id AND apply = 1
IF(@@ROWCOUNT = 0)
    SET [USER=315880]cas[/USER]hBalance = -1
SELECT [USER=315880]cas[/USER]hBalance AS cashBalance
GO
 
Upvote 0
Tantra Freelancer
Joined
Apr 9, 2014
Messages
541
Reaction score
23
Create a ODBC to billcrux_phil Data Base and configure config.txt with this ODBC.

The problem is the hb_tan_gp_userinfo_se store procedure, if you still have the same problem you can execute the next code in your billcrux_phil Data Base.

Code:
/****** Object:  StoredProcedure [dbo].[hb_tan_gp_userinfo_se]    Script Date: 09/21/2014 18:05:14 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[hb_tan_gp_userinfo_se]
    @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Id    AS    nvarchar(64)
AS
DECLARE @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance    AS    INT
SELECT @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance = cashBalance FROM tblUserInfo WHERE userId = @[I][B][URL="http://forum.ragezone.com/members/1335.html"]user[/URL][/B][/I]Id AND apply = 1
IF(@@ROWCOUNT = 0)
    SET @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance = -1
SELECT @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]hBalance AS cashBalance
GO

Thanks. Will look forward for the logs after restarting my itemsvr.exe.
 
Upvote 0
Junior Spellweaver
Joined
Jan 17, 2018
Messages
105
Reaction score
0
I suggest you look for a fixed database and restore it on another instance then just copy the whole stored procedures on your live server.

You are missing stored procedures on billcrux_phil.
 
Upvote 0
Back
Top