Vincent 4 Posted November 10, 2013 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' Quote Share this post Link to post Share on other sites
0 jaBote 438 Posted November 10, 2013 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! 1 Mumbles reacted to this Quote Share this post Link to post Share on other sites
0 themon 63 Posted November 10, 2013 (edited) maybe it means you already updated that. just press stop. Edited November 10, 2013 by themon Quote Share this post Link to post Share on other sites
0 Vincent 4 Posted November 10, 2013 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>' Quote Share this post Link to post Share on other sites
0 Mhalicot 392 Posted November 11, 2013 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>' Quote Share this post Link to post Share on other sites
Hello,
i try to switch from rA to Hercules.
At the sql upgrade 2013-10-31--07-49.sql
i get this error:
Share this post
Link to post
Share on other sites