Jump to content
MaxCheaters Official Group on Discord
-> Place your ad text here <-
We're Rebuilding – Join Our Staff Team
  • 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

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?

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

  • 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

  • 0
Zaldron Newbie

Zaldron

Posted
Posted

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 .

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 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