ERROR: 102 (0x66) in PS_GAMELOG__system

05/16/2010 10:20 Shaiya Xtreme#1
Hello, since short I get this error message.


Code:
2010-05-16 09:38:56 PS_GAMELOG__system log start (GameLog01)

2010-05-16 09:39:01 connect game

2010-05-16 09:39:02 connect game

2010-05-16 10:13:08 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Falsche Syntax in der Nähe von 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2010-05-16 10:13:08 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'GM-1',1,9,'TESTCHAR', 60,1405399100,42, 45.306141,1.867607,44.623051, '2010-05-16 10:13:08' ,121, 2981080411528036352,100082, 1,1,3, NULL,34,NULL,NULL,NULL,'Operator's Exclusive',NULL,'0,0,0,0,0,0 (Option:)','2010-05-15 14:51:23'
Someone any idea how I can that repaired ?
05/17/2010 05:19 13latrix#2
I have 1 similiar.. and i believe its got to do with DC/timout error for some of my testers.

2010-05-16 11:05:42 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2010-05-16 11:05:42 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 119,2981577979195245121,4,'64'

2010-05-16 11:05:42 VerifyReConnect : The Connection has been lost, SQLHDBC=a885b0

2010-05-16 11:05:42 SDatabasePool::Reconnect:: success...

Fix for this would be greatly apreciated.

EP4 server/files

~Phish
05/17/2010 10:53 Shaiya Xtreme#3
hmmm,

It is a issue of Network Protocol as transaction is travelling from Non secure (TCIP) to Secure (SSL) to Non Secure(HTTP) layer.

Please check if you could fine any solution/ setting which could prevent the same.
05/17/2010 11:28 13latrix#4
Yours seems to do with the item "OP hammer" on char "TESTCHAR" .

looke over procedure "usp_Insert_Action_Log_E" and see what you can findout.