problem of succession item

12/28/2012 15:12 yukolo#1
Hi I've built the problem [Only registered and activated users can see links. Click Here To Register...]
I was led here, everything was working just fine after I applied the subject began to take an item repeatedly take 5 or 6 of the item whether disconnet error about throwing me off, but still the same error that has committed this code göndriyorum I maybe you can help me with my file log

Quote:
2012-12-28 15:52:58 PS_GAMELOG__system log start (GameLog01)

Module list:

D:\ShaiyaServer\PSM_Client\Bin\ps_gameLog.exe, loaded at 0x00400000 - 10/10/18 16:33:52

2012-12-28 15:53:03 connect game

2012-12-28 15:53:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '238227711319207620000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-28 15:53:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '238227711319207620000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-28 15:53:29 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,80,'', 34485,-897659584,23876, -238227711319207620000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,107, 0,1040187392,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL, '0.0.0.0','money=184549377, bank=117444096, cash=167774720','level=0,skp=3328,stp=32512','s=0, d=19201,i=0,w=0,r=0,l=0'

2012-12-28 15:53:29 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,80,'', 34485,-897659584,23876, -238227711319207620000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Enter',NULL,NULL,NULL

2012-12-28 15:53:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:53:43 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,-1915224064,' Ø ØK', 34485,-897659584,27460, 0.000000,0.000000,0.000000, '2015-08-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Leave',NULL,NULL,NULL

2012-12-28 15:53:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:53:43 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,-1915224064,' Ø ØK', 34485,-897659584,27460, 0.000000,0.000000,0.000000, '2015-08-00 00:00:00' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=184549377, bank=117444096, cash=167774720','level=783,skp=3328,stp=19200','s= 0,d=0,i=0,w=256,r=75,l=76'

2012-12-28 15:54:48 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '238227711319207620000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-28 15:54:48 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,80,'', 34485,-897659584,45124, -238227711319207620000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,107, 0,1040187392,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL, '0.103.109.108','money=184549377, bank=117444096, cash=167774720','level=26473,skp=3328,stp=32512',' s=0,d=19201,i=19456,w=3840,r=259,l=0'

2012-12-28 15:54:48 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '238227711319207620000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-28 15:54:48 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,80,'', 34485,-897659584,45124, -238227711319207620000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Enter',NULL,NULL,NULL

2012-12-28 15:55:40 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:55:40 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,9508,'', 34485,-897659584,59460, 0.000000,-2417925426205553200000000.000000,-751714112.000000, '2020-12-00 00:06:06' ,113, 5917857872076962149,16543484,NULL,255,NULL,NULL,NU LL,NULL,NULL,NULL,'','PointItem','0,0,0,0,0,0 (Option:)','2000-00-00 00:00:00'

2012-12-28 15:55:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:55:43 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,9508,'', 34485,-897659584,60228, 0.000000,-154747227277155400000000000.000000,179.222610, '2013-12-00 00:06:07' ,113, 2336238374370436896,1819173187,NULL,28,NULL,NULL,N ULL,NULL,NULL,NULL,'and?rma Rünü','PointItem','0,0,0,0,0,0 (Option:)','2000-00-00 00:00:00'

2012-12-28 15:55:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:55:45 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,9508,'', 34485,-897659584,60740, 0.000000,-2475955636434486500000000000.000000,-187928528.000000, '2015-12-00 00:06:06' ,113, 7997357336760041313,252,NULL,255,NULL,NULL,NULL,NU LL,NULL,NULL,'','PointItem','0,0,0,0,0,0 (Option:)','2000-00-00 00:00:00'

2012-12-28 15:55:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:55:47 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,9508,'', 34485,-897659584,61252, 0.000000,-2476031194298212400000000000.000000,-49264336044032.000000, '2017-00-00 00:06:06' ,113, -256990699051847579,0,NULL,28,NULL,NULL,NULL,NULL,N ULL,NULL,'','PointItem','0,0,0,0,0,0 (Option:)','2000-00-00 00:00:00'

2012-12-28 15:55:49 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:55:49 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,9508,'', 34485,-897659584,61764, 0.000000,-633844642927228530000000000000.000000,-3006856448.000000, '2022-04-00 00:06:06' ,113, 7800060016268504677,1063743073,NULL,255,NULL,NULL, NULL,NULL,NULL,NULL,'? Ta??','PointItem','0,0,0,0,0,0 (Option:)','2000-00-00 00:00:00'

2012-12-28 15:55:52 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:55:52 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,9508,'', 34485,-897659584,62532, 0.000000,-40566057147342626000000000000000.000000,-12027425792.000000, '2021-04-00 00:06:06' ,113, 7013266122542970222,16191,NULL,28,NULL,NULL,NULL,N ULL,NULL,NULL,'','PointItem','0,0,0,0,0,0 (Option:)','2000-00-00 00:00:00'

2012-12-28 15:55:56 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '10384910629719712000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-28 15:55:56 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,9508,'', 34485,-897659584,63556, 0.000000,-10384910629719712000000000000000000.000000,-206629601726827590000.000000, '2018-04-00 00:06:06' ,113, 7020388758850518847,1063343136,NULL,255,NULL,NULL, NULL,NULL,NULL,NULL,'? ','PointItem','0,0,0,0,0,0 (Option:)','2000-00-00 00:00:00'

2012-12-28 15:55:58 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '166158570075515400000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-28 15:55:58 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,9508,'', 34485,-897659584,64068, 0.000000,-166158570075515400000000000000000000.000000,0.0000 00, '2016-08-00 00:06:07' ,113, 5269339581520232289,1819164479,NULL,28,NULL,NULL,N ULL,NULL,NULL,NULL,'anma Ta??','PointItem','0,0,0,0,0,0 (Option:)','2000-00-00 00:00:00'

2012-12-28 15:56:00 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:56:00 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,9508,'', 34485,-897659584,68, 0.000000,0.000000,0.000000, '2018-12-00 00:06:07' ,113, 8241938334698532961,1226850111,NULL,255,NULL,NULL, NULL,NULL,NULL,NULL,'??nlanma Ta??','PointItem','0,0,0,0,0,0 (Option:)','2000-00-00 00:00:00'

2012-12-28 15:56:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:56:02 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,9508,'', 34485,-897659584,580, 0.000000,0.000000,0.000000, '2016-04-00 00:06:07' ,113, 4557441751344637298,1851878510,NULL,28,NULL,NULL,N ULL,NULL,NULL,NULL,'ma Ta??','PointItem','0,0,0,0,0,0 (Option:)','2000-00-00 00:00:00'

2012-12-28 15:56:06 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:56:06 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,9508,'', 34485,-897659584,1604, 0.000000,0.000000,-846354920730679860000000.000000, '2016-12-00 00:06:06' ,113, 2338605678646750825,1064460624,NULL,255,NULL,NULL, NULL,NULL,NULL,NULL,'omeni','PointItem','0,0,0,0,0 ,0 (Option:)','2000-00-00 00:00:00'

2012-12-28 15:56:06 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:56:06 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,-245891072,'±€šu´ğK', 34485,-897659584,1604, 0.000000,0.000000,0.000000, '2015-08-00 00:00:00' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=184549377, bank=117444096, cash=167774720','level=0,skp=3328,stp=19200','s=0, d=0,i=0,w=0,r=0,l=0'

2012-12-28 15:56:06 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-28 15:56:06 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,-245891072,'±€šu´ğK', 34485,-897659584,1604, 0.000000,0.000000,0.000000, '2015-08-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Leave',NULL,NULL,NULL
12/28/2012 15:54 R0CK7Y#2
Quote:
2012-12-28 15:53:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '238227711319207620000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)
i think your log is your answer..



check at the this post too..
were in your prev post
Quote:
Originally Posted by peripher View Post
Microsoft][ODBC SQL Server Driver][SQL Server]The number '237991015599133000000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)
Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

The number is to big for datatyp: tinyint, please check your stored procedures/Database.

usp_Insert_Action_Log_E <-

Code:
USE PS_GameLog; GO drop procedure [dbo].[usp_Insert_Action_Log_E] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO /****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E ******/ CREATE Proc usp_Insert_Action_Log_E @UserID varchar(18), @UserUID int, @CharID int, @CharName varchar(50), @CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTimeZ varchar(50), @ActionType tinyint, @Value1 bigint = null, @Value2 int = null, @Value3 int = null, @Value4 bigint = null, @Value5 int = null, @Value6 int = null, @Value7 int = null, @Value8 int = null, @Value9 int = null, @Value10 int = null, @Text1 varchar(100) = '', @Text2 varchar(100) = '', @Text3 varchar(100) = '', @Text4 varchar(100) = '', @Sql nvarchar(4000) = '', @yyyy varchar(4) = '', @mm varchar(2) = '', @dd varchar(2) = '', @Bucket smallint = -1 AS DECLARE @ActionTime as datetime SELECT @ActionTime = CONVERT(datetime, @ActionTimeZ, 120) SET @yyyy = datepart(yyyy, @ActionTime) SET @mm = datepart(mm, @ActionTime) SET @dd = datepart(dd, @ActionTime) IF(LEN(@mm) = 1) BEGIN SET @mm = '0' + @mm END IF(LEN(@dd) = 1) BEGIN SET @dd = '0' + @dd END SET @Sql = N' INSERT INTO PS_GameLog.dbo.ActionLog (UserID, UserUID, CharID, CharName, CharLevel, CharExp, MapID, PosX, PosY, PosZ, ActionTime, ActionType, Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8, Value9, Value10, Text1, Text2, Text3, Text4) VALUES(@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, @Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4)' EXEC sp_executesql @Sql, N'@UserID varchar(18), @UserUID int, @CharID int, @CharName varchar(50), @CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint, @Value1 bigint, @Value2 int, @Value3 int, @Value4 bigint, @Value5 int, @Value6 int, @Value7 int, @Value8 int, @Value9 int, @Value10 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)', @UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, @Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4 GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
12/28/2012 16:47 yukolo#3
What do I need to become anxious clients need to solve this problem would be grateful to you folks a little help please