PS_DBAGENT__system log ERROR !

[KILLSTEAL]

2010-05-29 20:22:44 PS_DBAGENT__system log start (DBAgent01)

2010-05-29 20:22:45 connect game, Name=



2010-05-29 20:22:45 connect game, Name=



2010-05-29 20:22:47 connect game, Name=



2010-05-31 12:19:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]In 'sysdatabases' wurde kein Eintrag für die 'Billcrux30'-Datenbank gefunden. Es wurde kein Eintrag mit diesem Namen gefunden. Stellen Sie sicher, dass der Name richtig eingegeben wurde., SQL STATE: 08004, NATIVE ERROR: 911 (0x38F)

2010-05-31 12:19:11 SaveGiftPointItem 811 .TestUser. qerr=**** {? = call [usp_Save_User_NCash](389,390,'B1_Cface0001')}

-----------------------------------------------------------------
In English:

2010-05-29 20:22:44 PS_DBAGENT__system start log (DBAgent01)

2010-05-29 20:22:45 game connect, name =



2010-05-29 20:22:45 game connect, name =



2010-05-29 20:22:47 game connect, name =



2010-05-31 12:19:11 err =- 1, [Microsoft] [ODBC SQL Server Driver] [SQL Server] In 'sysdatabases' no entry was for the' Billcrux30' database found. There was no entry with that name found. Make sure that the name is spelled correctly., SQL STATE: 08 004, NATIVE ERROR: 911 (0x38F)

2010-05-31 12:19:11 SaveGiftPointItem 811th Test User. Qerr = **** (? = Call [usp_Save_User_NCash] (389.390, 'B1_Cface0001'))

[MentaL]

[Twilight]

tomorrow fix...
Zzzzzz...

[Twilight]

Carefully
These procedures test.
If the test succeeds then move to section [Fix]
The result of the procedures, see PS_GameData -> PointErrorLog table.

[KILLSTEAL]

Carefully
These procedures test.
If the test succeeds then move to section [Fix]
The result of the procedures, see PS_GameData -> PointErrorLog table.

Ok i will Test

thx a lot

P.S i think it works fine here the ErrorLog table.

304 NULL B1_Bcall0005 100 28.05.2010 10:25:13
344 NULL B1_Sroul0005 100 29.05.2010 02:04:27
378 NULL B1_Bcall0005 100 29.05.2010 02:04:35
378 NULL B1_Bcall0005 100 29.05.2010 02:05:58
389 NULL B1_Cface0001 100 31.05.2010 12:19:11
358 NULL B1_Misun0001 100 01.06.2010 15:29:38
378 NULL B1_Bcall0005 100 29.05.2010 02:03:02
378 NULL B1_Bcall0005 100 29.05.2010 02:03:43
378 NULL B1_Bcall0005 100 29.05.2010 02:04:06
358 NULL B1_Misun0001 100 01.06.2010 15:30:24
NULL NULL NULL NULL NULL

i test it out foe few days. The we{you can set it too [Fix]

---------- Post added at 06:09 PM ---------- Previous post was at 05:49 PM ----------

hmm damnit

Now i found this Error

2010-06-01 20:05:47 err=-1, [Microsoft][ODBC SQL Server Driver]Timeout abgelaufen, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2010-06-01 20:05:47 SaveGiftPointItem 9 [GM]-KAMPFSAU qerr=**** {? = call [usp_Save_User_NCash](1,3,'B1_Nosko0001')}


in English:

2010-06-01 20:05:47 err =- 1, [Microsoft] [ODBC SQL Server Driver] Timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2010-06-01 20:05:47 SaveGiftPointItem 9 [GM] KAMPFSAU Qerr = **** (? = Call [usp_Save_User_NCash] (1,3, 'B1_Nosko0001'))

in PS_DBAGENT_system.log

[Twilight]

Next proc error? =}
Wait 15 minutes.
I'll write another check and fix ..

[KILLSTEAL]

Next proc error? =}
Wait 15 minutes.
I'll write another check and fix ..

Ok

and that was the new error after the fix to test sendGift

[Twilight]

try new test

[KILLSTEAL]

try new test

hmm now this Error

2010-06-01 22:21:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ungültiger Objektname 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-01 22:21:02 SaveGiftPointItem 9 [GM]-KAMPFSAU qerr=**** {? = call [usp_Save_User_NCash](1,3,'B1_Nosko0001')}

in English:

2010-06-01 22:21:02 err =- 1, [Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-01 22:21:02 SaveGiftPointItem 9 [GM] KAMPFSAU Qerr = **** (? = Call [usp_Save_User_NCash] (1,3, 'B1_Nosko0001'))

[Twilight]

in Billcrux30 -> procRequestOrderProductByGame
find string

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PointLog WHERE (UserUID = @receiveClientUserNumber)

change

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PS_GameData.dbo.PointLog WHERE (UserUID = @receiveClientUserNumber)

or

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PS_GameData.PointLog WHERE (UserUID = @receiveClientUserNumber)

and try again..

[KILLSTEAL]

in Billcrux30 -> procRequestOrderProductByGame
find string

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PointLog WHERE (UserUID = @receiveClientUserNumber)

change

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PS_GameData.dbo.PointLog WHERE (UserUID = @receiveClientUserNumber)

or

SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PS_GameData.PointLog WHERE (UserUID = @receiveClientUserNumber)

and try again..

Both dont work same Error again:

2010-06-02 09:49:38 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ungültiger Objektname 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:49:38 SaveGiftPointItem 9 [GM]-KAMPFSAU qerr=**** {? = call [usp_Save_User_NCash](1,3,'B1_regem0001')}

2010-06-02 09:49:58 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ungültiger Objektname 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:49:58 SaveGiftPointItem 9 [GM]-KAMPFSAU qerr=**** {? = call [usp_Save_User_NCash](1,3,'B1_inche0005')}

2010-06-02 09:50:56 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ungültiger Objektname 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:50:56 SaveGiftPointItem 9 [GM]-KAMPFSAU qerr=**** {? = call [usp_Save_User_NCash](1,3,'PK_remed0002')}

In English:

2010-06-02 09:49:38 err =- 1, [Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:49:38 SaveGiftPointItem 9 [DA]-KAMPFSAU Qerr 100 = (? = Call [usp_Save_User_NCash] (1,3, 'B1_regem0001'))

2010-06-02 09:49:58 err =- 1, [Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:49:58 SaveGiftPointItem 9 [GM] KAMPFSAU Qerr = **** (? = Call [usp_Save_User_NCash] (1,3, 'B1_inche0005'))

2010-06-02 09:50:56 err =- 1 [Microsoft] [ODBC SQL Server Driver] [SQL Server] Invalid object name 'PointLog'., SQL STATE: 42S02, NATIVE ERROR: 208 (0xD0)

2010-06-02 09:50:56 SaveGiftPointItem 9 [GM] KAMPFSAU Qerr = **** (? = Call [usp_Save_User_NCash] (1,3, 'PK_remed0002'))

[Twilight]

Ok.
use sql query for test:

use PS_GameData;
exec usp_Save_User_NCash 1,3,'B1_regem0001';

Error?

[KILLSTEAL]

Ok.
use sql query for test:

use PS_GameData;
exec usp_Save_User_NCash 1,3,'B1_regem0001';

Error?

Msg 208, Level 16, State 1, Procedure procRequestOrderProductByGame, Line 35
Ungültiger Objektname 'PointLog'.

In English:

Msg 208, Level 16, State 1, Procedure procRequestOrderProductByGame, Line 35
Invalid object name 'PointLog'.

[Twilight]

Insert here your the text of its procedures procRequestOrderProductByGame
possible error

[KILLSTEAL]

Insert here your the text of its procedures procRequestOrderProductByGame
possible error

set ANSI_NULLS OFF
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[procRequestOrderProductByGame] 
@buyClientUserNumber               BIGINT,
@receiveClientUserNumber           BIGINT,
@itemCode                          VARCHAR(50),
@resultCode                        SMALLINT               OUTPUT,
@cashBalanceAfterOrder             INT                          OUTPUT,
@orderNumber                  INT            OUTPUT
AS

DECLARE @CheckUserBy BIGINT
DECLARE @CheckUserReceive BIGINT

--print @receiveClientUserNumber

SELECT @CheckUserBy = UserUID FROM Chars WHERE  UserUID = @buyClientUserNumber AND Del = 0
SELECT @CheckUserReceive = UserUID FROM Chars WHERE  UserUID = @receiveClientUserNumber AND Del = 0
--/Check EMPTY ITEMS/
IF(@itemCode  = '0' OR @itemCode IS NULL)
BEGIN
    SET @resultCode = 1 --if item empty code return error 1
    RETURN @resultCode
END

--/Check USERS/
IF( @CheckUserBy = 0 OR @CheckUserReceive IS NULL ) OR ( @CheckUserReceive = 0 OR @CheckUserBy  IS NULL )
BEGIN
    
    SET @resultCode = 2 --if users not present return error 2
    RETURN @resultCode
END

ELSE
BEGIN
SELECT     @cashBalanceAfterOrder = RemainPoint,@orderNumber = OrderNumber FROM  PS_GameData.PointLog WHERE (UserUID = @receiveClientUserNumber)

IF ( @cashBalanceAfterOrder = 0 OR @cashBalanceAfterOrder IS NULL ) OR (@cashBalanceAfterOrder < 0)
    BEGIN
    SET @resultCode = 6 --if remain money 0   Hack?
    RETURN @resultCode
END


-- ALL ERRORS CHECK----------
IF @@ERROR <> 0 
    BEGIN
    SET @resultCode = 5 --if sql query return error...return error
    RETURN @resultCode
END
ELSE
    BEGIN
    SET @resultCode = 0
    RETURN @resultCode  -- return ok
RETURN @cashBalanceAfterOrder
RETURN @orderNumber
 
   END

END 

Msg 201, Level 16, State 4, Procedure procRequestOrderProductByGame, Line 0
Die Prozedur oder Funktion 'procRequestOrderProductByGame' erwartet den '@buyClientUserNumber'-Parameter, der nicht bereitgestellt wurde.

(1 row(s) affected)

(1 row(s) affected)

In English:

Msg 201, Level 16, State 4, Procedure procRequestOrderProductByGame, Line 0
The procedure or function 'procRequestOrderProductByGame expects' the' @ buyClientUserNumber' parameter that was not provided.

(1 row (s) affected)

(1 row (s) affected)

[Twilight]

exec.. sql query

SELECT * FROM  PS_GameData.dbo.PointLog

Error?