Accounts table doesn't exist?

[Reyia]

I am following the guide on building a server. In the instructions you can import the sql files via batch file or manually import them. I have tried to do the batch file and I receive the error that it doesn't understand mysqladmin command. So I decided to do it manually via Navicat. When running the batch sql files (importing the tables). I have a issue with the accounts.sql file.

Here is the error:

Code: Select all

[Err] 1050 - Table 'abilities' already exists
[Err] -- ----------------------------
-- Table structure for abilities
-- ----------------------------
CREATE TABLE `abilities` (
  `abilityId` smallint(5) unsigned NOT NULL,
  `name` tinytext,
  `job` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `level` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `validTarget` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `recastTime` smallint(5) unsigned NOT NULL DEFAULT '0',
  `recastId` smallint(5) unsigned NOT NULL DEFAULT '0',
  `message1` smallint(5) unsigned NOT NULL DEFAULT '0',
  `message2` smallint(5) unsigned NOT NULL DEFAULT '0',
  `animation` smallint(5) unsigned NOT NULL DEFAULT '0',
  `range` float(3,1) unsigned NOT NULL DEFAULT '0.0',
  `isAOE` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `CE` smallint(5) NOT NULL DEFAULT '0',
  `VE` smallint(5) NOT NULL DEFAULT '0',
  `meritModID` smallint(4) NOT NULL DEFAULT '0',
  `addType` smallint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`abilityId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=56;
[Err] 1062 - Duplicate entry '0' for key 'PRIMARY'
[Err] -- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `abilities` VALUES ('0', 'mighty_strikes', '1', '0', '1', '7200', '0', '0', '0', '33', '20.0', '0', '1', '300', '0', '0');
[Err] 1062 - Duplicate entry '1' for key 'PRIMARY'
[Err] INSERT INTO `abilities` VALUES ('1', 'hundred_fists', '2', '0', '1', '7200', '0', '0', '0', '34', '20.0', '0', '1', '300', '0', '0');
[Err] 1062 - Duplicate entry '2' for key 'PRIMARY'
[Err] INSERT INTO `abilities` VALUES ('2', 'benediction', '3', '0', '1', '7200', '0', '102', '0', '35', '20.0', '1', '0', '0', '0', '0');
[Err] 1062 - Duplicate entry '3' for key 'PRIMARY'
[Err] INSERT INTO `abilities` VALUES ('3', 'manafont', '4', '0', '1', '7200', '0', '0', '0', '36', '20.0', '0', '1', '0', '0', '0');
[Err] 1062 - Duplicate entry '4' for key 'PRIMARY'
[Err] INSERT INTO `abilities` VALUES ('4', 'chainspell', '5', '0', '1', '7200', '0', '0', '0', '37', '20.0', '0', '1', '0', '0', '0');
[Err] 1062 - Duplicate entry '5' for key 'PRIMARY'
[Err] INSERT INTO `abilities` VALUES ('5', 'perfect_dodge', '6', '0', '1', '7200', '0', '0', '0', '38', '20.0', '0', '1', '0', '0', '0');

All the other sql files imported without issues except triggers.sql The guide states if you have issues follow this step: Open accounts table. I can't do this due to the accounts.sql (table) doesn't exist.
Do we have an updated accounts.sql file somewhere?

Thanks.

[kjLotus]

that is your accounts.sql file? that looks like the content of abilities.sql (without the drop statement, which would be the cause of the error)

this is what accounts.sql should look like: https://code.google.com/p/onetimexi/sou ... counts.sql

i don't know how the batch file works, as i've never used it, but i guess it messed up your accounts.sql file?

[Reyia]

kjLotus that worked I needed to get the svn again for the sql folder. THANK YOU!