database 1.5 problems

[jorklenis2]

[02/15/12 09:49:17] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertConnLog (3, 127, 0, 0, 1, '')} ), ErrCode( -1 )
ErrMsg - El nombre de objeto 'LogDB.dbo.ConnLog' no es válido.
State:S0002,Native:208,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]


[02/15/12 09:49:59] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertGameLog2 (1, 'Mansion', 'Death Match(Solo)')} ), ErrCode( -1 )
ErrMsg - El nombre de objeto 'LogDB.dbo.GameLog' no es válido.
State:S0002,Native:208,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[09:49:59] Async DB Query(OnAsyncInsertGameLog) Failed

[02/15/12 09:50:22] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertTPLogNetmarble (1, 43)} ), ErrCode( -1 )
ErrMsg - No se encontró el procedimiento almacenado 'spInsertTPLogNetmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

why?:*:

 

[cheaterastic]

This is my Problem Too.

And I know, no one would like to help. The peoples that has Gunz 1.5 working server,
I know, they will not help.

If someone wanted to help. Please Generate Scripts your Database. So it will be more easy to help us.

Please help,
Right Click Database > Tasks > Generate Scripts. (scripts all object in the selected database > next next)

 

[Gun[Lengend]]

You are not add LogDB in SQL.
Add LogDB and make ODBC will fix this.
Sorry for my bad English.

 

[jorklenis2]

[02/17/12 09:20:14] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertTPLogNetmarble (1, 26)} ), ErrCode( -1 )
ErrMsg - No se encontró el procedimiento almacenado 'spInsertTPLogNetmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

what is these?

 

[discordaxe]

I'm having the same issue. Did anyone find a solution for this?

[01/06/18 17:57:56] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertTPLogNetmarble (2, 124)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spInsertTPLogNetmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

 

[jorklenis2]

I'm having the same issue. Did anyone find a solution for this?

[01/06/18 17:57:56] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spInsertTPLogNetmarble (2, 124)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spInsertTPLogNetmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

You need to add another thing DB called LogDB, you have to restore it too.

 

[discordaxe]

You need to add another thing DB called LogDB, you have to restore it too.

I have added that. Maybe I did it improperly? I added it just like the GunzDB- create new database, restore, add in odbc. When I did that it seemed to fix other errors, but not spInsertTPLogNetmarble. None of the DBs I've tried (jur13n or jork) have spInsertTPLogNetmarble.

 

[Arenbunny]

hum...

USE GunzDBGO
ALTER TABLE TPLogNetmarble ADD CCode INT DEFAULT(0);
CREATE PROCEDURE dbo.spInsertTPLogNetmarble-- ALTER PROCEDURE dbo.spInsertTPLogNetmarble	@CID		INT    	, @PlayTime INTAS BEGIN    	SET NOCOUNT ON;		DECLARE @DisTime DATETIME	SET @DisTime = GETDATE();
	INSERT TPLogNetmarble(StartDate, EndDate, UserID, CharacName, IP, PlayTime, Password, CCode)		SELECT DATEADD(ss, -@PlayTime, @DisTime) AS StartDate    				, @DisTime AS EndDate    				, a.UserID    				, ( SELECT Name FROM Character(NOLOCK) WHERE CID = @CID) AS CharacName    				, CAST(cl.IPPart1 AS VARCHAR(3)) + '.' + CAST(cl.IPPart2 AS VARCHAR(3)) + '.'     					+ CAST(cl.IPPart3 AS VARCHAR(3)) + '.' + CAST(cl.IPPart4 AS VARCHAR(3))    				, @PlayTime AS PlayTime    				, l.Password  				, a.CCode  		FROM Login l(NOLOCK)			, Account a(NOLOCK)    			, ( SELECT TOP 1 AID, IPPart1, IPPart2, IPPart3, IPPart4    				FROM LogDB.dbo.ConnLog    				WHERE AID IN (	SELECT	AID     								FROM	Character(NOLOCK)    								WHERE CID = @CID )    				ORDER BY Time DESC) AS cl    		WHERE a.AID = cl.AID   		AND  l.UserID = a.UserID;    END

 

[discordaxe]

hum...

I won't be able to try this for a few hours. It looks like this creates the procedure, is that correct? If so that's what I've been looking for. Strangely it hasn't been in any of the DBs I've tried and there's nothing here on Ragezone about it that I can find. Do you think this will fix my NAT issue seen here?