Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya
You last visited: Today at 14:06

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


[Help] GameLog (ActionLog problem)

Reply
 
Old   #1
 
elite*gold: 261
Join Date: Sep 2009
Posts: 288
Received Thanks: 235
[Help] GameLog (ActionLog problem)

Hello, since short have I new error message in the GameLog, see below. To me can someone say why this error comes and where I can fix this? The server ran now 1 month without problems.


Code:
2010-05-13 19:57:55 PS_GAMELOG__system log start (GameLog01)

2010-05-13 19:58:24 connect game

2010-05-13 19:58:28 connect game

2010-05-13 20:00:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2010-05-13 20:00:18 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'GM-1',1,9,'[GM]-KAMPFSAU', 60,1405399100,1, 951.351807,9.216818,664.624390, '2010-05-13 20:00:18' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Enter',NULL,NULL,NULL

2010-05-13 20:00:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2010-05-13 20:00:18 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'GM-1',1,9,'[GM]-KAMPFSAU', 60,1405399100,1, 951.351807,9.216818,664.624390, '2010-05-13 20:00:18' ,107, 255,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '77.20.217.66','money=1903153886, bank=0, cash=954828','level=60,skp=275,stp=2366','s=25000,d=30000,i=30000,w=30000,r=30134,l=30000'

2010-05-13 20:01:05 1 1 SAgent::Disconnect: (4, 64)

2010-05-13 20:01:05 1 1 T=000:02:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2010-05-13 20:01:05 disconnect game

2010-05-13 20:01:07 3 1 SERVICE_CONTROL_STOP

2010-05-13 20:01:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2010-05-13 20:01:11 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'GM-1',1,9,'[GM]-KAMPFSAU', 60,1405399100,1, 951.351807,9.216818,664.624390, '2010-05-13 20:01:11' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Leave',NULL,NULL,NULL

2010-05-13 20:01:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2010-05-13 20:01:11 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'GM-1',1,9,'[GM]-KAMPFSAU', 60,1405399100,1, 951.351807,9.216818,664.624390, '2010-05-13 20:01:11' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'money=1903153886, bank=0, cash=954828, firstmoney=1903153886','level=60,skp=275,stp=2366','s=25000,d=30000,i=30000,w=30000,r=30134,l=30000'

2010-05-13 20:01:12 1 1 SAgent::Disconnect: (4, 64)

2010-05-13 20:01:12 1 1 T=000:02:00:000, RC=5,RCS=0, RB=414,RBS=2, SC=0,SCS=0, SB=0,SBS=0

2010-05-13 20:01:12 disconnect game

2010-05-13 20:01:13 PS_GAMELOG__system log end (GameLog01)

2010-05-13 20:01:13 3 1 SService::ServiceCtrlDispatcher(): service shutdown
I think its a problem with usp_Insert_Action_Log_E but why?



Shaiya Xtreme is offline  
Old 05/14/2010, 17:46   #2
 
elite*gold: 0
Join Date: May 2009
Posts: 10
Received Thanks: 8
Quote:
Originally Posted by Killsteal View Post

I think its a problem with usp_Insert_Action_Log_E but why?
PS_GameLog -> dbo.ActionLog -> usp_Insert_Action_Log_E

Code:
@UserID varchar(18),
@UserUID int,
@CharID int,
@CharName nvarchar(50),
@CharLevel tinyint,
@CharExp int,
@MapID smallint,
@PosX real,
@PosY real,
@PosZ real,
-----------CHANGE THIS--------------------------
@ActionTimeZ varchar(50),  --change NAME and type
----------------------------------------Twilight
@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
------ADD THIS--------------------------------------------
DECLARE @ActionTime as datetime
SELECT @ActionTime = CONVERT(datetime, @ActionTimeZ, 120)
--------------------------------------------------Twilight
SET @yyyy = datepart(yyyy, @ActionTime)
SET @mm = datepart(mm, @ActionTime)
SET @dd = datepart(dd, @ActionTime)
.
.
.
and..
CAST and CONVERT (Transact-SQL)


U97 is offline  
Thanks
1 User
Reply



« Duable EXP | EP5 Armor Files (Shaiya Dev Group) »

Similar Threads
Having problem Wierd problem with [GUIDE-DETIALED] How to setup a server!
02/10/2010 - EO PServer Hosting - 1 Replies
Hellow, I just used this guide, to set up an EO private server. Everything is correct, but my AccountServer Keeps bugging. Can someOne help me ( via TeamViewer, .. ) ? Thnx, Greets Joris
[Problem] Problem with server starting - cannot find quest index for PaxHeader
12/22/2009 - Metin2 PServer - Discussions / Questions - 1 Replies
Hello! I have this same problem as here when i'm starting my server: http://www.elitepvpers.com/forum/metin2-pserver-discussions-questions/307143-metin2-serverfiles-quest-index-fehler.html But I didn't know the answer.. how to repair this? ...



All times are GMT +2. The time now is 14:06.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.