Gamelog

07/04/2015 21:57 slaifer10#1
hello i have problems with my gamelog
here my log
Code:
2015-07-04 14:29:37 PS_GAMELOG__system log start (GameLog01)

2015-07-04 14:29:53 connect game

2015-07-04 14:38:03 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error al convertir el tipo de datos varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2015-07-04 14:38:03 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1879116320,' 
@ 
T0', 79,6709606,12304, 0.000000,0.000000,0.000000, '2004-01-31 11:32:00' ,107, 68,1117593272,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '0.10.0.19','money=1155285975, bank=1036577154, cash=255','level=1792,skp=0,stp=0','s=0,d=0,i=16128,w=3906,r=1280,l=0'

2015-07-04 14:40:21 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error al convertir el tipo de datos varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2015-07-04 14:40:21 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,-805283785,'C', 79,17440792,8304, 623371543058807260000000.000000,0.000000,0.000000, '2012-05-21 09:48:00' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'money=2158898500, bank=3618718786, cash=-924183228, firstmoney=117445376','level=2560,skp=61,stp=0','s=51200,d=61488,i=16128,w=3906,r=1280,l=0'

2015-07-04 14:43:57 1 1 SAgent::Disconnect: (4, 64)

2015-07-04 14:43:57 1 1 T=000:14:00:000, RC=5,RCS=0, RB=292,RBS=0, SC=1,SCS=0, SB=4,SBS=0

2015-07-04 14:43:57 disconnect game

2015-07-04 14:43:59 3 1 SERVICE_CONTROL_STOP

2015-07-04 14:44:07 PS_GAMELOG__system log end (GameLog01)

2015-07-04 14:44:07 3 1 SService::ServiceCtrlDispatcher(): service shutdown
07/04/2015 23:00 killer2p#2
Error al convertir el tipo de datos varchar a datetime.
theres your issue
07/04/2015 23:27 slaifer10#3
Quote:
Originally Posted by killer2p View Post
Error al convertir el tipo de datos varchar a datetime.
theres your issue
yeah, but how to fix
I've tried it this post but i don't fix
[Only registered and activated users can see links. Click Here To Register...]
07/05/2015 12:07 Boul27#4
In sql manager, go to user management
Set the Shaiya user default language to English

It solved my probleme when using sql in french
07/05/2015 21:11 Trayne01#5
It has been already asked more than 20times..
Set ur user defaut language to english like boul said and you should send us your usp_Insert_Action_Log_E proc we will take a look it can be the problem too
07/09/2015 02:15 slaifer10#6
Quote:
Originally Posted by Trayne01 View Post
It has been already asked more than 20times..
Set ur user defaut language to english like boul said and you should send us your usp_Insert_Action_Log_E proc we will take a look it can be the problem too
Code:
2015-07-08 19:03:33 PS_GAMELOG__system log start (GameLog01)

2015-07-08 19:03:51 connect game

2015-07-08 19:06:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2015-07-08 19:06:33 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1879116320,' 
@ 
Ü?', 79,6709606,16280, 0.000000,0.000000,0.000000, '2027-10-26 25:12:00' ,107, 65,-1093874483,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '0.10.0.19','money=1098877333, bank=1037119905, cash=255','level=1792,skp=0,stp=0','s=0,d=0,i=16128,w=3906,r=1280,l=0'

2015-07-08 19:07:57 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2015-07-08 19:07:57 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,-100640713,'"ʯ', 79,17440792,8304, 623371543058807260000000.000000,0.000000,0.000000, '2027-10-26 25:12:00' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'money=3435973953, bank=2139723198, cash=-785254079, firstmoney=117445376','level=2560,skp=61,stp=0','s=0,d=0,i=16128,w=3906,r=1280,l=0'

2015-07-08 19:08:46 1 1 SAgent::Disconnect: (4, 64)

2015-07-08 19:08:46 1 1 T=000:04:00:000, RC=3,RCS=0, RB=284,RBS=0, SC=1,SCS=0, SB=4,SBS=0

2015-07-08 19:08:46 disconnect game

2015-07-08 19:08:46 3 1 SERVICE_CONTROL_STOP

2015-07-08 19:08:46 PS_GAMELOG__system log end (GameLog01)

2015-07-08 19:08:46 3 1 SService::ServiceCtrlDispatcher(): service shutdown
07/09/2015 02:30 Pave99#7
[Only registered and activated users can see links. Click Here To Register...]
07/09/2015 02:47 slaifer10#8
Quote:
Originally Posted by Pave99 View Post
[Only registered and activated users can see links. Click Here To Register...]
thanks but my problem was with the dll files i resolve this :)