bug in chest

08/11/2020 14:14 Worshiper#1
[SR_GameServer] Invalid Inventory Information! OBJDBID[119225] Slot[1] Item[0]

i got this error in gameserver happen to some chars when they are going to put anything in storage they get dc
when i check the dbo.chest i find that the slot 0 has itemid=1 and there is nothing in storage in this chars
use SRO_VT_SHARD
select * from dbo._Chest where ItemID =1

if i do update set itemid=0 that will fix the bug but its keep happen to some other chars does anyone know how i can fix it ?
use SRO_VT_SHARD
update _Chest set ItemID =0 where ItemID= 1

UP
08/20/2020 13:50 Worshiper#2
UP
08/20/2020 14:03 Beba Army#3
I am a totally useless person in these cases, but yes, as i know, 0 = 1 in sro db at least.
08/20/2020 19:53 #HB#4
Quote:
Originally Posted by Beba Army View Post
I am a totally useless person in these cases, but yes, as i know, 0 = 1 in sro db at least.
???
08/20/2020 20:21 JohnDornel^#5
Quote:
Originally Posted by Beba Army View Post
I am a totally useless person in these cases, but yes, as i know, 0 = 1 in sro db at least.
I am sorry, but this is just pure gold... :handsdown:
08/21/2020 20:09 Worshiper#6
is there any hint about it ?
08/22/2020 14:53 Piskota#7
Quote:
Originally Posted by [GM]Dejo View Post
is there any hint about it ?
Whats that item which one has ID =1? A hot fix is disabling it from refobjcommmon if not important. However i guess some of your procedures got messed up, try to copy the basic one from another reliable DB.
08/22/2020 14:55 Worshiper#8
Quote:
Originally Posted by Piskota View Post
Whats that item which one has ID =1? A hot fix is disabling it from refobjcommmon if not important. However i guess some of your procedures got messed up, try to copy the basic one from another reliable DB.
There is no items the slot is empty Which procedure because i copied chest proc From original database and still same error to fix issue i need to do this query
use SRO_VT_SHARD
update _Chest set ItemID =0 where ItemID= 1

UP