Cannot delete char in database without error

12/24/2018 17:33 Sh1ftx#1
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?
12/24/2018 23:35 Leodoom#2
Quote:
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
12/26/2018 16:47 Sh1ftx#3
Quote:
Originally Posted by Leodoom View Post
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.
12/26/2018 23:37 Leodoom#4
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
12/28/2018 20:27 Sh1ftx#5
Quote:
Originally Posted by Leodoom View Post
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.