errors in ep 6 servers

[GMCronus]

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

 Spoiler

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

 Spoiler

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

 Spoiler

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

 Spoiler

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

ps_Game__System.Log

 Spoiler

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:-)

[Arby]

#moved

Also spoiler tagged it so it's easier to read.…

[wallerus]

Originally Posted by GMCronus

SET point=point+@LastPlayTime/0

Pulled that from your try_GameLogout-R proc. Dividing by zero is never good.

The bottom of your usp_Insert_Action_Log_E is also missing some code.

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

Notice how yours is missing the last row of code, from Value1 to Text4

[GMCronus]

first of thanks.

but idk why the gamlog_E is full just didnt set all here when i pasted it sorry.

how can i remove just SET point=point+@LastPlayTime/0 when the script is all about the same. isnt that going to mess up even more?

[wallerus]

Simply just remove the "/0" from that part of your script and it will work. Diving by zero, in math, returns an undefined value - as for SQL I can only assume it also doesn't do great things.

[GMCronus]

thanks. then many have this. not my script LOL but thanks alot