Question

[deso]

I tried to update my svn from 17339 to 17400. My problem is all of my items are lost.

 

[Archetype Saber]

how did you update your svn ?

[Patskie]

There's an upgrade of SQL on SVN 17351. trunk/sql-files/upgrades/upgrade_svn17351.sql

 

Execute this :

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`;

[deso]

I update it with svn checkout.

 

 

There's an upgrade of SQL on SVN 17351. trunk/sql-files/upgrades/upgrade_svn17351.sql

 

Execute this :

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`;

 

Sir how will I execute it?

[Patskie]

I update it with svn checkout.

 

 

 

There's an upgrade of SQL on SVN 17351. trunk/sql-files/upgrades/upgrade_svn17351.sql

 

Execute this :

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`;

 

Sir how will I execute it?

http://lmgtfy.com/?q=execute%20sql%20query%20on%20phpmyadmin