help please i got this error when i was add item

08/16/2017 12:42 Donjiwan#1

any help ?
pic
[Only registered and activated users can see links. Click Here To Register...]

08/16/2017 16:24 SubZero**#2

fix maxstack~Durability in this item add maxstack and durability if this item like weapon
else
add 0 in durability

08/20/2017 07:22 EdwardTeach+-#3

Error data that is a durability or maxstack of a item

query fix >

Code:

UPDATE dbo._RefScrapOfPackageItem
SET Data = i.Dur_L
FROM dbo._RefScrapOfPackageItem s with(NOLOCK) 
JOIN dbo._RefObjCommon r with(NOLOCK) on s.RefItemCodeName = r.CodeName128 
JOIN dbo._RefObjItem i with(NOLOCK) on r.Link = i.ID 
WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 in (1,2,3,4,6,9,10,11) AND r.[Service] = 1

Cheers.