Ran Manager for Ep7 Weird Error

[force0890]

Hi Ragezoners!

I need some help regarding my ran manager.
yesterday my ran manager works fine. no error.

today after I installed InCupdate for my server and deleted some "Cell" in my database.
error comes up when i'm editing my character info(PAGE Char -> CharPage Edit)

https://prnt.sc/tpzcqv

but after the error show and press "ok" and try to save it again. it works.

What possible reason for this kind of error?
I tried to Uninstall all of my SQL server, restored clean database, remove/add ODBC sql native client.

still error comes up and I need to press the error and save it again to make it work.

check my RanManagerLog.

----
2020-07-28 23:09:06--SELECT UserNum,SGNum,ChaName,ChaTribe,ChaClass,ChaBright,ChaLevel,ChaDex,ChaIntel,ChaPower,ChaStrong,ChaSpirit,ChaStrength,ChaStRemain,ChaAttackP,ChaDefenseP,ChaFightA,ChaShootA,ChaSkillPoint,ChaHP,ChaMP,ChaSP,ChaPK,ChaStartMap,ChaStartGate,ChaPosX,ChaPosY,ChaPosZ,ChaMoney,ChaExp,ChaSaveMap,ChaSavePosX,ChaSavePosY,ChaSavePosZ,ChaSchool,ChaHair,ChaFace,ChaLiving,ChaInvenLine,ChaReturnMap,ChaReturnPosX,ChaReturnPosY,ChaReturnPosZ,GuNum,ChaGuName,ChaSex,ChaHairColor, ChaReExp, ChaSpMID, ChaSpSID,ChaReborn, ChaPkWin, ChaPkLoss, ChaVotePoint, ChaPremiumPoint, ChaCP,ChaDeleted, GuPosition, ChaCreateDate, ChaDeletedDate, ChaGuSecede,ChaContribP FROM RanGame1.dbo.ChaInfo WHERE ChaNum=7
2020-07-28 23:09:06--SELECT GuNum,GuName FROM RanGame1.dbo.GuildInfo WHERE GuNum=0
2020-07-28 23:09:10--UPDATE RanGame1.dbo.ChaInfo SET ChaBright=0, ChaLevel=211, ChaMoney=100292874012, ChaDex=9999, ChaIntel=0, ChaSchool=1, ChaHair=3, ChaFace=3, ChaLiving=100000, ChaStrong=9999, ChaPower=9999, ChaSpirit=9999, ChaStrength=9999, ChaStRemain=500, ChaAttackP=99999, ChaDefenseP=99999, ChaFightA=9547, ChaShootA=13492, ChaExp=1071232532, ChaSkillPoint=367, ChaHP=100044, ChaMP=8154, ChaSP=17212, ChaPK=0, ChaStartMap=22, ChaStartGate=0, ChaPosX=0.000000, ChaPosY=0.000000, ChaPosZ=0.000000, ChaSaveMap=5, ChaSavePosX=431.328003, ChaSavePosY=0.299000, ChaSavePosZ=-2198.379883, ChaReturnMap=27, ChaReturnPosX=-38.268299, ChaReturnPosY=0.299000, ChaReturnPosZ=1050.199951, ChaGuName='', ChaReExp=0, ChaSpMID = 65535, ChaSpSID = 65535, ChaReborn = 0, ChaPkWin = 0, ChaPkLoss = 0, ChaVotePoint=99999, ChaPremiumPoint=96999, ChaCP=911838 ,ChaName='TESTLangTo' ,ChaTribe=0, ChaClass=32, SGNum=0, ChaInvenLine=5, GuNum=0, ChaSex=0, ChaHairColor=24447, ChaDeleted=0, GuPosition=3703221184, ChaCreateDate='7/15/2020 18:32:25', ChaDeletedDate='7/15/2020 18:32:25', ChaGuSecede='2/1/1970 0:0:0', ChaContribP=0 WHERE ChaNum=7

[MentaL]

[force0890]

Hi Ragezoners!

I need some help regarding my ran manager.
yesterday my ran manager works fine. no error.

today after I installed InCupdate for my server and deleted some "Cell" in my database.
error comes up when i'm editing my character info(PAGE Char -> CharPage Edit)

https://prnt.sc/tpzcqv

but after the error show and press "ok" and try to save it again. it works.

What possible reason for this kind of error?
I tried to Uninstall all of my SQL server, restored clean database, remove/add ODBC sql native client.

still error comes up and I need to press the error and save it again to make it work.

check my RanManagerLog.

----
2020-07-28 23:09:06--SELECT UserNum,SGNum,ChaName,ChaTribe,ChaClass,ChaBright,ChaLevel,ChaDex,ChaIntel,ChaPower,ChaStrong,ChaSpirit,ChaStrength,ChaStRemain,ChaAttackP,ChaDefenseP,ChaFightA,ChaShootA,ChaSkillPoint,ChaHP,ChaMP,ChaSP,ChaPK,ChaStartMap,ChaStartGate,ChaPosX,ChaPosY,ChaPosZ,ChaMoney,ChaExp,ChaSaveMap,ChaSavePosX,ChaSavePosY,ChaSavePosZ,ChaSchool,ChaHair,ChaFace,ChaLiving,ChaInvenLine,ChaReturnMap,ChaReturnPosX,ChaReturnPosY,ChaReturnPosZ,GuNum,ChaGuName,ChaSex,ChaHairColor, ChaReExp, ChaSpMID, ChaSpSID,ChaReborn, ChaPkWin, ChaPkLoss, ChaVotePoint, ChaPremiumPoint, ChaCP,ChaDeleted, GuPosition, ChaCreateDate, ChaDeletedDate, ChaGuSecede,ChaContribP FROM RanGame1.dbo.ChaInfo WHERE ChaNum=7
2020-07-28 23:09:06--SELECT GuNum,GuName FROM RanGame1.dbo.GuildInfo WHERE GuNum=0
2020-07-28 23:09:10--UPDATE RanGame1.dbo.ChaInfo SET ChaBright=0, ChaLevel=211, ChaMoney=100292874012, ChaDex=9999, ChaIntel=0, ChaSchool=1, ChaHair=3, ChaFace=3, ChaLiving=100000, ChaStrong=9999, ChaPower=9999, ChaSpirit=9999, ChaStrength=9999, ChaStRemain=500, ChaAttackP=99999, ChaDefenseP=99999, ChaFightA=9547, ChaShootA=13492, ChaExp=1071232532, ChaSkillPoint=367, ChaHP=100044, ChaMP=8154, ChaSP=17212, ChaPK=0, ChaStartMap=22, ChaStartGate=0, ChaPosX=0.000000, ChaPosY=0.000000, ChaPosZ=0.000000, ChaSaveMap=5, ChaSavePosX=431.328003, ChaSavePosY=0.299000, ChaSavePosZ=-2198.379883, ChaReturnMap=27, ChaReturnPosX=-38.268299, ChaReturnPosY=0.299000, ChaReturnPosZ=1050.199951, ChaGuName='', ChaReExp=0, ChaSpMID = 65535, ChaSpSID = 65535, ChaReborn = 0, ChaPkWin = 0, ChaPkLoss = 0, ChaVotePoint=99999, ChaPremiumPoint=96999, ChaCP=911838 ,ChaName='TESTLangTo' ,ChaTribe=0, ChaClass=32, SGNum=0, ChaInvenLine=5, GuNum=0, ChaSex=0, ChaHairColor=24447, ChaDeleted=0, GuPosition=3703221184, ChaCreateDate='7/15/2020 18:32:25', ChaDeletedDate='7/15/2020 18:32:25', ChaGuSecede='2/1/1970 0:0:0', ChaContribP=0 WHERE ChaNum=7

up for this. I need help

[baby011528]

its need to see your db.
send me a backup of rangame1 of your.
i will help you fixed it.

[force0890]

its need to see your db.
send me a backup of rangame1 of your.
i will help you fixed it.

here sir. https://www.mediafire.com/file/cv4z9...Game1.bak/file

I think this error comes up when i deleted the details inside the table of chainfo. I didn't use trancute to delete those details.

[baby011528]

here sir. https://www.mediafire.com/file/cv4z9...Game1.bak/file

I think this error comes up when i deleted the details inside the table of chainfo. I didn't use trancute to delete those details.

problem is chainfo.guposition int type , but the value from your ran manager is bigger than that.

just run this script for changing the guposition from int type to bigint type , and your problem should be slove.

USE [RanGame1]
GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ChaInfo_GuPosition]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ChaInfo] DROP CONSTRAINT [DF_ChaInfo_GuPosition]
END
GO
ALTER TABLE [dbo].[ChaInfo] ALTER COLUMN [GuPosition] bigint null
GO
ALTER TABLE [dbo].[ChaInfo] ADD  CONSTRAINT [DF_ChaInfo_GuPosition]  DEFAULT ((0)) FOR [GuPosition]
GO

[force0890]

problem is chainfo.guposition int type , but the value from your ran manager is bigger than that.

just run this script for changing the guposition from int type to bigint type , and your problem should be slove.

USE [RanGame1]
GO
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ChaInfo_GuPosition]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ChaInfo] DROP CONSTRAINT [DF_ChaInfo_GuPosition]
END
GO
ALTER TABLE [dbo].[ChaInfo] ALTER COLUMN [GuPosition] bigint null
GO
ALTER TABLE [dbo].[ChaInfo] ADD  CONSTRAINT [DF_ChaInfo_GuPosition]  DEFAULT ((0)) FOR [GuPosition]
GO

hey! thank you so much. it worked

[baby011528]

hey! thank you so much. it worked

you're welcome.