|
You last visited: Today at 17:34
Advertisement
Item.sql erro String or binary data would be truncated.
Discussion on Item.sql erro String or binary data would be truncated. within the Shaiya PServer Development forum part of the Shaiya Private Server category.
08/17/2019, 20:23
|
#1
|
elite*gold: 220
Join Date: Jul 2018
Posts: 85
Received Thanks: 22
|
Item.sql erro String or binary data would be truncated.
I noticed this error in the query, when inject in my database, presents several lines of errors, I tried to correct straight in the item.sdata replacing the item configuration, or attempts of Erase Item, but the error continues, does anyone have any solution? for this?
Code:
Msg 8152, Level 16, State 14, Line 50
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 51
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 52
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 53
String or binary data would be truncated.
The statement has been terminated.
|
|
|
08/17/2019, 20:45
|
#2
|
elite*gold: 0
Join Date: Jul 2010
Posts: 511
Received Thanks: 513
|
One of the values you're inserting is bigger than the field width.
Example: You have a varchar(5) field, and you try to insert 'aaaaaaaaaa', that string won't fit in 5 chars.
May be some item's name is too long to fit in ItemName field.
|
|
|
08/17/2019, 20:55
|
#3
|
elite*gold: 220
Join Date: Jul 2018
Posts: 85
Received Thanks: 22
|
Quote:
Originally Posted by sominus
One of the values you're inserting is bigger than the field width.
Example: You have a varchar(5) field, and you try to insert 'aaaaaaaaaa', that string won't fit in 5 chars.
May be some item's name is too long to fit in ItemName field.
|
I checked the error items, and deleted the items, but the errors are still on the same line.
|
|
|
08/17/2019, 21:42
|
#4
|
elite*gold: 0
Join Date: Jul 2010
Posts: 511
Received Thanks: 513
|
You could run just the block that gives the error (delete the lines before and after). Try modify strings in those lines, etc to find where the error comes from. Just remember to make a copy of the Items table before (in case something goes wrong)
|
|
|
08/17/2019, 23:48
|
#5
|
elite*gold: 220
Join Date: Jul 2018
Posts: 85
Received Thanks: 22
|
Quote:
Originally Posted by sominus
You could run just the block that gives the error (delete the lines before and after). Try modify strings in those lines, etc to find where the error comes from. Just remember to make a copy of the Items table before (in case something goes wrong)
|
I removed all error lines, and the error still exists even though I leave the line blank
Code:
Msg 8152, Level 16, State 14, Line 39
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 50
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 51
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 52
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 53
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 63
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 23
String or binary data would be truncated.
The statement has been terminated.
(1 row(s) affected)
Msg 8152, Level 16, State 14, Line 33
String or binary data would be truncated.
The statement has been terminated.
(1 row(s) affected)
Msg 8152, Level 16, State 14, Line 35
String or binary data would be truncated.
The statement has been terminated.
(1 row(s) affected)
Msg 8152, Level 16, State 14, Line 13
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 14, Line 14
String or binary data would be truncated.
The statement has been terminated.
|
|
|
08/18/2019, 05:29
|
#6
|
elite*gold: 0
Join Date: Jul 2010
Posts: 511
Received Thanks: 513
|
Try posting one of those lines
|
|
|
08/19/2019, 00:38
|
#7
|
elite*gold: 0
Join Date: Jul 2010
Posts: 511
Received Thanks: 513
|
You have a few items with name longer than 30 chars.
Example: 'Símbolos de Colecionador da Luz (150)' has 37 chars long, and ItemName field only allow 30 chars. You have to make the item name shorter.
Also you have accents (áéíóú), so you would need to change te collation for your Items table, to support accents.
Right click Item table, choose DESIGN, go to 'Column Properties', search for 'Collation' and change it to 'Latin1_General_CI_AI'
And try to run the script again (it worked for me).
REMEMBER to make a backup or copy of the Items table before any changes.
|
|
|
08/19/2019, 06:55
|
#8
|
elite*gold: 220
Join Date: Jul 2018
Posts: 85
Received Thanks: 22
|
Quote:
Originally Posted by sominus
You have a few items with name longer than 30 chars.
Example: 'Símbolos de Colecionador da Luz (150)' has 37 chars long, and ItemName field only allow 30 chars. You have to make the item name shorter.
Also you have accents (áéíóú), so you would need to change te collation for your Items table, to support accents.
Right click Item table, choose DESIGN, go to 'Column Properties', search for 'Collation' and change it to 'Latin1_General_CI_AI'
And try to run the script again (it worked for me).
REMEMBER to make a backup or copy of the Items table before any changes.
|
Problem fixed, really was that, thanks
This topic can already be closed.
|
|
|
|
Similar Threads
|
[How-To-Fix] Error 1265 - Data truncated for column '' at row
03/28/2023 - Metin2 PServer Guides & Strategies - 7 Replies
Intro
Almost any of you got such an error when you tried to import your own mysql backups via .sql, at least, once in your lifetime, instead of using mysqldump.
Anyway, you can get this weird error on tables such as player.mob_proto and player.skill_proto.
#skill_proto
1265 - Data truncated for column 'setAffectFlag' at row 1
1265 - Data truncated for column 'setFlag' at row 1
#mob_proto
1265 - Data truncated for column 'size' at row 1
#and so on
|
Data truncated for column 'size' at row 1
11/25/2014 - Metin2 Private Server - 3 Replies
http://i.epvpimg.com/ii2Wf.png
Decompressing...
Table Created: affect
Table Created: banword
Table Created: change_empire
Table Created: costume_system
Table Created: guild
Table Created: guild_comment
Table Created: guild_grade
|
[MySQL] Data truncated for column -> bitte um Hilfe
01/22/2014 - Metin2 Private Server - 2 Replies
http://i.epvpimg.com/G4Wih.png Mobproto hab ich auch komplett entfernt und jegliche gefundene .sql's aus EPvP ausprobiert, jedesmal der selbe Fehler KEINE Ahnung warum .. Bitte um Hilfe bin echt am verzweifeln daran
|
Data truncated for column 'size' at row 1
04/16/2013 - Metin2 Private Server - 0 Replies
http://i.epvpimg.com/ii2Wf.png
Decompressing...
Table Created: affect
Table Created: banword
Table Created: change_empire
Table Created: costume_system
Table Created: guild
Table Created: guild_comment
Table Created: guild_grade
|
All times are GMT +2. The time now is 17:34.
|
|