Fix error "Failed to creat a character. please try to connect again.(S1030)

Hi :w00t:

first sorry for my google english :ott1:
I struggled one week to find this fix :*: . I followed the tutorial that says to clean database. but this does not fix the problem.
I do not know much about sql but I find it does not support Data Type "nvarchar128" and I do not know how to do it for support but just choose "nvarchar50" and here are the steps to followed:



- Go to data base -> SRO_VT_SHARD -> tables -> System tables -> dbo._AccountJID -> Columns -> AccountID (with key) right clic (modify)

Attachment 109757

1- right clic the key "remove primary key"
2- choose "int" on Data Type then save (you can't save if you put "nvarchar(50)" directly)
3- again change int with "nvarchar(50)" then save again.

you can do the modification without restart game server or the client.:wink:

This rule fix the connection problem but I do not know if there are inappropriate after. but for now I have not had any problems.


http://c1109.hizliresim.com/11/9/16/6942.jpg

Français :

Salut

j'ai galéré 1 semaine pour trouver ce fix :*: . j'ai suivis les tutoriel qui disent de faire clean database. mais ce fix ne règle pas le problème.
je ne connais pas beaucoup en sql mais j'ai trouver qu'il ne support pas Data Type "nvarchar128" et je ne sais pas comment le faire supporter mais il suffit juste de choisir "nvarchar50" et voici les étapes qu'il faut suivre:


- va dans data base -> SRO_VT_SHARD -> tables -> System tables -> dbo._AccountJID -> Columns -> AccountID (avec la clé) clic droit (modify)

Attachment 109757

1- clic droit sur la clé "remove primary key"
2- choisis "int" dans Data Type puis sauvegarde ( tu ne peut pas sauvegarder si tu choisi (nvarchar(50) directement)
3- encors une fois change int par "nvarchar50" puis sauvegarde.

tu peut faire ces modifications en temps réel sans avoir à redémarrer Game server ou le client.

Ce fix règle le problème de connexion mais je ne sais pas s'il a des inconvenant après. mais pour le moment je n'ai pas eu de problème.

OR Clean database.

Quote:

---

Originally Posted by CEZALAND

OR Clean database.

---

cleaning an accounts data with its accounts is a bad idea thank you man :)

here say save not is permited >

wny know why?

dont any one help me? omg

This bug only appear if you delete manually chars from the database, if you do this, just make a new account and it will work again, np !

thanks it worked for me but any clue why we get this error and now everyobody?

Well, VARCHAR(128) works on my db.

Attachment 141075

I had this issue (S1030) once and the problem was because I truncated _Items table, turns out that we have to leave the dummy record untouched (the very first record with ID64 = 0)

I have a problen, all ways when I try so save it dont work.
Can someone help me?

not work :((

Can you help me ?