rAthena -> Hercules

[Shindu 0]

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 594]

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 0]

Thats an Hercules upgrade or an rAthena upgrade?

 

I want to move from rAthena and come onto Hercules

[Mystery 594]

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 0]

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

 

Both rAthena and Hercules are fully upto date.

[Nameless2you 97]

 

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 438]

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.