Cannot delete char in database without error

[Sh1ftx]

When I go to the "Char" Table in "SRO VT SHARD" and want to delete a char (in this case a GM char) then I get "Failed to connect to server (C10)" after logging in.

It seems to be working when I delete the char ingame manually (but I have to wait 7 days).

Is that normal?

[Leodoom]

use sro_vt_shard
select * from _StaticAvatar where CharID in (select CharID from _Char where Deleted =1)
select * from _TimedJob where CharID in (select CharID from _Char where Deleted =1)
select * from _CharSkill where CharID in (select CharID from _Char where Deleted =1)
select * from _CharSkillMastery where CharID in (select CharID from _Char where Deleted =1)
select * from _Inventory where CharID in (select CharID from _Char where Deleted =1)
select * from _Friend where CharID in (select CharID from _Char where Deleted =1)
select * from _Friend where FriendCharID in (select CharID from _Char where Deleted =1)
select * from _Memo where CharID in (select CharID from _Char where Deleted =1)
select * from _Char where Deleted =1

1= ID CHar

[Sh1ftx]

Originally Posted by Leodoom

1= ID CHar

Not sure what you mean by that because it doesn't work when I change the "1" to the name of my character.

I have tried setting "Deleted" to "1" and executed the query but it didn't help/work.

[Leodoom]

1 no name you Char
1= ID Char
Meaning you Char name SH1ftx in tap _Char

ID 5555 Char name SH1ftx

select * from _Friend where CharID in (select CharID from _Char where Deleted =5555)
select * from _Friend where FriendCharID in (select CharID from _Char where Deleted =5555)
select * from _Memo where CharID in (select CharID from _Char where Deleted =5555)
select * from _Char where Deleted =5555


Do you understand me

[Sh1ftx]

Originally Posted by Leodoom

1 no name you Char
1= ID Char
Meaning you Char name SH1ftx in tap _Char

ID 5555 Char name SH1ftx

select * from _Friend where CharID in (select CharID from _Char where Deleted =5555)
select * from _Friend where FriendCharID in (select CharID from _Char where Deleted =5555)
select * from _Memo where CharID in (select CharID from _Char where Deleted =5555)
select * from _Char where Deleted =5555


Do you understand me

I understood you now, thank you. But it didn't change anything unfortunately.