Item Disappeared

[Myth]

when i got logout all my items in my inventory/equipment gone

 

heres the sql error

 

 

Info]: Loading Char Data (2000000)

[info]: Char load request (150000)

: DB error - Unknown column 'bound' in 'field list'

[Debug]: at c:\program files\rock\my ragnarok files\src\char\char.c:1308 - SELECT `id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `expire_time`, `favorite`, `bound`, `unique_id`, `card0`, `card1`, `card2`, `card3` FROM `inventory` WHERE `char_id`=? LIMIT 100

[sql]: DB error - Statement not prepared

[Debug]: at c:\program files\rock\my ragnarok files\src\char\char.c:1339 - SELECT `id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `expire_time`, `bound`, `unique_id`, `card0`, `card1`, `card2`, `card3` FROM `cart_inventory` WHERE `char_id`=? LIMIT 100

[sql]: DB error - Unknown column 'bound' in 'field list'

[Debug]: at c:\program files\rock\my ragnarok files\src\char\int_storage.c:47 - SELECT `id`,`nameid`,`amount`,`equip`,`identify`,`refine`,`attribute`,`expire_time`,`bound`,`unique_id`,`card0`,`card1`,`card2`,`card3` FROM `storage` WHERE `account_id`='2000000' ORDER BY `nameid`

[sql]: DB error - Statement not prepared

[info]: storage load complete from DB - id: 2000000 (total: 0)

[sql]: DB error - Unknown column 'bound' in 'field list'

 

 

 

 

they got invisible

 

m using SVN Revision: '17378'. 

Edited July 11, 2013 by Myth

[Patskie]

Execute this on your database :

ALTER TABLE `inventory` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `favorite`;
ALTER TABLE `cart_inventory` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL default '0' AFTER `expire_time`;
ALTER TABLE `storage` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL default '0' AFTER `expire_time`;
ALTER TABLE `guild_storage` ADD COLUMN `bound` TINYINT(3) UNSIGNED NOT NULL default '0' AFTER `expire_time`;

[Myth]

where? in ragnarok sql?

the same with equipment

[Patskie]

Yaa ragnarok sql. There is an upgrade of sql on trunk/sql-files/upgrades/upgrade_svn17351.sql at SVN 17351.