SQL update

[Vincent 4]

Hello,

i try to switch from rA to Hercules.

 

At the sql upgrade 2013-10-31--07-49.sql

 

i get this error:

 

FehlerSQL-Befehl:#1383205740ALTER TABLE  `inventory` ADD COLUMN  `bound` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT  '0' AFTER  `favorite` ;MySQL meldet: Dokumentation#1060 - Duplicate column name 'bound'  

 

 

 

 

[jaBote 438]

Hi.
 
Are you trying to make a direct upgrade from rAthena to Hercules by running our upgrades on top of a rAthena database? This doesn't work that way.
 
Try to get your rAthena database to its original state, then make a backup and work on the backup. Try using these upgrades I've just revised:
 
This one for the main database upgrade:

-- rAthena to Hercules main database upgrade query.-- This upgrades a FULLY UPGRADED rAthena to a FULLY UPGRADED Hercules-- Please don't use if either rAthena or Hercules launched a SQL update after last revision date of this file.-- Remember to make a backup before applying.-- We are not liable for any data loss this may cause.-- Apply in the same database you applied your main.sql-- Last revision: November 10, 2013, 19:00-- Drop table `skillcooldown` since it's not used in HerculesDROP TABLE IF EXISTS `skillcooldown`;-- Upgrades for table `cart_inventory`ALTER TABLE `cart_inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0',	MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';-- Upgrades for table `char`ALTER TABLE `char` DROP COLUMN `moves`,	ADD `slotchange` SMALLINT(3) UNSIGNED NOT NULL default '0',	ADD `char_opt` INT( 11 ) UNSIGNED NOT NULL default '0',	ADD `font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT  '0';-- Upgrades for table `guild_storage`ALTER TABLE `guild_storage` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0',	MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';-- Upgrades for table `inventory`ALTER TABLE `inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0',	MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';---- Table structure for table `sql_updates`--CREATE TABLE IF NOT EXISTS `sql_updates` (  `timestamp` int(11) unsigned NOT NULL,  `ignored` enum('Yes','No') NOT NULL DEFAULT 'No',  PRIMARY KEY (`timestamp`)) ENGINE=MyISAM;-- Existent updates to enterINSERT INTO `sql_updates` (`timestamp`) VALUES (1360858500);INSERT INTO `sql_updates` (`timestamp`) VALUES (1360951560);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362445531);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362528000);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362794218);INSERT INTO `sql_updates` (`timestamp`) VALUES (1364409316);INSERT INTO `sql_updates` (`timestamp`) VALUES (1366075474);INSERT INTO `sql_updates` (`timestamp`) VALUES (1366078541);INSERT INTO `sql_updates` (`timestamp`) VALUES (1381354728);INSERT INTO `sql_updates` (`timestamp`) VALUES (1381423003);INSERT INTO `sql_updates` (`timestamp`) VALUES (1382892428);INSERT INTO `sql_updates` (`timestamp`) VALUES (1383162785);INSERT INTO `sql_updates` (`timestamp`) VALUES (1383167577);INSERT INTO `sql_updates` (`timestamp`) VALUES (1383205740);INSERT INTO `sql_updates` (`timestamp`) VALUES (1383955424);-- Updates to table `storage`ALTER TABLE `storage` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0',	MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';---- Table structure for table `account_data`--CREATE TABLE IF NOT EXISTS `account_data` (  `account_id` int(11) unsigned NOT NULL default '0',  `bank_vault` int(11) unsigned NOT NULL default '0',  `base_exp` TINYINT( 4 ) UNSIGNED NOT NULL default '100',  `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL default '100',  `base_death` TINYINT( 4 ) UNSIGNED NOT NULL default '100',  PRIMARY KEY  (`account_id`)) ENGINE=MyISAM; -- Saving bank_vault data from rAthena's login table-- to our account_data table. There may be some not working cases.INSERT INTO `account_data` (`account_id`, `bank_vault`) SELECT `account_id`, `bank_vault` FROM `login` WHERE `bank_vault` > 0 ;-- Dropping bank_vault column from login tableALTER TABLE `login` DROP COLUMN `bank_vault`;

upaste.me mirror: http://upaste.me/7fbc8490ebb57a6a
 
 
And this one for the logs database:

-- rAthena to Hercules log database upgrade query.-- This upgrades a FULLY UPGRADED rAthena to a FULLY UPGRADED Hercules-- Please don't use if either rAthena or Hercules launched a SQL update after last revision date of this file.-- Remember to make a backup before applying.-- We are not liable for any data loss this may cause.-- Apply in the same database you applied your logs.sql-- Last revision: November 10, 2013, 19:00-- Upgrades to table `picklog`ALTER TABLE `picklog` MODIFY `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U') NOT NULL default 'P';-- Drop table `cashlog` since it's not used in HerculesDROP TABLE IF EXISTS `cashlog`;

upaste.me mirror: http://upaste.me/a011849121f6f38c
 
Hope this helps you!

[themon 63]

maybe it means you already updated that. just press stop.

Edited November 10, 2013 by themon

[Vincent 4]

But if i start the server:

 

[SQL]: - detected 2 new SQL updates[SQL]: -- 'sql-files/upgrades/2013-04-16--01-24.sql'[SQL]: -- 'sql-files/upgrades/2013-10-31--07-49.sql'[SQL]: To manually skip, type: 'sql update skip <file name>'

[Mhalicot 392]

 

But if i start the server:

 

[SQL]: - detected 2 new SQL updates[SQL]: -- 'sql-files/upgrades/2013-04-16--01-24.sql'[SQL]: -- 'sql-files/upgrades/2013-10-31--07-49.sql'[SQL]: To manually skip, type: 'sql update skip <file name>'

if the files is already added of has #1060 - Duplicate

in your map-server.exe type To manually skip, type: 'sql update skip <file name>'