shaiya server error:[Realy need help]

04/12/2012 14:22 Svinseladden#1
server is working and all this but i keep getting errors. anyone know what this is?
PS_Userlog
Quote:
2012-04-11 03:49:47 PS_USERLOG__system log start (UserLog)

2012-04-11 03:49:59 connect

2012-04-11 03:50:05 connect

2012-04-11 03:50:08 connect

2012-04-12 02:49:45 err=-1, [Microsoft][ODBC SQL Server Driver]Unspecified error occurred on SQL Server. Connection may have been terminated by the server., SQL STATE: HY000, NATIVE ERROR: 0 (0x0)

2012-04-12 02:49:45 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 19477,3537615805522903041,1,'64'

2012-04-12 02:49:45 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-04-12 02:49:45 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 19477,3537615805522903041,1,'64'

2012-04-12 02:49:59 VerifyReConnect : The Connection has been lost, SQLHDBC=a42548

2012-04-12 02:50:00 SDatabasePool::Reconnect:: success...

2012-04-12 03:59:44 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-04-12 03:59:44 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-04-12 03:59:44 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 16899,3537639414958129153,4,'64'

2012-04-12 03:59:44 VerifyReConnect : The Connection has been lost, SQLHDBC=32ab18

2012-04-12 03:59:44 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 8775,3537643976213397505,4,'64'

2012-04-12 03:59:44 VerifyReConnect : The Connection has been lost, SQLHDBC=32a510

2012-04-12 03:59:44 SDatabasePool::Reconnect:: success...

2012-04-12 03:59:44 SDatabasePool::Reconnect:: success...
PS_Session:


Quote:
2012-04-11 03:49:59 PS_SESSION__system log start (Session)

2012-04-11 03:50:05 connect game

2012-04-11 03:50:08 connect login

2012-04-11 03:51:16 [The Myth Of Shaiya] NewUser Enter : Char=xxxx, Lv=15, Map=42, X=45.5, Z=44.6

2012-04-11 03:51:19 [The Myth Of Shaiya] NewUser Enter : Char=xxxx, Lv=80, Map=68, X=1073.2, Z=1040.8
why does this come in ps-session log? is this right? goes on and on with this..

PS_Loggin

Quote:
2012-04-11 03:50:08 PS_LOGIN__system log start (Login01)

2012-04-11 03:50:11 <Console input> /vchkoff

2012-04-11 03:50:11 <Console output> cmd version chk off ok

2012-04-11 04:16:51 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1192)

2012-04-11 04:50:18 cmd_auto server info log

user = 0 (0/5000)

2012-04-11 04:50:18 T=001:00:00:000, NumC=0,CMin=0,CMax=10,CAvg=1.00, CAva=152,CReq=152,CCnt=152,DCCnt=152, CTimeT=001:55:00:000,CTimeAvg=000:00:00:000, RBT=29967,RBS=8,RBSC=4,SBT=41367,SBS=11,SBSC=5

2012-04-11 04:50:18 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-04-11 05:50:18 cmd_auto server info log

user = 1 (0/5000)

2012-04-11 05:50:18 T=002:00:00:000, NumC=1,CMin=0,CMax=10,CAvg=1.00, CAva=253,CReq=253,CCnt=253,DCCnt=252, CTimeT=002:58:00:000,CTimeAvg=000:00:00:000, RBT=50492,RBS=7,RBSC=4,SBT=69448,SBS=9,SBSC=6

2012-04-11 05:50:18 SContext=3(1021/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=3(1021/1024)

Ps_Gamelog:

Quote:
2012-04-11 03:49:47 PS_GAMELOG__system log start (GameLog01)

2012-04-11 03:50:05 connect game

2012-04-11 03:52:03 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-04-11 03:52:03 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'xxx',7444,17037,'xxx', 80,-1,42, 85.896126,2.055258,53.841187, '2012-04-11 03:52:03' ,220, 3534459945158443008, 44096,210213,1,22,10,NULL,NULL,NULL,NULL,'Land's Tear ','0,0,0,0,0,0 (Option:)','2012-04-06 14:50:26',NULL

2012-04-11 03:52:04 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-04-11 03:52:04 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'xxx',7444,17037,'xxx', 80,-1,42, 85.896126,2.055258,53.841187, '2012-04-11 03:52:04' ,220, 3534460232921055232, 44096,210214,1,23,10,NULL,NULL,NULL,NULL,'Land's Tear ','0,0,0,0,0,0 (Option:)','2012-04-06 14:51:27',NULL

Ps_Game_Systemlog:

Quote:
2012-04-11 03:51:19 error exp over usern=xxx,charn=xxx, level=80,exp=-1,exppn=0

2012-04-11 03:51:21 error exp over usern=xxx,charn=xxx, level=80,exp=-1,exppn=0

2012-04-11 03:51:34 error exp over usern=xxx,charn=xxx., level=80,exp=-1,exppn=0
PS_Dbagent:

Quote:

2012-04-11 11:47:21 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'PS_NCASH' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411 (0x1CF3)

2012-04-11 11:47:21 SaveGiftPointItem 26763 -Vereesa qerr=100, {? = call [usp_Save_User_NCash](17180,2110,'B1_Reman0001')}

2012-04-11 20:58:57 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'PS_Billing' is being recovered. Waiting until recovery is finished., SQL STATE: 42000, NATIVE ERROR: 922 (0x39A)

2012-04-11 20:58:57 ::LoadBillingItem 19464 qerr=-1, EXEC usp_Read_Char_Product_Item_E 19464

2012-04-12 02:49:50 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-04-12 02:49:50 VerifyReConnect : The Connection has been lost, SQLHDBC=956090

2012-04-12 02:49:51 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-04-12 02:49:51 ::SaveCharacter 26740 .xxxx. ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(26740,80,0,57,632,100,10,7,10 ,100,26009,3754,22441,42,273,-1,1352790,'84.677353','2.055258','53.387760', 0,200,0,0,0, 271,104,14,5, 2,2)}

2012-04-12 02:49:51 VerifyReConnect : The Connection has been lost, SQLHDBC=3f700

2012-04-12 02:49:52 SDatabasePool::Reconnect:: success...

2012-04-12 02:49:52 SDatabasePool::Reconnect:: success...

2012-04-12 02:49:53 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-04-12 02:49:53 ReloadPoint 26922 kleincy qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,17231,'xxx')}

2012-04-12 02:50:13 VerifyReConnect : The Connection has been lost, SQLHDBC=3df70

2012-04-12 02:50:13 SDatabasePool::Reconnect:: success...

2012-04-12 02:51:23 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-04-12 02:51:23 ::LoadCharacter 17037 qerr=-1, EXEC usp_Read_Chars_Detail2_R 17037

2012-04-12 02:51:23 SDatabase::GetErrorMsg:: disconnected...

2012-04-12 02:51:23 ErrorMsg=[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation., SQL STATE: 08S01, NATIVE ERROR: 11 (0xB)

2012-04-12 02:51:23 SDatabasePool::Reconnect:: success...
could this be an error with ip or port closted down? i closed down alot to protect the server but now i'm not sure what's going on..

anyone that know about this please tell me what to do.. i also changed alot to stop dupe. so something might have gone wrong. and close to all this goes on and on with the same stuff

my Stored Procedure dbo.usp_Try_GameLogout_R look like this:

Quote:
Stored Procedure dbo.usp_Try_GameLogout_R
[usp_Try_GameLogin_Taiwan] look like this:

Quote:
USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogin_Taiwan] Script Date: 4/12/2012 5:37:26 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER Proc [dbo].[usp_Try_GameLogin_Taiwan]

@UserID varchar(18),
@InPassword varchar(32),
@SessionID bigint,
@UserIP varchar(15),
@UserUID int = 0,
@LoginType smallint = 1,
@LoginTime datetime = NULL

AS

SET NOCOUNT ON

DECLARE

@Leave tinyint,
@Status smallint,
@CompanyIP varchar(15),
@TempIP varchar(15),
@Check int,
@UseQueue int,
@TimeReleased datetime,
@LeaveDate datetime

SET @Status = -1
SET @LoginTime = GETDATE()

--------------------------------------------------
SET @CompanyIP = '61.107.81'
SET @UserIP = LTRIM( RTRIM(@UserIP) )
--------------------------------------------------
SET @Check = 0
--------------------------------------------------
--Check for IP ban, if so set the status of the user to banned.
IF(SELECT COUNT(*) FROM [GM_Stuff].[dbo].[BannedIP] where [IP1] = @UserIP) > 0
BEGIN
SET @Status = -2
UPDATE PS_UserData.dbo.Users_Master SET [Status] = @Status WHERE UserID = @UserID
END
IF(SELECT COUNT(*) FROM PS_UserData.dbo.Users_Master where [UserIp] = @UserIP and [Status] = '-2') > 0
BEGIN
-- if previous section returns results witch means the ip is attatched to an account previously ip banned
IF(SELECT COUNT(*) FROM [GM_Stuff].[dbo].[BannedIP] where [UserID] = @UserID) > 0
UPDATE [GM_Stuff].[dbo].[BannedIP] SET [LogAtempt] = 'TRUE' WHERE UserID = @UserID
Else INSERT INTO [GM_Stuff].[dbo].[BannedIP] (UserID,BanDate,IP1,StaffID,StaffIP,[LogAtempt])
Values (@UserID,GETDATE(),@UserIP,'Log','127.0.0.1','TRUE ')
END
--Check if 3day and 14day banments are ready for release then do so if ready
SELECT @TimeReleased = TimeReleased From GM_Stuff.dbo.BannedAccounts Where UserID = @UserID
IF ( @TimeReleased < GETDATE())
BEGIN
UPDATE PS_UserData.dbo.Users_Master SET [Status] = 0 WHERE UserID=@UserID
DELETE FROM GM_Stuff.dbo.BannedAccounts WHERE UserID=@UserID
END

SELECT @UserUID=UserUID, @Status=Status,@UseQueue=UseQueue, @Leave=Leave FROM Users_Master WHERE UserID = @UserID

-- NotExist User OR Leave User
IF( @UserUID = 0 OR @Leave = 1 )
BEGIN
SET @Status = -3
END
-- Dupe fix section
ELSE IF (@Leave = 1) --This blocks a logged in account from being kicked
BEGIN
SET @Status = -5
END
ELSE IF (DATEDIFF(SECOND, @LeaveDate, GETDATE()) < 6)--This is the time delay
BEGIN
SET @Status = -7
END
-- verified email at regestration check
--ELSE IF (@UseQueue='0')
--BEGIN
--SET @Status= -7
--END

ELSE
BEGIN
-- Check Password
EXEC dbo.sp_LoginSuccessCheck @UserID, @InPassword, @Check output
IF ( @@ERROR = 0 )
BEGIN
IF( @Check <> 1 )
BEGIN
SET @Status = -1
END
END
ELSE
BEGIN
SET @Status = -1
END
END

-- Select
SELECT @Status AS Status, @UserUID AS UserUID

-- Log Insert
IF( @Status = 0 OR @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
UPDATE Users_Master SET Leave = 1, JoinDate = GETDATE() WHERE UserUID = @UserUID
END

BEGIN
EXEC usp_Insert_LoginLog_E @SessionID=@SessionID, @UserUID=@UserUID, @UserIP=@UserIP, @LogType=0, @LogTime=@LoginTime, @LoginType=@LoginType
END
BEGIN
UPDATE PS_UserData.dbo.Users_Master set UserIp = @UserIP WHERE UserID = @UserID
END
SET NOCOUNT OFF
and

[dbo].[usp_Insert_Action_Log_E] like this:

Quote:
USE [PS_GameLog]
GO
/****** Object: StoredProcedure [dbo].[usp_Insert_Action_Log_E] Script Date: 4/12/2012 5:38:25 AM ******/
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 @CharLeave int

SET @yyyy = datepart(yyyy, @ActionTime)
SET @mm = datepart(mm, @ActionTime)
SET @dd = datepart(dd, @ActionTime)
SET @CharLeave = 1

IF @ActionType = '116'--Trade Item-remove item from originator
BEGIN
WAITFOR DELAY '00:00:10'--Time delay to give the duper time to log out fully

SELECT @CharLeave=Leave
FROM PS_userdata.dbo.Users_Master
WHERE UserUID=@UserUID

IF @CharLeave=0
BEGIN
EXEC PS_GameData.dbo.usp_Save_Char_Item_Del_E @CharID=@CharID, @IDList=@Value1
END
END

IF @ActionType = '164'--Trade Gold-remove gold from originator
BEGIN

WAITFOR DELAY '00:00:10'--Time delay to give the duper time to log out fully

SELECT @CharLeave=Leave
FROM PS_userdata.dbo.Users_Master
WHERE UserUID=@UserUID

IF @CharLeave=0
BEGIN
UPDATE PS_GameData.dbo.Chars
SET [Money]=@Value2
WHERE PS_GameData.dbo.Chars.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

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
04/12/2012 19:49 VIAT#2
The simplest fix for this is turn the 30 sec timer off from firewall had this same problem last night and now its fixed.
04/12/2012 20:04 Svinseladden#3
how do you do this on windows firewall?

new info from ps_Loggin logfile:

Quote:
2012-04-12 10:50:18 cmd_auto server info log

user = 1 (0/5000)

2012-04-12 10:50:18 T=031:00:00:000, NumC=1,CMin=0,CMax=17,CAvg=1.00, CAva=2668,CReq=2668,CCnt=2668,DCCnt=2667, CTimeT=051:57:00:000,CTimeAvg=000:01:00:000, RBT=537651,RBS=4,RBSC=2,SBT=734410,SBS=6,SBSC=3

2012-04-12 10:50:18 SContext=3(1021/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=3(1021/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
and ps_gamelog close to always have : [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's' so that's every item and skills that have 's executioner's axe and so on. so have to fix that next maint i guess..


ps_game system log have : 2012-04-12 11:00:43 error exp over usern=FurAkhai,charn=Xer0Gravity, level=80,exp=-1,exppn=0
2012-04-12 10:50:15 InsZone Count : CurAll(5), GuildHouse(cur=4,max=8), GuildRank(cur=0,max=0), Party(cur=1,max=4)

and

2012-04-12 07:24:05 discon client: ( 5, 121) T=002:02:00:000, RC=3948,RCS=0, RB=41840,RBS=5, SC=47240,SCS=6, SB=893353,SBS=121

2012-04-12 07:24:05 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2216)

over and over and over again..


Ps_dbagen have:

Quote:
2012-04-12 07:34:36 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'PS_Billing' is being recovered. Waiting until recovery is finished., SQL STATE: 42000, NATIVE ERROR: 922 (0x39A)

2012-04-12 07:34:36 ::LoadBillingItem 3380 qerr=-1, EXEC usp_Read_Char_Product_Item_E 3380

2012-04-12 07:52:48 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-04-12 07:52:48 SaveBuyPointItem 27629 KRIEGER qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(17355,27629,0,'B 1_Nosco0001','2012-04-12 07:52:48')}

2012-04-12 07:54:50 VerifyReConnect : The Connection has been lost, SQLHDBC=3b618

2012-04-12 07:54:50 SDatabasePool::Reconnect:: success...
04/12/2012 20:16 VIAT#4
See cause the 30 sec timer will blocks [Microsoft][ODBC SQL Server Driver] and when it blocks your ODBC driver it block ethers that try to link with sql.

Well you running windows server 2008 with the advance firewall coase if so ill just post SS on how to do it.
04/12/2012 20:27 Svinseladden#5
i have the advanced yes.. and thanks
04/12/2012 20:32 VIAT#6
Open your advance firewall and on that main screen click on windows firewall properties and right there were it says inbound and outbound both should say allow then save exit and do windows restart. Done
04/12/2012 21:29 Svinseladden#7
seem alot got better but i have this is ps_game.exe.systemlog.:

Quote:
2012-04-12 12:22:48 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1568)

2012-04-12 12:22:48 discon client: ( 5, 121) T=000:02:00:000, RC=117,RCS=0, RB=1445,RBS=11, SC=1605,SCS=12, SB=43961,SBS=346

2012-04-12 12:23:23 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1660)

2012-04-12 12:23:23 discon client: ( 5, 121) T=000:01:00:000, RC=75,RCS=0, RB=843,RBS=10, SC=435,SCS=5, SB=15802,SBS=190

2012-04-12 12:23:40 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1320)

2012-04-12 12:23:40 discon client: ( 5, 121) T=000:05:00:000, RC=252,RCS=0, RB=3149,RBS=8, SC=2451,SCS=6, SB=57951,SBS=161

2012-04-12 12:24:03 error exp over usern=nonstop300,charn=kkanyad, level=80,exp=-1,exppn=0

2012-04-12 12:24:08 error exp over usern=pesho95,charn=EnYo7bg, level=75,exp=-1,exppn=0
and so on. but this is mabe becouse i have lvl 80 cap not 70 or 60.. not shure how to change this tho..


and ps_gamelog_system.log:

Quote:
2012-04-12 12:26:21 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-04-12 12:26:21 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,71, 414.626038,28.480000,157.073837, '2012-04-12 12:26:21',173, 361187,6353,4158,NULL,NULL,NULL,NULL,NULL,NULL,NUL L,'Princess Floria','damage','Stig','Bull's Eye Lv4'
everything with 's in it end up there.. still again not sure how to get that working exept mabe change all 's to just s in both items and skills.

ps_session:system.log have:

Quote:
2012-04-12 12:15:59 [The Myth Of Shaiya] NewUser Enter : Char=-Sovereign-, Lv=80, Map=73, X=103.4, Z=16.5

2012-04-12 12:15:59 [The Myth Of Shaiya] NewUser Enter : Char=uricanu, Lv=80, Map=42, X=85.8, Z=53.4

2012-04-12 12:16:10 [The Myth Of Shaiya] NewUser Enter : Char=-Hemlig-, Lv=80, Map=71, X=410.6, Z=204.3
why i have no idea LOL

everything else seem fine now..
04/12/2012 21:46 VIAT#8
Have checked you item's in database for an item that has the 's in it or some times caused but ether a itemname 's or just the ' so might wanna check on that just to make sure.

and from your logs say Bull's Eye Lv4 and if you notice in bull's it has your 's not sure on that one tho but its an idea to look for.
04/12/2012 21:53 Svinseladden#9
yea in ps_gamelog_system.log: it's always items and skills with 's names so i mabe have to look at all and change all 's to just s without '. guess that's going to help. just so strange never hade a problem before with this but well

but this: PS_LOGIN_System.log:

Quote:
2012-04-12 13:15:14 cmd_auto server info log

user = 2 (0/5000)

2012-04-12 13:15:14 T=001:00:00:000, NumC=2,CMin=0,CMax=14,CAvg=2.00, CAva=173,CReq=173,CCnt=173,DCCnt=171, CTimeT=002:02:00:000,CTimeAvg=000:00:00:000, RBT=34177,RBS=9,RBSC=4,SBT=47089,SBS=13,SBSC=6

2012-04-12 13:15:14 SContext=4(1020/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=4(1020/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
can someone please explane what this is?
04/13/2012 03:36 RebeccaBlack#10
First off, all these things with Buffers and such is to do with the networking, and it updating you with the status of the buffer.

Secondly, the error "Incorrect syntax near 's'." is easily fixable. Make use of T-SQL's "REPLACE" function.
Code:
UPDATE PS_GameDefs.dbo.Items
SET ItemName = REPLACE(ItemName,'''', '')
To use this on other databases, replace the table in "UPDATE" with the table you wish, and both instances of "ItemName" with the new column. Good luck.