Hey guys,
I've come across some errors on my private server that I haven't experienced while testing and don't really know how to fix them.
Here is my errorlog from PS_GameLog:
2017-03-12 20:38:04 connect game
2017-03-12 21:42:59 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)
2017-03-12 21:42:59 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'Player',65,146,'Player', 53,7648536,28, 933.184875,39.760002,992.196289, '2017-03-12 21:42:59' ,133, 844,1,0,29001,1,NULL,NULL,NULL,NULL,NULL,'The Stardust Knights_ Messeng ','Sherlock's Epistle',NULL,NULL
2017-03-12 21:53:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)
2017-03-12 21:53:02 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'Player',65,146,'Player', 53,7669536,28, 933.483643,39.762539,991.493958, '2017-03-12 21:53:02' ,133, 845,1,30000,29002,1,NULL,NULL,NULL,NULL,NULL,'Sher lock_s Letter <Epic>','Sherlock's Second Epistle',NULL,NULL
I only added 4 rows of that error, because it repeats itself.
Right now I'm just guessing it's due to the apostrophe in some skills/items names like "Fool's Gold" I know the SQL Server uses ' in a way like this 'Fool's Gold' so the query will only insert 'Fool' but won't know what to do with s Gold'
But this didn't bring me closer to the solution. Has anybody else run into this problem?
(I also don't think that they affect the game in any way, except that some logs are missing.)
Edit: I've also tried looking for this error, but couldn't find the solution..