View Single Post
  #6  
Old 03-12-2012, 02:01 AM
Warking
Hill Giant
 
Join Date: Mar 2012
Location: Norrath
Posts: 132
Default Exwcuting .SQLs

Many of the "required" .sql files to execute have errors similar to the below. Is this ok ?

For example:

Queries: 40
Processed: 1
Errors: 39

[Err] 1050 - Table 'aa_required_level_cost' already exists
[Err] --
-- Table structure for table `aa_required_level_cost`
--

CREATE TABLE `aa_required_level_cost` (
`skill_id` int(10) unsigned NOT NULL,
`level` int(10) unsigned NOT NULL,
`cost` int(10) unsigned NOT NULL default '0',
`description` varchar(64) default NULL COMMENT 'For reference only',
PRIMARY KEY (`skill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[Err] 1062 - Duplicate entry '7800' for key 'PRIMARY'
[Err] --
-- Dumping data for table `aa_required_level_cost`
--

INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7800, 1, 0, 'Harm Touch');
[Err] 1062 - Duplicate entry '7801' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7801, 6, 0, 'Harm Touch');
[Err] 1062 - Duplicate entry '7802' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7802, 11, 0, 'Harm Touch');
[Err] 1062 - Duplicate entry '7803' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7803, 16, 0, 'Harm Touch');
[Err] 1062 - Duplicate entry '7804' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7804, 21, 0, 'Harm Touch');
[Err] 1062 - Duplicate entry '7805' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7805, 26, 0, 'Harm Touch');
[Err] 1062 - Duplicate entry '7806' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7806, 31, 0, 'Harm Touch');
[Err] 1062 - Duplicate entry '7807' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7807, 36, 0, 'Harm Touch');
[Err] 1062 - Duplicate entry '7808' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7808, 41, 0, 'Harm Touch');
[Err] 1062 - Duplicate entry '7809' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7809, 46, 0, 'Harm Touch');
[Err] 1062 - Duplicate entry '7810' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7810, 51, 3, 'Harm Touch');
[Err] 1062 - Duplicate entry '7811' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7811, 56, 4, 'Harm Touch');
[Err] 1062 - Duplicate entry '7812' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7812, 61, 5, 'Harm Touch');
[Err] 1062 - Duplicate entry '7813' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7813, 66, 6, 'Harm Touch');
[Err] 1062 - Duplicate entry '7814' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7814, 71, 7, 'Harm Touch');
[Err] 1062 - Duplicate entry '7815' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7815, 76, 8, 'Harm Touch');
[Err] 1062 - Duplicate entry '7816' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7816, 81, 8, 'Harm Touch');
[Err] 1062 - Duplicate entry '7817' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7817, 83, 9, 'Harm Touch');
[Err] 1062 - Duplicate entry '7850' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7850, 5, 0, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7851' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7851, 11, 0, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7852' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7852, 16, 0, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7853' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7853, 21, 0, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7854' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7854, 26, 0, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7855' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7855, 31, 0, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7856' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7856, 36, 0, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7857' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7857, 41, 0, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7858' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7858, 46, 0, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7859' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7859, 51, 0, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7860' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7860, 56, 3, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7861' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7861, 61, 4, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7862' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7862, 66, 5, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7863' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7863, 71, 6, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7864' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7864, 76, 7, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7865' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7865, 81, 8, 'Lay on Hands');
[Err] 1062 - Duplicate entry '7866' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (7866, 85, 9, 'Lay on Hands');
[Err] 1062 - Duplicate entry '593' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (593, 61, 2, 'Fervent Blessing');
[Err] 1062 - Duplicate entry '594' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (594, 63, 4, 'Fervent Blessing');
[Err] 1062 - Duplicate entry '595' for key 'PRIMARY'
[Err] INSERT INTO `aa_required_level_cost` (`skill_id`, `level`, `cost`, `description`) VALUES (595, 65, 6, 'Fervent Blessing');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Reply With Quote