hi. i don't have server crash and so on but i have a few dc and stuff like that so i wanted to post my error log's here. many have some of the same issues so mabe that can fix stuff for many ppl idk sorry.
ps userlog
here is my try_GameLogout-R
the xxxx thing i checked against password, userid and character name but i can't find them so i have no idea but look like password or UserID or something like that so not sharing but xxxxx thing is not xxxx it's something that look like password or userID and it's ALOT of this
ps_GameLog_system
alot of this
Insert_Action_Log_E
ps_Game__System.Log
I get alot of this
if anyone can help please do:-)
ps userlog
Quote:
2016-04-19 02:22:36 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'xxxxxx' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)
2016-04-19 02:22:36 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 437184,4694467329759641601,5,'121'
2016-04-19 02:22:36 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'xxxxxx' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)
2016-04-19 02:22:36 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 437184,4694467329759641601,5,'121'
2016-04-19 02:23:53 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'xxxxxx' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)
2016-04-19 02:23:53 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 100159,4694459152141910017,1,'64'
2016-04-19 02:23:53 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'xxxxxx' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)
2016-04-19 02:23:53 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 100159,4694459152141910017,1,'64'
2016-04-19 02:24:23 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'xxxxxx' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)
2016-04-19 02:24:23 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 437550,4694446666671980545,1,'64'
2016-04-19 02:24:23 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'xxxxxx' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)
2016-04-19 02:24:23 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 437550,4694446666671980545,1,'64'
2016-04-19 02:25:32 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'xxxxxx' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)
2016-04-19 02:25:32 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436102,4694479999913164801,4,'64'
2016-04-19 02:25:32 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'xxxxxx' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)
2016-04-19 02:25:32 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436102,4694479999913164801,4,'64'
2016-04-19 02:27:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'xxxxxx' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)
2016-04-19 02:27:05 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 437475,4694479175279443969,4,'64'
2016-04-19 02:27:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'xxxxxx' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)
2016-04-19 02:27:05 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 437475,4694479175279443969,4,'64'
2016-04-19 02:28:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'xxxxxx' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)
2016-04-19 02:28:29 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 180992,4694472384936148993,5,'121'
here is my try_GameLogout-R
Quote:
USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogout_R] Script Date: 19.04.2016 14.56.42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.usp_Try_GameLogout_R Script Date: 2008-6-7 18:34:05 ******/
ALTER Proc [dbo].[usp_Try_GameLogout_R]
/*
Created by humanws, 2005-10-18
???? ?? ??
*/
@UserUID int,
@SessionID bigint,
@LogoutType smallint = 0,
@ErrType int = 0
AS
SET NOCOUNT ON
DECLARE @LogTime datetime
DECLARE @Sql nvarchar(4000)
DECLARE @yyyy varchar(4)
DECLARE @mm varchar(2)
DECLARE @dd varchar(2)
DECLARE @LogType bit -- Login:0, Logout:1
SET @LogType = 1
SET @LogTime = GETDATE()
SET @yyyy = DATEPART(yyyy, @LogTime)
SET @mm = DATEPART(mm, @LogTime)
SET @dd = DATEPART(dd, @LogTime)
IF( LEN(@mm) = 1 )
BEGIN
SET @mm = '0' + @mm
END
IF( LEN(@dd) = 1 )
BEGIN
SET @dd = '0' + @dd
END
UPDATE Users_Master SET Leave = 0, LeaveDate = GETDATE() WHERE UserUID = @UserUID
SET @Sql = N'
INSERT INTO PS_GameLog.dbo.UserLog
(SessionID, UserUID, LogType, LogTime, LogoutType, ErrType)
VALUES(@SessionID, @UserUID, @LogType, @LogTime, @LogoutType, @ErrType)'
EXEC sp_executesql @Sql,
N'@SessionID bigint, @UserUID int, @LogType bit, @LogTime datetime, @LogoutType smallint, @ErrType int',
@SessionID, @UserUID, @LogType, @LogTime, @LogoutType, @ErrType
update PS_userdata.dbo.UserLoginStatus
set loginstatus=0,LogoutTime=@LogTime,LogoutSession=@S essionID,LastPlayTime=datediff(minute,LoginTime,@L ogTime)
where useruid=@useruid
DECLARE @LoginTime datetime
DECLARE @LastPlayTime int
DECLARE @OldPoint int
DECLARE @LoginSession bigint
SET @LoginSession=(select LoginSession from PS_userdata.dbo.UserLoginStatus where useruid=@useruid)
SET @LastPlayTime=(select LastPlayTime from PS_userdata.dbo.UserLoginStatus where useruid=@useruid)
SET @LoginTime=(select LoginTime from PS_userdata.dbo.UserLoginStatus where useruid=@useruid)
SET @OldPoint=(select Point from PS_userdata.dbo.Users_Master where useruid=@useruid)
IF (@SessionID=@LoginSession)
BEGIN
Update PS_userdata.dbo.Users_Master
SET point=point+@LastPlayTime/0
WHERE useruid=@useruid
INSERT INTO PS_userdata.dbo.UserOnlineTimeLog(UserUid,OldPoint ,Addpoint,LoginTime,LogoutTime,SessionID)
values(@UserUid,@OldPoint,@LastPlayTime,@LoginTime ,@LogTime,@SessionID)
end
SET NOCOUNT OFF
the xxxx thing i checked against password, userid and character name but i can't find them so i have no idea but look like password or UserID or something like that so not sharing but xxxxx thing is not xxxx it's something that look like password or userID and it's ALOT of this
ps_GameLog_system
Quote:
2016-04-19 14:35:51 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 102) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)
2016-04-19 14:35:51 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'UserID',103980,141502,'CharName', 15,30280502,18, 576.572021,8.401419,395.736542, '2016-04-19 14:35:42' ,103, 391709,25304,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL,'CharName','kill=2719, death=103, win=3, lose=6',NULL,NULL
2016-04-19 14:36:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)
2016-04-19 14:36:37 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'UserID',78865,390941,'CharName', 15,30303104,18, 517.240295,5.432528,490.113251, '2016-04-19 14:36:35' ,103, 252585,35256,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL,'CharName','kill=60, death=21, win=0, lose=0',NULL,NULL
2016-04-19 14:37:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 241) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)
2016-04-19 14:37:24 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'UserID',103980,141502,'CharName', 15,30280552,18, 553.682129,3.070822,553.577576, '2016-04-19 14:37:22' ,103, 388455,11928,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL,'CharName','kill=2729, death=103, win=3, lose=6',NULL,NULL
alot of this
Insert_Action_Log_E
Quote:
USE [PS_GameLog]
GO
/****** Object: StoredProcedure [dbo].[usp_Insert_Action_Log_E] Script Date: 19.04.2016 15.09.48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[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,
@ActionTime datetime,
@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 @Leave BIT
SET @yyyy = datepart(yyyy, @ActionTime)
SET @mm = datepart(mm, @ActionTime)
SET @dd = datepart(dd, @ActionTime)
IF @ActionType = 116 -- Dupe fix
BEGIN
WAITFOR DELAY '00:00:05'
SET @Leave = (SELECT Leave FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
IF @Leave = 0 AND @Text2 NOT LIKE '(NPC)%'
BEGIN
DECLARE @oldCount TINYINT = (SELECT [Count] FROM PS_GameData.dbo.CharItems WHERE ItemUID = @Value1 AND CharID = @CharID)
DECLARE @newCount TINYINT = @oldCount - @Value4
IF @newCount = 0
BEGIN
DELETE FROM PS_GameData.dbo.CharItems
WHERE ItemUID = @Value1 AND CharID = @CharID
END
ELSE IF @newCount > 0
BEGIN
UPDATE PS_GameData.dbo.CharItems
SET [Count] = @newCount
WHERE ItemUID = @Value1 AND CharID = @CharID
END
END
END
ELSE IF @ActionType = 164 -- Dupe fix
BEGIN
WAITFOR DELAY '00:00:05'
SET @Leave = (SELECT Leave FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
IF @Leave = 0 AND @Text2 NOT LIKE '(NPC)%'
BEGIN
UPDATE PS_GameData.dbo.Chars
SET [Money] = @Value2
WHERE CharID = @CharID
END
END
IF (@ActionType = 114 and @Value2 = 100200)
Begin
Update PS_Userdata.dbo.Users_Master SET Point = Point + @Value4 * 100 WHERE UserID = @UserID
END
IF (@ActionType = 114 and @Value2 = 100211)
Begin
Update PS_Userdata.dbo.Users_Master SET Point = Point + @Value4 * 1000 WHERE UserID = @UserID
END
IF (@ActionType = 114 and @Value2 = 100213)
Begin
Update PS_Userdata.dbo.Users_Master SET Point = Point + @Value4 * 1000 WHERE UserID = @UserID
END
/**** Adding lotterytickets for the next draw ****/
-- DP_lottery
IF (@ActionType = 114 and @Value2 = 100215)
Begin
insert into [PS_GameData].dbo.LotteryTicketsActivated (UserID,CharID,Tickets,[ItemID])
select @UserID, @CharID, @Value4, @Value2
END
-- Gold_Lottery
IF (@ActionType = 114 and @Value2 = 100212)
Begin
insert into [PS_GameData].dbo.LotteryTicketsActivated (UserID,CharID,Tickets,[ItemID])
select @UserID, @CharID, @Value4, @Value2
END
/* End of Adding lotterytickets for the next draw */
/***** Start - Playing in the 60 PVP area with a Character level above 60 *****/
IF (@CharLevel > 60 and @MapID = 25)
Begin
-- The Account Ban
Update PS_Userdata.dbo.Users_Master SET Status = -5, ModiIp = 'Illegal Zone' WHERE UserID = @UserID
-- The IP Ban
/******** Not in Action *********
insert into [PS_UserData].[dbo].[BannedIPs] (banIP, Comment)
select [UserIp], 'Highlevel in map25' from PS_Userdata.dbo.Users_Master WHERE UserID = @UserID
********* End Not In Action *****/
END
/***** End - Playing in the 60 PVP area with a Character level above 60 *****/
IF (@ActionType = 103)
begin
Update PS_Userdata.dbo.Users_Master SET Point = Point + 5 WHERE UserID = @UserID
END
/***** Start Illegal link in lower gears ****/
IF (@ActionType = 119 )
Begin
declare @ValidLapis as int
set @ValidLapis = ( select case when item.Reqlevel - lapis.ReqInt < 0 then 1 else 0 end as 'LevelDiff'
from [PS_GameDefs].[dbo].[Items] item
inner join [PS_GameDefs].[dbo].[Items] lapis on item.ItemID = @Value2 and Lapis.ItemID = @Value3
)
IF (@ValidLapis = 1 )
Begin
-- update [PS_GameData].[dbo].[CharItems]
-- set Gem1 = 0, Gem2 = 0, Gem3 = 0, Gem4 = 0, Gem5 = 0, Gem6 = 0, CraftName = ''
-- where ItemUID = @Value1
update [PS_GameData].[dbo].[CharItems]
set Del = 1
where ItemUID = @Value1
update [PS_GameData].[dbo].[UserStoredItems]
set Del = 1
where ItemUID = @Value1
Update PS_Userdata.dbo.Users_Master SET Status = -5, ModiIp = 'Illegal Lapis' WHERE UserID = @UserID
END
END
/***** End Illegal link in lower gears ****/
/* Reset EXP on 60 PvP Zone */
IF (@ActionType=108 and @MapID in (25) and @CharLevel in(60) )
BEGIN
Update PS_GameData.dbo.Chars
SET Exp = 0
Where CharID = @CharID and Map in(25)
END
ELSE IF (@ActionType = 104)
BEGIN
DECLARE @FeederIP varchar(15) = (Select TOP 1 UserIP From PS_UserData.dbo.UserLogStatPad WHERE UserUID=@UserUID ORDER BY LoginTime DESC)
DECLARE @KillerUID int = (Select UserUID From PS_GameData.dbo.Chars Where CharID = @Value1)
DECLARE @KillerIP varchar(15) = (Select TOP 1 UserIP From PS_UserData.dbo.UserLogStatPad WHERE UserUID=@KillerUID ORDER BY LoginTime DESC)
IF @FeederIP = @KillerIP
BEGIN
INSERT INTO StatPad (KillerCharID, FeederCharID) VALUES (@Value1, @CharID)
END
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,
@V
Quote:
2016-04-19 14:02:10 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3300)
2016-04-19 14:02:10 discon client: ( 5, 121) T=001:22:00:000, RC=881,RCS=0, RB=13653,RBS=2, SC=15495,SCS=3, SB=332187,SBS=67
2016-04-19 14:02:21 ## CheckRecv 124, 166177, 4, 30
2016-04-19 14:02:21 discon client: ( 16, 1236) T=000:01:00:000, RC=260,RCS=2, RB=2263,RBS=24, SC=299,SCS=3, SB=47350,SBS=514
2016-04-19 14:03:28 1 1 SWorker::Run():m_iocp.GetStatus() 121 (916)
2016-04-19 14:03:28 discon client: ( 5, 121) T=000:01:00:000, RC=17,RCS=0, RB=273,RBS=4, SC=361,SCS=5, SB=38078,SBS=559
2016-04-19 14:04:57 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2716)
2016-04-19 14:04:57 discon client: ( 5, 121) T=001:17:00:000, RC=6093,RCS=1, RB=91750,RBS=19, SC=29922,SCS=6, SB=669529,SBS=143
2016-04-19 14:04:59 InsZone Count : CurAll(1), GuildHouse(cur=1,max=3), GuildRank(cur=0,max=0), Party(cur=0,max=0)
2016-04-19 14:10:31 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3096)
2016-04-19 14:10:31 discon client: ( 5, 121) T=000:15:00:000, RC=1262,RCS=1, RB=17601,RBS=18, SC=7871,SCS=8, SB=207699,SBS=217
2016-04-19 14:10:34 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4048)
2016-04-19 14:14:05 ## CheckRecv 104, 250811, 4, 90
2016-04-19 14:14:05 discon client: ( 16, 1236) T=005:43:00:000, RC=85010,RCS=4, RB=965929,RBS=46, SC=152162,SCS=7, SB=2506271,SBS=121
2016-04-19 14:14:49 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4048)
2016-04-19 14:14:49 discon client: ( 5, 121) T=000:01:00:000, RC=1,RCS=0, RB=24,RBS=0, SC=33,SCS=0, SB=753,SBS=10
2016-04-19 14:17:09 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3884)
2016-04-19 14:17:09 discon client: ( 5, 121) T=002:49:00:000, RC=7614,RCS=0, RB=78582,RBS=7, SC=43281,SCS=4, SB=938914,SBS=92
2016-04-19 14:23:59 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3756)
2016-04-19 14:23:59 discon client: ( 5, 121) T=001:13:00:000, RC=8030,RCS=1, RB=102386,RBS=23, SC=74242,SCS=16, SB=1442840,SBS=325
2016-04-19 14:26:26 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2952)
2016-04-19 14:26:26 discon client: ( 5, 121) T=000:34:00:000, RC=3879,RCS=1, RB=56500,RBS=26, SC=67715,SCS=32, SB=1338017,SBS=638
2016-04-19 14:31:09 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3256)
2016-04-19 14:31:09 discon client: ( 5, 121) T=003:05:00:000, RC=9970,RCS=0, RB=92523,RBS=8, SC=52257,SCS=4, SB=1196499,SBS=107
2016-04-19 14:31:45 1 1 SWorker::Run():m_iocp.GetStatus() 121 (-1)
2016-04-19 14:35:23 ## CheckRecv 112, 392369, 4, 9
2016-04-19 14:35:23 discon client: ( 16, 1236) T=000:00:00:000, RC=1845,RCS=34, RB=14872,RBS=275, SC=1875,SCS=34, SB=34632,SBS=641
2016-04-19 14:40:25 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3132)
2016-04-19 14:40:25 discon client: ( 5, 121) T=000:35:00:000, RC=1665,RCS=0, RB=16453,RBS=7, SC=3587,SCS=1, SB=118064,SBS=55
2016-04-19 14:44:12 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3264)
2016-04-19 14:44:12 discon client: ( 5, 121) T=001:00:00:000, RC=2679,RCS=0, RB=33368,RBS=9, SC=74917,SCS=20, SB=1627730,SBS=444
I get alot of this
if anyone can help please do:-)