• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

FIELD SERVER: (CID 101, GID 0) Drop & Save Character error?

Newbie Spellweaver
Joined
Jul 25, 2018
Messages
62
Reaction score
2
(CID 101, GID 0) Drop & Save CharacterDB:UPDATE ChaInfo SET ChaBright=1, ChaLevel=1, ChaMoney=0, ChaDex=0, ChaIntel=0, ChaSchool=0, ChaHair=0, ChaFace=0, ChaLiving=0, ChaStrong=0, ChaPower=0, ChaSpirit=0, ChaStrength=0, ChaStRemain=10, ChaAttackP=0, ChaDefenseP=0, ChaFightA=5, ChaShootA=2, ChaExp=0, ChaSkillPoint=10, ChaHP=220, ChaMP=5, ChaSP=10, ChaPK=0, ChaStartMap=2, ChaStartGate=6, ChaPosX=0.000000, ChaPosY=0.000000, ChaPosZ=0.000000, ChaSaveMap=2, ChaSavePosX=170.752228, ChaSavePosY=10.021001, ChaSavePosZ=-2091.655273, ChaReturnMap=-1, ChaReturnPosX=0.000000, ChaReturnPosY=0.000000, ChaReturnPosZ=0.000000, ChaGuName='', ChaReExp=0, ChaSpMID =65535, ChaSpSID =65535, ChaPkWin =0, ChaPkLoss =0,ChaVotePoint=0, ChaPremiumPoint=0, ChaContributionPoint=0, WHERE ChaNum=1DB:42000, NativeError:156, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'.


everytime i reconnect? its always rollback when i started! new character is always like this?

any help?
 
Skilled Illusionist
Joined
May 25, 2014
Messages
354
Reaction score
29
(CID 101, GID 0) Drop & Save CharacterDB:UPDATE ChaInfo SET ChaBright=1, ChaLevel=1, ChaMoney=0, ChaDex=0, ChaIntel=0, ChaSchool=0, ChaHair=0, ChaFace=0, ChaLiving=0, ChaStrong=0, ChaPower=0, ChaSpirit=0, ChaStrength=0, ChaStRemain=10, ChaAttackP=0, ChaDefenseP=0, ChaFightA=5, ChaShootA=2, ChaExp=0, ChaSkillPoint=10, ChaHP=220, ChaMP=5, ChaSP=10, ChaPK=0, ChaStartMap=2, ChaStartGate=6, ChaPosX=0.000000, ChaPosY=0.000000, ChaPosZ=0.000000, ChaSaveMap=2, ChaSavePosX=170.752228, ChaSavePosY=10.021001, ChaSavePosZ=-2091.655273, ChaReturnMap=-1, ChaReturnPosX=0.000000, ChaReturnPosY=0.000000, ChaReturnPosZ=0.000000, ChaGuName='', ChaReExp=0, ChaSpMID =65535, ChaSpSID =65535, ChaPkWin =0, ChaPkLoss =0,ChaVotePoint=0, ChaPremiumPoint=0, ChaContributionPoint=0, WHERE ChaNum=1
The comma after
ChaContributionPoint=0 must be removed
 
Upvote 0
Back
Top