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)

You must be registered to see links

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

 

[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)

You must be registered to see links

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.

You must be registered to see links

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.

You must be registered to see links

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.