|
You last visited: Today at 19:19
Advertisement
Help
Discussion on Help within the Shaiya Private Server forum part of the Shaiya category.
12/08/2012, 19:49
|
#1
|
elite*gold: 0 
Join Date: Jun 2011
Posts: 218
Received Thanks: 153
|
Help
I translated some skills and when i execute skill.sql it gives me error
Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 2
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 3
String or binary data would be truncated.
The statement has been terminated.
some 1 can tell me why?
|
|
|
|
12/08/2012, 20:10
|
#2
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,981
|
Basically, you are entering a string longer than what it is set up to be.
You might want to refer to this article
|
|
|
|
|
12/08/2012, 20:23
|
#3
|
elite*gold: 0
Join Date: Jun 2011
Posts: 218
Received Thanks: 153
|
it affects the use of skills?
|
|
|
|
|
12/08/2012, 20:35
|
#4
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,981
|
Your query is not being executed, not sure what you are doing there, so I don't know if it would or would not affect it
|
|
|
|
|
12/08/2012, 20:37
|
#5
|
elite*gold: 92
Join Date: Aug 2009
Posts: 739
Received Thanks: 975
|
If you're from germany make sure you have no ÖÄÜ in it also no ' and special Charakters.
|
|
|
|
|
12/08/2012, 20:39
|
#6
|
elite*gold: 0
Join Date: Jun 2011
Posts: 218
Received Thanks: 153
|
i am not germany but i translate from russian language to english and skills are half english half russian
|
|
|
|
|
12/08/2012, 20:41
|
#7
|
elite*gold: 92
Join Date: Aug 2009
Posts: 739
Received Thanks: 975
|
String or Binary data are some ASCII Characters, Special Characters and ÖÄÜ.
Let them out if you use it.
If not, all i can say is the same as John: i'm not sure what are you doing
|
|
|
|
|
12/08/2012, 20:46
|
#8
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,981
|
What happens in here, if I got you right, is that what you are translating, for example, is meant to be a varchar(20) and during the translation you are putting a 22 characters long string, therefore this issue will be caused.
|
|
|
|
|
12/09/2012, 08:44
|
#9
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,456
|
What if I told you that you can run a query generated by ShStudio from the english Skill.SData ? It gets the job done in less than 1 minute.
|
|
|
|
|
12/09/2012, 08:48
|
#10
|
elite*gold: 0
Join Date: Jun 2011
Posts: 218
Received Thanks: 153
|
how? o_o
|
|
|
|
|
12/09/2012, 09:30
|
#11
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,456
|
Open Shaiya Studio -> Tools -> Settings and set a location to save server data.
Open an english Skill.SData in Shaiya Studio, do a small change then undo it so Shaiya Studio understands that you did something there, save it and check the folder where Shaiya Studio saves the server data, you'll find a file named Skill.sql there. Run that query. It will complete with errors, but those aren't affecting you at all.
|
|
|
|
|
12/09/2012, 09:35
|
#12
|
elite*gold: 0
Join Date: Jun 2011
Posts: 218
Received Thanks: 153
|
i mean translate desciption/skill name e.t.c
|
|
|
|
|
12/09/2012, 10:03
|
#13
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,456
|
Let me make this clear enough for you. What players see in game is in the client ONLY. What actually is/happens is server sided. If you want to change the skill names and description you need to do it in Skill.SData.
|
|
|
|
|
12/09/2012, 12:41
|
#14
|
elite*gold: 0
Join Date: Jul 2012
Posts: 61
Received Thanks: 118
|
Quote:
Originally Posted by nubness
Let me make this clear enough for you. What players see in game is in the client ONLY. What actually is/happens is server sided. If you want to change the skill names and description you need to do it in Skill.SData.
|
He Translated skills ep 6 russian to english. He want realeased ep 6 skill data on english language.
|
|
|
|
|
12/09/2012, 12:44
|
#15
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,456
|
Such a thing already exists. It was released by bulgaria.
|
|
|
|
All times are GMT +1. The time now is 19:19.
|
|
