Abbygamerz Skills Race Procedure Issue

[ThroneX]

Hey guys.

I keep getting this on my match server every second!

[12/24/15 15:53:43] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL SP_Get_Skills_Race ()} ), ErrCode( -1 )
ErrMsg - Procedure or function 'SP_Get_Skills_Race' expects parameter '@RaceId', which was not supplied.
State:37000,Native:201,Origin:[Microsoft][SQL Server Native Client 11.0][SQL Server]

[12/24/15 15:53:43] NO SE CARGO LA SKILL RACE LIST

I have executed the procedure below already;

USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[SP_Get_Skills_Race] Script Date: 12/24/2015 16:39:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROC [dbo].[SP_Get_Skills_Race]
@RaceId int
, @SkillId int
, @CoolDownTime int
, @Speed int
, @HP int
, @AP int
AS
SET NOCOUNT ON
UPDATE RaceCustomZombie WITH (rowlock)
SET RaceId=@RaceId, SkillId=@SkillId, CooldownTime=@CoolDownTime, Speed=@Speed, HP=@HP, AP=@AP

I don't have any table named "RaceCustomZombie" but got "RaceSkills" table, I have tried to change but it didn't work either. What could be the issue ?

EDIT: Fixed, don't ever use the procedure I have shared above. Simply use the original db backup and on the odbcad select sql native client. You might need to fix spGetAccountInfo and change "aid" to "AID" inside that procedure otherwise it will prompt can not get account info (in spanish).

 

[spaike23]

Use ODBC -> SQL Native Client.

 

[ThroneX]

Use ODBC -> SQL Native Client.

Nope, it didn't fix it..

 

[spaike23]

It works perfectly for me.

 

[bybuuthach]

It works perfectly for me.

How? -_-

 

[KYf Sika]

:sneaky2::sneaky2::sneaky2::sneaky2:

 

[ThroneX]

View attachment 155424View attachment 155425 :sneaky2::sneaky2::sneaky2::sneaky2:

Read main post, I have edited it with the fix.

 

[KYf Sika]

-ZombieMode






you can not select :sneaky2::sneaky2:

 

[discordaxe]

I did what is said in the edit but I still have the 'no se cargo la skill race list' error.

[09/08/17 19:37:43] Match Server Created (Port:6000)

Dueltournament Service Open(2017-9-8 Hour19, Min37) 
[09/08/17 19:37:43] SE CARGARON LOS ANUNCIOS

[09/08/17 19:37:43]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL SP_Get_Skills_Race ()} ), ErrCode( -1 )
ErrMsg - Procedure SP_Get_Skills_Race has no parameters and arguments were supplied.
State:37000,Native:8146,Origin:[Microsoft][SQL Native Client][SQL Server]

[09/08/17 19:37:43] NO SE CARGO LA SKILL RACE LIST

[09/08/17 19:37:43]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL SP_Get_WarriorClass ()} ), ErrCode( -1 )
ErrMsg - Procedure SP_Get_WarriorClass has no parameters and arguments were supplied.
State:37000,Native:8146,Origin:[Microsoft][SQL Native Client][SQL Server]

Daily Survival Ranking Request [month9 day8 hour19 min37]

[09/08/17 19:37:43]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL SP_Get_Skills_Race ()} ), ErrCode( -1 )
ErrMsg - Procedure SP_Get_Skills_Race has no parameters and arguments were supplied.
State:37000,Native:8146,Origin:[Microsoft][SQL Native Client][SQL Server]

[09/08/17 19:37:43] NO SE CARGO LA SKILL RACE LIST

[09/08/17 19:37:43]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL SP_Get_WarriorClass ()} ), ErrCode( -1 )
ErrMsg - Procedure SP_Get_WarriorClass has no parameters and arguments were supplied.
State:37000,Native:8146,Origin:[Microsoft][SQL Native Client][SQL Server]


[09/08/17 19:37:43]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL SP_Get_Skills_Race ()} ), ErrCode( -1 )
ErrMsg - Procedure SP_Get_Skills_Race has no parameters and arguments were supplied.
State:37000,Native:8146,Origin:[Microsoft][SQL Native Client][SQL Server]

[09/08/17 19:37:43] NO SE CARGO LA SKILL RACE LIST

[09/08/17 19:37:43]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL SP_Get_WarriorClass ()} ), ErrCode( -1 )
ErrMsg - Procedure SP_Get_WarriorClass has no parameters and arguments were supplied.
State:37000,Native:8146,Origin:[Microsoft][SQL Native Client][SQL Server]

success to update CustomIP

etc

 

[Forean]

It says it right there

Procedure SP_Get_WarriorClass has no parameters and arguments were supplied.

SP_Get_WarriorClass has arguments but no parameters to define what they do.

Open your source and trace SP_Get_WarriorClass and find what it is calling for the MSSQL, I'm assuming it isnt in the database so Its trying to get information from tables but they arent there..

Assuming this is your Matchserver Log, you're missing SQL tables/Procedures