Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
problem of succession item problem of succession item
You last visited: Today at 11:56

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

problem of succession item

Discussion on problem of succession item within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2011
Posts: 61
Received Thanks: 4
problem of succession item

Hi I've built the problem
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
yukolo is offline  
Old 12/28/2012, 15:54   #2
 
R0CK7Y's Avatar
 
elite*gold: 10
The Black Market: 2/0/0
Join Date: Apr 2010
Posts: 493
Received Thanks: 397
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
R0CK7Y is offline  
Thanks
3 Users
Old 12/28/2012, 16:47   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2011
Posts: 61
Received Thanks: 4
What do I need to become anxious clients need to solve this problem would be grateful to you folks a little help please
yukolo is offline  
Reply

« Private Single player server Help please | Items don't work.. »

Similar Threads Similar Threads
Item icon gone when adding new item (ItemMinIcon Problem)
04/13/2012 - EO PServer Hosting - 0 Replies
When i adding new casual for my new quest,and try to login to my Test server for checking it all item icon are gone.I really confident this problem was cause by ItemMinIcon.ani,why im saying that? cause when i move the item from ItemMinIcon.ani the problem solve...but the casual dont have icon...i bet some of ElitePvpers member know especially TheFlames ;) (Im Using Client Flames LOL) Screenshot: Item that i add (Casual) :
[Problem]Item.epk und item.eix
08/17/2011 - Metin2 Private Server - 0 Replies
Hi Leute, ich suche eine aktuelle item.epk und eix, weil meine nicht mehr funzt weil ich außerversehen was gelöscht habe. Dummerweise hatte ich vergessen ein backup zu machen. Könnte mir da einer bitte helfen?
[Suche] Komplette item.eix/epk, icon.eix/epk, item proto und item list
12/25/2010 - Metin2 Private Server - 6 Replies
Hey =) Wie die Überschrift schon sagt, suche ich eine komplette item.eix/epk, icon.eix/epk, item proto und item list am liebsten noch von den Waffen von .darki und den ganzen neuen Rüstungen/Schilden/Helmen, da ich überhaupt nicht weiß wie man dass zB mit der item proto macht und wenn ich sie einfach nur ersetze, wie zB durch die "Waffen" item proto von .darki sind die ganzen neuen Rüstungen weg .... Ich hoffe irgendjemand könnte das machen, weil es bestimmt nicht nur für mich hilfreich ist...
Problem mit Modden der item.eix / item.epk
06/27/2010 - Metin2 Private Server - 3 Replies
Also, folgendes Problem: Wenn ich die item.eix und item.epk in den FA Ordner tu und dann die item_extract.xml auf die m2.exe ziehe, scheint erstmal alles normal, aber während des Ladens kommt ein Windows-Meldefenster "m2.exe funktioniert nicht mehr." Dann muss ich schließen. (auffällig ist auch, dass die zwei Dateien eix und epk nicht verschwinden.) Ich schaue in den Source Ordner -> ymir work und es ist trotzdem ein item Ordner da.. Na gut, dann dachte ich mir nichts bei und habe aus dem...



All times are GMT +1. The time now is 11:58.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.