rAthena -> Hercules

[Shindu]

Okay so when im running the sql-files -> rAthena-main-upgrade.sql

I get errors;

ErrorSQL query:-- Upgrades for table `cart_inventory`ALTER TABLE `cart_inventory` MODIFY `bound` tinyint( 1 ) unsigned NOT NULL default '0';MySQL said: Documentation#1054 - Unknown column 'bound' in 'cart_inventory'
Both rAthena and Hercules and upto date.

 

[Mystery]

I dont think you have this SQL upgrade: https://github.com/HerculesWS/Hercules/blob/01e4647db2d5c635c7b4447f37663797a3f47b99/sql-files/upgrades/2013-10-31--07-49.sql

That upgrade adds the 'bound' column.

 

[Shindu]

Thats an Hercules upgrade or an rAthena upgrade?

I want to move from rAthena and come onto Hercules

 

[Mystery]

There's database upgrades from rAthena -> Hercules: https://github.com/HerculesWS/Hercules/tree/master/sql-files/upgrades

Especially mainly these two:

• https://github.com/HerculesWS/Hercules/blob/master/sql-files/upgrades/rAthena-main-upgrade.sql
  
• https://github.com/HerculesWS/Hercules/blob/master/sql-files/upgrades/rathena-logs-database-upgrade
  

 

[Shindu]

Thats what im saying, ive tried them i get the errors in my first post.

Both rAthena and Hercules are fully upto date.

 

[Nameless2you]

ALTER TABLE `cart_inventory` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
Shouldn't fail. Must be an issue on your side because both rAthena and Hercules have the column `bound`.

Check your db if your table `cart_inventory` has the column `bound`. If not add it by hand.

rAthena ->

CREATE TABLE IF NOT EXISTS `cart_inventory` ( `id` int(11) NOT NULL auto_increment, `char_id` int(11) NOT NULL default '0', `nameid` int(11) NOT NULL default '0', `amount` int(11) NOT NULL default '0', `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) NOT NULL default '0', `card0` smallint(11) NOT NULL default '0', `card1` smallint(11) NOT NULL default '0', `card2` smallint(11) NOT NULL default '0', `card3` smallint(11) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `bound` tinyint(3) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `char_id` (`char_id`)) ENGINE=MyISAM;

Hercules ->

CREATE TABLE IF NOT EXISTS `cart_inventory` (  `id` int(11) NOT NULL auto_increment,  `char_id` int(11) NOT NULL default '0',  `nameid` int(11) NOT NULL default '0',  `amount` int(11) NOT NULL default '0',  `equip` int(11) unsigned NOT NULL default '0',  `identify` smallint(6) NOT NULL default '0',  `refine` tinyint(3) unsigned NOT NULL default '0',  `attribute` tinyint(4) NOT NULL default '0',  `card0` smallint(11) NOT NULL default '0',  `card1` smallint(11) NOT NULL default '0',  `card2` smallint(11) NOT NULL default '0',  `card3` smallint(11) NOT NULL default '0',  `expire_time` int(11) unsigned NOT NULL default '0',  `bound` tinyint(1) unsigned NOT NULL default '0',  `unique_id` bigint(20) unsigned NOT NULL default '0',  PRIMARY KEY (`id`),  KEY `char_id` (`char_id`)) ENGINE=MyISAM;

 

[jaBote]

They're a bit outdated, I'm in process of renewing them when I have time.

Sadly they need to be remade every time rAthena or Hercules launch SQL updates, so that's a hard task to always keep updated.