Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya
You last visited: Today at 11:18

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Help DB Error

Discussion on Help DB Error within the Shaiya forum part of the MMORPGs category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2020
Posts: 37
Received Thanks: 0
Help DB Error

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
#Cheetah is offline  
Old 05/12/2020, 05:24   #2
 
[GameAdvisor]Finn's Avatar
 
elite*gold: 0
Join Date: Sep 2016
Posts: 171
Received Thanks: 107
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,'''','')
[GameAdvisor]Finn is offline  
Reply


Similar Threads Similar Threads
İbot Error-Error Video- Error İmages-HELP
04/10/2012 - DarkOrbit - 11 Replies
SORRY, MY ENGLİSH VERY BAD.I USE TO GOOGLE TRANSLATE :) Most people trying to ibot but in my computer İbot not working. Declared out this error everywhere but I do not get answers Here's the error Video http://youtu.be/q0fK09v-K3c
API Error Code: 100 API Error Description: Invalid parameter Error Message: redirect_
04/08/2012 - elite*gold Trading - 2 Replies
API Error Code: 100 API Error Description: Invalid parameter Error Message: redirect_uri URL is not properly formatted Das bekomme ich wenn ich ne App installiere... ich habe schon 3 Apps richtig installiert, danach kam immer das bei anderen Apps die ich installiert habe.. was heisst das? redirect_uri URL is not properly formatted
[Error]Error when using Zero's method/And another Error
09/16/2011 - Shaiya Private Server - 5 Replies
well here is a screeny of my problem. Any assistance is greatly appreciated. I haven't come across this error before nor seen any posts up here about it. Also this is me executing the NpcQuest_cvs.bat and yes i changed python to C:/Python27/Python.exe in the command line. http://img707.imageshack.us/img707/9997/errorgx.p ng Ok So my second error involves changing Stat points per lvl here is my screen shots http://img854.imageshack.us/img854/6412/nosave.pn g
[Error] Server Error [/Error]
03/30/2011 - Dekaron Private Server - 7 Replies
Okay so i just start the server as usual but then i got this error: http://i.min.us/ibDMH2.jpg
ERROR ERROR ERROR!
11/08/2008 - Dekaron - 5 Replies
Hello, everytime i launch 2moons and log in it freezes just as the map is finished loading and the DAMN CRASH REPORTER comes up and the game closes. Can anyone help me get around this? I tried deleting the bug reporter(LOL) but all that happened was that it crashed without it popping up. PS. I think i read somewhere that it was caused because i needed to update something or change files, but no one would reply to me :( I am using the crc bypass from the sticky Anticipating your...



All times are GMT +1. The time now is 11:18.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.