[HELP]PS_gamelog

[balongskie123]

Hello can anyone explain this ? and how to fix it thank you

 Spoiler

C:\ShaiyaServer\PSM_Client\bin\ps_gameLog.exe, loaded at 0x00400000 - 10/10/18 16:33:52

2018-05-19 06:17:12 connect game

2018-05-19 06:19:57 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2018-05-19 06:19:57 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'x12edadw2',1,10,'[ADM]Creed', 80,-1,42, 65.258583,1.848075,62.503704, '2018-05-19 06:19:57' ,113, 5289025824413253632,100082,NULL,1,NULL,NULL,NULL,N ULL,NULL,NULL,'Operator's Exclusive','PointItem','0,0,0,0,0,0 (Option','2018-05-19 06:19:57'

2018-05-19 06:19:59 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2018-05-19 06:19:59 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'x12edadw2',1,10,'[ADM]Creed', 80,-1,42, 65.258583,1.848075,62.503704, '2018-05-19 06:19:59' ,113, 5289025841592991744,100082,NULL,1,NULL,NULL,NULL,N ULL,NULL,NULL,'Operator's Exclusive','PointItem','0,0,0,0,0,0 (Option','2018-05-19 06:19:59'

2018-05-19 06:32:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2018-05-19 06:32:24 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'x12edadw2',1,10,'[ADM]Creed', 80,-1,42, 63.325714,1.849916,52.107670, '2018-05-19 06:32:24' ,111, 5289029264681795584,100082,1,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,'Operator's Exclusive','ItemCreate','0,0,0,0,0,0 (Option','2018-05-19 06:32:24'

2018-05-19 06:32:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2018-05-19 06:32:24 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'x12edadw2',1,10,'[ADM]Creed', 0,0,42, 63.325714,1.849916,52.107670, '2018-05-19 06:32:24',180, 1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'It emCreate','','name=Operator's Exclusive,count=1',NULL

2018-05-19 07:13:32 1 1 SAgent:isconnect: (4, 64)

2018-05-19 07:13:32 1 1 T=000:56:00:000, RC=64,RCS=0, RB=7886,RBS=2, SC=11,SCS=0, SB=44,SBS=0

[balongskie123]

Fixed

Use this code

UPDATE PS_GameDefs.dbo.Items
SET ItemName = REPLACE(ItemName,'''', '')