Jump to content
MaxCheaters Official Group at Discord
--> Place your ad text here <--
  • 0

[Help]sql files failed to install

hidde

Asked by hidde,

 Share

Question

hidde Newbie

hidde

Posted
Posted

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

d1ff5ec81f38.png

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

 

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

Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0
hidde Newbie

hidde

Posted
  • Author
Posted

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?

Link to comment
Share on other sites
  • 0
hidde Newbie

hidde

Posted
  • Author
Posted

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

Link to comment
Share on other sites
  • 0
Zaldron Newbie

Zaldron

Posted
Posted 
[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

Link to comment
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.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  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.

×
 Share
Go to question listing


×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock