[Help]sql files failed to install

hidde · April 19, 2012

hey guys, i'm using l2j server interlude project, when i'm installing DB, it gives me an error, some sql files can't install

example

first error armor.sql

i'm noob in l2java and please dont beat me :D

p.s i'm using win 7 ultimate 64 bit SP1

Zaldron · April 19, 2012

press "C" and when u finish the installation add the armor.sql to navicat alone.

hidde · April 19, 2012

there is also other errors with other sql files, maybe 10 or more error

armor.sql

-- 
-- Table structure for table `armor`
-- 

DROP TABLE IF EXISTS `armor`;
CREATE TABLE `armor` (
  `item_id` int(11) NOT NULL default '0',
  `name` varchar(70) default NULL,
  `bodypart` varchar(15) NOT NULL default '',
  `crystallizable` varchar(5) NOT NULL default '',
  `armor_type` varchar(5) NOT NULL default '',
  `weight` int(5) NOT NULL default '0',
  `material` varchar(15) NOT NULL default '',
  `crystal_type` varchar(4) NOT NULL default '',
  `avoid_modify` int(1) NOT NULL default '0',
  `duration` int(3) NOT NULL default '0',
  `p_def` int(3) NOT NULL default '0',
  `m_def` int(2) NOT NULL default '0',
  `mp_bonus` int(3) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `crystal_count` int(4) default NULL,
  `sellable` varchar(5) default NULL,
  `dropable` varchar(5) default NULL,
  `destroyable` varchar(5) default NULL,
  `tradeable` varchar(5) default NULL,
  `item_skill_id` decimal(11,0) NOT NULL default '0',
  `item_skill_lvl` decimal(11,0) NOT NULL default '0',
  PRIMARY KEY  (`item_id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `armor`

INSERT INTO `armor` VALUES 
('21','Shirt','chest','false','light','4830','cloth','none','0','-1','36','0','0','147','0','true','true','true','true','0','0'),
('22','Leather Shirt','chest','false','light','4830','leather','none','0','-1','43','0','0','2430','0','true','true','true','true','0','0'),
('23','Wooden Breastplate','chest','false','light','4820','wood','none','0','-1','47','0','0','7960','0','true','true','true','true','0','0'),
('24','Bone Breastplate','chest','false','light','4770','bone','none','0','-1','50','0','0','20300','0','true','true','true','true','0','0'),
('25','Piece Bone Breastplate','chest','false','heavy','8970','bone','none','0','-1','62','0','0','31800','0','true','true','true','true','0','0'),
('26','Bronze Breastplate','chest','false','heavy','8920','bronze','none','0','-1','68','0','0','49200','0','true','true','true','true','0','0'),
('27','Hard Leather Shirt','chest','false','light','4720','leather','none','0','-1','53','0','0','36900','0','true','true','true','true','0','0'),
('28','Pants','legs','false','light','1740','cloth','none','0','-1','22','0','0','92','0','true','true','true','true','0','0'),
('29','Leather Pants','legs','false','light','1730','leather','none','0','-1','27','0','0','1520','0','true','true','true','true','0','0'),
('30','Hard Leather Pants','legs','false','light','1700','leather','none','0','-1','29','0','0','4970','0','true','true','true','true','0','0'),
('31','Bone Gaiters','legs','false','light','1680','bone','none','0','-1','32','0','0','12700','0','true','true','true','true','0','0'),
('32','Piece Bone Gaiters','legs','false','heavy','4020','bone','none','0','-1','39','0','0','19900','0','true','true','true','true','0','0'),
('33','Hard Leather Gaiters','legs','false','light','1610','leather','none','0','-1','33','0','0','23000','0','true','true','true','true','0','0'),
('34','Bronze Gaiters','legs','false','heavy','3960','bronze','none','0','-1','43','0','0','30700','0','true','true','true','true','0','0'),
('35','Cloth Shoes','feet','false','none','1320','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('36','Leather Sandals','feet','false','none','1320','leather','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('37','Leather Shoes','feet','false','none','1320','leather','none','0','-1','13','0','0','2650','0','true','true','true','true','0','0'),
('38','Low Boots','feet','false','none','1320','leather','none','0','-1','15','0','0','6770','0','true','true','true','true','0','0'),
('39','Boots','feet','false','none','1310','cloth','none','0','-1','17','0','0','12300','0','true','true','true','true','0','0'),
('40','Leather Boots','feet','true','none','1300','leather','d','0','-1','19','0','0','20900','38','true','true','true','true','0','0'),
('41','Cloth Cap','head','false','none','660','cloth','none','0','-1','13','0','0','55','0','true','true','true','true','0','0'),
('42','Leather Cap','head','false','none','660','leather','none','0','-1','16','0','0','911','0','true','true','true','true','0','0'),
('43','Wooden Helmet','head','false','none','660','wood','none','0','-1','19','0','0','3980','0','true','true','true','true','0','0'),
('44','Leather Helmet','head','false','none','650','leather','none','0','-1','23','0','0','10200','0','true','true','true','true','0','0'),
('45','Bone Helmet','head','true','none','640','bone','d','0','-1','29','0','0','31300','56','true','true','true','true','0','0'),
('46','Bronze Helmet','head','true','none','630','bronze','d','0','-1','33','0','0','50000','90','true','true','true','true','0','0'),
('47','Helmet','head','true','none','640','fine_steel','d','0','-1','37','0','0','76200','138','true','true','true','true','0','0'),
('48','Short Gloves','gloves','false','none','660','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('49','Gloves','gloves','false','none','660','cloth','none','0','-1','13','0','0','2650','0','true','true','true','true','0','0'),
('50','Leather Gloves','gloves','false','none','650','leather','none','0','-1','15','0','0','6770','0','true','true','true','true','0','0'),
('51','Bracer','gloves','false','none','650','leather','none','0','-1','17','0','0','12300','0','true','true','true','true','0','0'),
('52','Hemp Cloak','underwear','false','none','260','cloth','none','0','-1','2','0','0','37','0','true','true','true','true','0','0'),
('53','Cotton Cloak','underwear','false','none','250','cloth','none','0','-1','3','0','0','607','0','true','true','true','true','0','0'),
('54','Silk Cloak','underwear','false','none','250','cloth','none','0','-1','4','0','0','2650','0','true','true','true','true','0','0'),
('55','Cotton Undergarment','underwear','false','none','170','cotton','none','0','-1','4','0','0','18','0','true','true','true','true','0','0'),
('56','Wool Undergarment','underwear','false','none','170','wood','none','0','-1','5','0','0','304','0','true','true','true','true','0','0'),
('58','Mithril Breastplate','chest','true','heavy','8670','mithril','d','0','-1','95','0','0','183000','332','true','true','true','true','0','0'),
('59','Mithril Gaiters','legs','true','heavy','3830','mithril','d','0','-1','61','0','0','127000','230','true','true','true','true','0','0'),
('60','Composite Armor','fullarmor','true','heavy','10980','fine_steel','c','0','-1','224','0','0','1440000','576','true','true','true','true','0','0'),
('61','Mithril Gloves','gloves','true','none','630','mithril','d','0','-1','29','0','0','97800','177','true','true','true','true','0','0'),
('62','Mithril Boots','feet','true','none','1230','leather','c','0','-1','32','0','0','126000','50','true','true','true','true','0','0'),
('63','Gauntlets','gloves','true','none','640','cloth','d','0','-1','24','0','0','50800','92','true','true','true','true','0','0'),
('64','Composite Boots','feet','true','none','1220','fine_steel','c','0','-1','36','0','0','245000','98','true','true','true','true','0','0'),
('112','Apprentice\'s Earring','rear,lear','false','none','150','silver','none','0','-1','0','11','0','49','0','true','true','true','true','0','0'),
('113','Mystic\'s Earring','rear,lear','false','none','150','silver','none','0','-1','0','13','0','811','0','true','true','true','true','0','0'),
('114','Earring of Strength','rear,lear','false','none','150','gold','none','0','-1','0','16','0','3510','0','true','true','true','true','0','0'),
('115','Earring of Wisdom','rear,lear','false','none','150','gold','none','0','-1','0','16','0','3510','0','true','true','true','true','0','0'),
('116','Magic Ring','rfinger,lfinger','false','none','150','gold','none','0','-1','0','7','0','33','0','true','true','true','true','0','0'),
('117','Ring of Mana','rfinger,lfinger','true','none','150','silver','b','0','-1','0','34','0','404000','53','true','true','true','true','0','0'),
('118','Necklace of Magic','neck','false','none','150','silver','none','0','-1','0','15','0','66','0','true','true','true','true','0','0'),
('119','Necklace of Binding','neck','true','none','150','adamantaite','c','0','-1','0','64','0','565000','226','true','true','true','true','0','0'),
('347','Ring Mail Breastplate','chest','true','heavy','8820','steel','d','0','-1','77','0','0','83500','151','true','true','true','true','0','0'),
('348','Scale Mail','chest','true','heavy','8720','steel','d','0','-1','87','0','0','133000','241','true','true','true','true','0','0'),
('349','Compound Scale Mail','chest','true','heavy','8620','fine_steel','d','0','-1','95','0','0','183000','332','true','true','true','true','0','0'),
('350','Dwarven Scale Mail','chest','true','heavy','8540','fine_steel','d','0','-1','95','0','0','183000','332','true','true','true','true','0','0'),
('351','Blast Plate','chest','true','heavy','8420','fine_steel','d','0','-1','97','0','0','203000','369','true','true','true','true','0','0'),
('352','Brigandine Tunic','chest','true','heavy','8320','fine_steel','d','0','-1','103','0','0','299000','543','true','true','true','true','0','0'),
('353','Half Plate Armor','chest','true','heavy','8220','fine_steel','d','0','-1','111','0','0','391000','710','true','true','true','true','0','0'),
('354','Chain Mail Shirt','chest','true','heavy','8120','fine_steel','c','0','-1','120','0','0','505000','202','true','true','true','true','0','0'),
('355','Dwarven Chain Mail Shirt','chest','true','heavy','8070','fine_steel','c','0','-1','129','0','0','644000','257','true','true','true','true','0','0'),
('356','Full Plate Armor','fullarmor','true','heavy','10480','fine_steel','c','0','-1','239','0','0','2090000','836','true','true','true','true','0','0'),
('357','Zubei\'s Breastplate','chest','true','heavy','7970','mithril','b','0','-1','157','0','0','2080000','277','true','true','true','true','0','0'),
('358','Blue Wolf Breastplate','chest','true','heavy','7820','oriharukon','b','0','-1','166','0','0','3220000','429','true','true','true','true','0','0'),
('359','Shining Dragon Armor','fullarmor','true','heavy','6400','mithril','b','0','-1','301','0','0','6770000','902','true','true','true','true','0','0'),
('360','Armor of Victory','chest','true','heavy','3360','oriharukon','b','0','-1','175','0','0','3220000','429','true','true','true','true','0','0'),
..................... etc

is something wrong?

Zaldron · April 19, 2012

..................... etc

What's this? If u add this then nothing is wrong . Just execute the sql it's so simple .

hidde · April 19, 2012

yea i add this

i tried to execute but navicat gives me an error

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 24
[Err] -- 
-- Table structure for table `armor`
-- 

DROP TABLE IF EXISTS `armor`;
CREATE TABLE `armor` (
  `item_id` int(11) NOT NULL default '0',
  `name` varchar(70) default NULL,
  `bodypart` varchar(15) NOT NULL default '',
  `crystallizable` varchar(5) NOT NULL default '',
  `armor_type` varchar(5) NOT NULL default '',
  `weight` int(5) NOT NULL default '0',
  `material` varchar(15) NOT NULL default '',
  `crystal_type` varchar(4) NOT NULL default '',
  `avoid_modify` int(1) NOT NULL default '0',
  `duration` int(3) NOT NULL default '0',
  `p_def` int(3) NOT NULL default '0',
  `m_def` int(2) NOT NULL default '0',
  `mp_bonus` int(3) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `crystal_count` int(4) default NULL,
  `sellable` varchar(5) default NULL,
  `dropable` varchar(5) default NULL,
  `destroyable` varchar(5) default NULL,
  `tradeable` varchar(5) default NULL,
  `item_skill_id` decimal(11,0) NOT NULL default '0',
  `item_skill_lvl` decimal(11,0) NOT NULL default '0',
  PRIMARY KEY  (`item_id`)
) TYPE=MyISAM;
[Err] 1146 - Table 'l2jdb.armor' doesn't exist
[Err] -- 
-- Dumping data for table `armor`

INSERT INTO `armor` VALUES 
('21','Shirt','chest','false','light','4830','cloth','none','0','-1','36','0','0','147','0','true','true','true','true','0','0'),
('22','Leather Shirt','chest','false','light','4830','leather','none','0','-1','43','0','0','2430','0','true','true','true','true','0','0'),
('23','Wooden Breastplate','chest','false','light','4820','wood','none','0','-1','47','0','0','7960','0','true','true','true','true','0','0'),
('24','Bone Breastplate','chest','false','light','4770','bone','none','0','-1','50','0','0','20300','0','true','true','true','true','0','0'),
('25','Piece Bone Breastplate','chest','false','heavy','8970','bone','none','0','-1','62','0','0','31800','0','true','true','true','true','0','0'),
('26','Bronze Breastplate','chest','false','heavy','8920','bronze','none','0','-1','68','0','0','49200','0','true','true','true','true','0','0'),
('27','Hard Leather Shirt','chest','false','light','4720','leather','none','0','-1','53','0','0','36900','0','true','true','true','true','0','0'),
('28','Pants','legs','false','light','1740','cloth','none','0','-1','22','0','0','92','0','true','true','true','true','0','0'),
('29','Leather Pants','legs','false','light','1730','leather','none','0','-1','27','0','0','1520','0','true','true','true','true','0','0'),
('30','Hard Leather Pants','legs','false','light','1700','leather','none','0','-1','29','0','0','4970','0','true','true','true','true','0','0'),
('31','Bone Gaiters','legs','false','light','1680','bone','none','0','-1','32','0','0','12700','0','true','true','true','true','0','0'),
('32','Piece Bone Gaiters','legs','false','heavy','4020','bone','none','0','-1','39','0','0','19900','0','true','true','true','true','0','0'),
('33','Hard Leather Gaiters','legs','false','light','1610','leather','none','0','-1','33','0','0','23000','0','true','true','true','true','0','0'),
('34','Bronze Gaiters','legs','false','heavy','3960','bronze','none','0','-1','43','0','0','30700','0','true','true','true','true','0','0'),
('35','Cloth Shoes','feet','false','none','1320','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('36','Leather Sandals','feet','false','none','1320','leather','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('37','Leather Shoes','feet','false','none','1320','leather','none','0','-1','13','0','0','2650','0','true','true','true','true','0','0'),
('38','Low Boots','feet','false','none','1320','leather','none','0','-1','15','0','0','6770','0','true','true','true','true','0','0'),
('39','Boots','feet','false','none','1310','cloth','none','0','-1','17','0','0','12300','0','true','true','true','true','0','0'),
('40','Leather Boots','feet','true','none','1300','leather','d','0','-1','19','0','0','20900','38','true','true','true','true','0','0'),
('41','Cloth Cap','head','false','none','660','cloth','none','0','-1','13','0','0','55','0','true','true','true','true','0','0'),
('42','Leather Cap','head','false','none','660','leather','none','0','-1','16','0','0','911','0','true','true','true','true','0','0'),
('43','Wooden Helmet','head','false','none','660','wood','none','0','-1','19','0','0','3980','0','true','true','true','true','0','0'),
('44','Leather Helmet','head','false','none','650','leather','none','0','-1','23','0','0','10200','0','true','true','true','true','0','0'),
('45','Bone Helmet','head','true','none','640','bone','d','0','-1','29','0','0','31300','56','true','true','true','true','0','0'),
('46','Bronze Helmet','head','true','none','630','bronze','d','0','-1','33','0','0','50000','90','true','true','true','true','0','0'),
('47','Helmet','head','true','none','640','fine_steel','d','0','-1','37','0','0','76200','138','true','true','true','true','0','0'),
('48','Short Gloves','gloves','false','none','660','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('49','Gloves','gloves','false','none','660','cloth','none','0','-1','13','0','0','2650','0','true'
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Zaldron · April 19, 2012

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 24
[Err] -- 
-- Table structure for table `armor`
-- 

DROP TABLE IF EXISTS `armor`;
CREATE TABLE `armor` (
  `item_id` int(11) NOT NULL default '0',
  `name` varchar(70) default NULL,
  `bodypart` varchar(15) NOT NULL default '',
  `crystallizable` varchar(5) NOT NULL default '',
  `armor_type` varchar(5) NOT NULL default '',
  `weight` int(5) NOT NULL default '0',
  `material` varchar(15) NOT NULL default '',
  `crystal_type` varchar(4) NOT NULL default '',
  `avoid_modify` int(1) NOT NULL default '0',
  `duration` int(3) NOT NULL default '0',
  `p_def` int(3) NOT NULL default '0',
  `m_def` int(2) NOT NULL default '0',
  `mp_bonus` int(3) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `crystal_count` int(4) default NULL,
  `sellable` varchar(5) default NULL,
  `dropable` varchar(5) default NULL,
  `destroyable` varchar(5) default NULL,
  `tradeable` varchar(5) default NULL,
  `item_skill_id` decimal(11,0) NOT NULL default '0',
  `item_skill_lvl` decimal(11,0) NOT NULL default '0',
  PRIMARY KEY  (`item_id`)
TYPE=MyISAM;
[Err] 1146 - Table 'l2jdb.armor' doesn't exist
[Err] -- 
-- Dumping data for table `armor`

INSERT INTO `armor` VALUES 
('21','Shirt','chest','false','light','4830','cloth','none','0','-1','36','0','0','147','0','true','true','true','true','0','0'),
('22','Leather Shirt','chest','false','light','4830','leather','none','0','-1','43','0','0','2430','0','true','true','true','true','0','0'),
('23','Wooden Breastplate','chest','false','light','4820','wood','none','0','-1','47','0','0','7960','0','true','true','true','true','0','0'),
('24','Bone Breastplate','chest','false','light','4770','bone','none','0','-1','50','0','0','20300','0','true','true','true','true','0','0'),
('25','Piece Bone Breastplate','chest','false','heavy','8970','bone','none','0','-1','62','0','0','31800','0','true','true','true','true','0','0'),
('26','Bronze Breastplate','chest','false','heavy','8920','bronze','none','0','-1','68','0','0','49200','0','true','true','true','true','0','0'),
('27','Hard Leather Shirt','chest','false','light','4720','leather','none','0','-1','53','0','0','36900','0','true','true','true','true','0','0'),
('28','Pants','legs','false','light','1740','cloth','none','0','-1','22','0','0','92','0','true','true','true','true','0','0'),
('29','Leather Pants','legs','false','light','1730','leather','none','0','-1','27','0','0','1520','0','true','true','true','true','0','0'),
('30','Hard Leather Pants','legs','false','light','1700','leather','none','0','-1','29','0','0','4970','0','true','true','true','true','0','0'),
('31','Bone Gaiters','legs','false','light','1680','bone','none','0','-1','32','0','0','12700','0','true','true','true','true','0','0'),
('32','Piece Bone Gaiters','legs','false','heavy','4020','bone','none','0','-1','39','0','0','19900','0','true','true','true','true','0','0'),
('33','Hard Leather Gaiters','legs','false','light','1610','leather','none','0','-1','33','0','0','23000','0','true','true','true','true','0','0'),
('34','Bronze Gaiters','legs','false','heavy','3960','bronze','none','0','-1','43','0','0','30700','0','true','true','true','true','0','0'),
('35','Cloth Shoes','feet','false','none','1320','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('36','Leather Sandals','feet','false','none','1320','leather','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('37','Leather Shoes','feet','false','none','1320','leather','none','0','-1','13','0','0','2650','0','true','true','true','true','0','0'),
('38','Low Boots','feet','false','none','1320','leather','none','0','-1','15','0','0','6770','0','true','true','true','true','0','0'),
('39','Boots','feet','false','none','1310','cloth','none','0','-1','17','0','0','12300','0','true','true','true','true','0','0'),
('40','Leather Boots','feet','true','none','1300','leather','d','0','-1','19','0','0','20900','38','true','true','true','true','0','0'),
('41','Cloth Cap','head','false','none','660','cloth','none','0','-1','13','0','0','55','0','true','true','true','true','0','0'),
('42','Leather Cap','head','false','none','660','leather','none','0','-1','16','0','0','911','0','true','true','true','true','0','0'),
('43','Wooden Helmet','head','false','none','660','wood','none','0','-1','19','0','0','3980','0','true','true','true','true','0','0'),
('44','Leather Helmet','head','false','none','650','leather','none','0','-1','23','0','0','10200','0','true','true','true','true','0','0'),
('45','Bone Helmet','head','true','none','640','bone','d','0','-1','29','0','0','31300','56','true','true','true','true','0','0'),
('46','Bronze Helmet','head','true','none','630','bronze','d','0','-1','33','0','0','50000','90','true','true','true','true','0','0'),
('47','Helmet','head','true','none','640','fine_steel','d','0','-1','37','0','0','76200','138','true','true','true','true','0','0'),
('48','Short Gloves','gloves','false','none','660','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'),
('49','Gloves','gloves','false','none','660','cloth','none','0','-1','13','0','0','2650','0','true'
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Try to do it like this one

hidde · April 19, 2012

tried but same error ;(

Zaldron · April 19, 2012

The problem is here

) TYPE=MyISAM;

it's not typed well . I dont know a lot for sql so wait for another person to reply u .

[Help]sql files failed to install

Question

hidde

7 answers to this question

Recommended Posts

Zaldron

hidde

Zaldron

hidde

Zaldron

hidde

Zaldron

Create an account or sign in to comment

Create an account

Sign in

Posts

Topics

Browse

Activity

Store

Important Information