Jump to content
  • 0

[HELP] Wierd SQL Installation Errors


Stefoulis15

Question

well hi guys i just compiled an l2jserver Interlude branch pack , and i tried to install it.

but the installer gave me a bunch of errors ( a lot actually ) about the .sql files

 

Database Installer:


Something caused an error while executing instruction :
C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe -h localhost -u root --pas
sword= -D l2jdb

with file armor.sql

What we should do now?

(l)og it: I will create a log for this file, then continue
   with the rest of the list in non-logging mode.

(c)ontinue: Let's pretend that nothing happened and continue with
   the rest of the list.

(r)econfigure: Perhaps these errors were caused by a typo.
   you can restart from scratch and redefine paths, databases
   and user info again.

(q)uit now

Choose (default continue):

 

the .sql files seems to be correct too... :/

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

 

and i dont really know what's the fault. i dont think there's a problem with my software.. ( eclipse , win 7 , navicat 10 lite , mysql 5.5 because yesterday i installed an acis pack without any problems..

 

thanks in advance

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Sorry for double post , the log file says :

 


Fri 09/09/2011 
10:35 AM
ERROR 1064 (42000) at line 6: 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

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.


×
×
  • Create New...