Jump to content
  • 0
Sign in to follow this  
Vincent

SQL update

Question

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'  

 

 

 

 

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

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!

Share this post


Link to post
Share on other sites
  • 0

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

Edited by themon

Share this post


Link to post
Share on other sites
  • 0

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>'

Share this post


Link to post
Share on other sites
  • 0

 

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>'

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.