Help DB Error

05/12/2020 03:00 #Cheetah#1
Hello i have this error when i check log, C:\ShaiyaServer\PSM_Client\Bin\ps_gameLog.exe, loaded at 0x00400000 - 10/10/18 16:33:52

2020-05-11 20:42:19 connect game

2020-05-11 20:43:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2020-05-11 20:43:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1,'Peachy', 80,99080230,29, 318.113983,59.443794,1787.198120, '2020-05-11 20:43:54' ,113, 5861235860469121024,97061,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Warrior's Gold Armlet','PointItem','0,0,0,0,0,0 (Option:)','2020-05-11 20:43:54'

2020-05-11 20:43:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2020-05-11 20:43:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1,'Peachy', 80,99080230,29, 318.113983,59.443794,1787.198120, '2020-05-11 20:43:54' ,113, 5861235860469317632,37061,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Warrior's Gold Ring','PointItem','0,0,0,0,0,0 (Option:)','2020-05-11 20:43:54'

2020-05-11 20:43:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2020-05-11 20:43:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1,'Peachy', 80,99080230,29, 318.113983,59.443794,1787.198120, '2020-05-11 20:43:54' ,113, 5861235860469055488,96031,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Warrior's Gold Amulet','PointItem','0,0,0,0,0,0 (Option:)','2020-05-11 20:43:54'

2020-05-11 20:43:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2020-05-11 20:43:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1,'Peachy', 80,99080230,29, 318.113983,59.443794,1787.198120, '2020-05-11 20:43:54' ,113, 5861235860469186560,97061,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Warrior's Gold Armlet','PointItem','0,0,0,0,0,0 (Option:)','2020-05-11 20:43:54'

2020-05-11 20:43:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2020-05-11 20:43:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1,'Peachy', 80,99080230,29, 318.113983,59.443794,1787.198120, '2020-05-11 20:43:54' ,113, 5861235860469252096,37061,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Warrior's Gold Ring','PointItem','0,0,0,0,0,0 (Option:)','2020-05-11 20:43:54'

game wont load just keeps saying failed to create new process
05/12/2020 05:24 [GameAdvisor]Finn#2
Quote:
Originally Posted by #Cheetah View Post
Hello i have this error when i check log, C:\ShaiyaServer\PSM_Client\Bin\ps_gameLog.exe, loaded at 0x00400000 - 10/10/18 16:33:52

2020-05-11 20:42:19 connect game

2020-05-11 20:43:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2020-05-11 20:43:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1,'Peachy', 80,99080230,29, 318.113983,59.443794,1787.198120, '2020-05-11 20:43:54' ,113, 5861235860469121024,97061,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Warrior's Gold Armlet','PointItem','0,0,0,0,0,0 (Option:)','2020-05-11 20:43:54'

2020-05-11 20:43:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2020-05-11 20:43:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1,'Peachy', 80,99080230,29, 318.113983,59.443794,1787.198120, '2020-05-11 20:43:54' ,113, 5861235860469317632,37061,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Warrior's Gold Ring','PointItem','0,0,0,0,0,0 (Option:)','2020-05-11 20:43:54'

2020-05-11 20:43:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2020-05-11 20:43:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1,'Peachy', 80,99080230,29, 318.113983,59.443794,1787.198120, '2020-05-11 20:43:54' ,113, 5861235860469055488,96031,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Warrior's Gold Amulet','PointItem','0,0,0,0,0,0 (Option:)','2020-05-11 20:43:54'

2020-05-11 20:43:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2020-05-11 20:43:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1,'Peachy', 80,99080230,29, 318.113983,59.443794,1787.198120, '2020-05-11 20:43:54' ,113, 5861235860469186560,97061,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Warrior's Gold Armlet','PointItem','0,0,0,0,0,0 (Option:)','2020-05-11 20:43:54'

2020-05-11 20:43:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2020-05-11 20:43:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1,'Peachy', 80,99080230,29, 318.113983,59.443794,1787.198120, '2020-05-11 20:43:54' ,113, 5861235860469252096,37061,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Warrior's Gold Ring','PointItem','0,0,0,0,0,0 (Option:)','2020-05-11 20:43:54'

game wont load just keeps saying failed to create new process

when you edit item or other with name like Warrior's Gold Ring (because of apostrophe (') they give an error)
you need to run this query

Quote:
UPDATE PS_GameDefs.dbo.Items
SET ItemName = REPLACE(ItemName,'''', '')
UPDATE PS_GameDefs.dbo.Skills
SET SkillName = REPLACE(SkillName,'''', '')
UPDATE PS_GameDefs.dbo.Mobs
SET MobName=replace(MobName,'''','')