Please Help With This Problem !!!

[ryaneichner]

OnSR_PREPARE_USER_ACK() - An error returned from GAMESERVER [NameChar >> error_code: 23]

CharDataLoadingCompleted :: Create Char Instance failed !! [JID: 1004, CharID: 2929] (SR_GameServer_srZor.exe)


Ps: Only Chars Eu , Chinese Work Fine!

° its problem in Database because i used very old backup 1° and working
but when i restory actualy backup not work , and i get this erro in chars Euro
can any one help me Thanks.

Ps2: i'm tryied fix 40% database using querys etc... and don't worked
tryied to change old Producer to actualy and not worked too.

Sorry for bad English !

can contact me on Discord too:

 Spoiler

ryanpel#6134

[Mr.Awesome1337]

If this error comes out when you try to log in, just use this query to teleport all characters to jangan

 Spoiler

USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25000, posX= 982 , posY= -0.421872 ,posZ= 140 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0, 
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0

[ryaneichner]

Originally Posted by Mr.Awesome1337

If this error comes out when you try to log in, just use this query to teleport all characters to jangan

 Spoiler

USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25000, posX= 982 , posY= -0.421872 ,posZ= 140 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0, 
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0

( Producer AddNewChar working fine )

This error is on i click Start On Char , = EventID=4
not its Region or Pos , its error in chars Euro only , because China Start Normal , and i changed all removed items of char Euro etc... and not worked
changed place , world id =1 and nothing ...
re-extracted data files and nothing...
changed producers and nothing...

[NorseGodTyr]

Originally Posted by ryaneichner

 Spoiler

OnSR_PREPARE_USER_ACK() - An error returned from GAMESERVER [NameChar >> error_code: 23]

CharDataLoadingCompleted :: Create Char Instance failed !! [JID: 1004, CharID: 2929] (SR_GameServer_srZor.exe)


Ps: Only Chars Eu , Chinese Work Fine!

° its problem in Database because i used very old backup 1° and working
but when i restory actualy backup not work , and i get this erro in chars Euro
can any one help me Thanks.

Ps2: i'm tryied fix 40% database using querys etc... and don't worked
tryied to change old Producer to actualy and not worked too.

Sorry for bad English !

can contact me on Discord too:

 Spoiler

ryanpel#6134

CharDataLoadingCompleted :: Create Char Instance failed

its a instance error something in database

check SRO_VT_SHARD in Table _RefRegionBindAssocServer
if the region enable

or your database eu chars is deactivated

[ryaneichner]

Originally Posted by NorseGodTyr

its a instance error something in database

check SRO_VT_SHARD in Table _RefRegionBindAssocServer
if the region enable

or your database eu chars is deactivated

check SRO_VT_SHARD in Table _RefRegionBindAssocServer 
if the region enable

Its Actived and Working.

or your database eu chars is deactivated

Maybe its this , but how i enable , because items working fine , only characters don't login , and chineses working fine too , only start Euro characters don't working .

Thanks bro.

[kyoshiro654]

you're using VSRO 1.188? try this database
it's "clean"

[ryaneichner]

Originally Posted by kyoshiro654

you're using VSRO 1.188? try this database
it's "clean"

yes Vsro 188 , i'm using DB edited of my work , when i use clean db of same DB , yes work , but when i edit not work , problem is i'm DB actualy , i try fix but not working , i changed querys , reworked Dbo. and nothing work...
used querys to try and nothing...

[tvdynamo]

Try it with this query

USE [SRO_VT_SHARD]
GO
UPDATE _RefObjCommon SET Service = 1 WHERE ID >= 14875 and ID <= 14900
UPDATE _RefCharGen SET Service = 1 WHERE RefObjID >= 14875 and RefObjID <= 14900

[ryaneichner]

Originally Posted by tvdynamo

Try it with this query

USE [SRO_VT_SHARD]
GO
UPDATE _RefObjCommon SET Service = '1' WHERE ID >= 14875 and ID <= 14900
UPDATE _RefCharGen SET Service = '1' WHERE RefObjID >= 14875 and RefObjID <= 14900

I Already Tried and Not Working !

[rogerio14]

tenta mudar a procedure no _AddNewChar

[ryaneichner]

Originally Posted by rogerio14

tenta mudar a procedure no _AddNewChar

Não é amigo , eu tentei , eu já dei um jeito aqui mas não era isso . problema foi tenso , mas vou procurar depois como arrumar , eu refiz a database do 0 , ai deu certo , mas vou olhar a db bugada pra fixar , pq esse erro pode acontecer novamente.

[neyerson]

ya esta el servidor prendido abro el cliente y me sale eso intento por el multicliente y se traba en el logo alguna solucion ?

[XxGhostSpiriTxX]

Originally Posted by neyerson

ya esta el servidor prendido abro el cliente y me sale eso intento por el multicliente y se traba en el logo alguna solucion ?

This forum speaks English, not Spanish ok!

pana todo el contenido que publiques tiene que ser en ingles no español!

[neyerson]

The server is already on, I open the client and I sell that I try for the multiclient and any solution is locked in the logo?

[ryaneichner]

Originally Posted by neyerson

The server is already on, I open the client and I sell that I try for the multiclient and any solution is locked in the logo?

Check Version on Server.cfg and make same version of Client .

Check Ip/Port or Filter if u use. !

Originally Posted by Play-Neon

Can u check triggers if u used old db might be name of some tables or db changed

Hello Sir. maybe its this the problem in Triggers , is possible i check this or edit this Triggers.