[Help]Navicat

[duac]

Ok so im trying to make my own server, when i try to execute the actual database zf.sql it comes up to this 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 21
[Err] CREATE TABLE `account` (
  `id` int(4) unsigned zerofill NOT NULL auto_increment,
  `name` char(32) binary NOT NULL default '',
  `***` int(4) unsigned zerofill NOT NULL default '0000',
  `age` int(4) unsigned zerofill NOT NULL default '0000',
  `phone` char(16) binary NOT NULL default '',
  `email` char(128) binary NOT NULL default '',
  `address` char(128) binary NOT NULL default '',
  `idnumber` char(32) binary NOT NULL default '',
  `password` char(16) binary NOT NULL default '',
  `type` int(4) unsigned zerofill NOT NULL default '0002',
  `point` int(4) unsigned zerofill NOT NULL default '100000',
  `pointtime` int(4) unsigned zerofill NOT NULL default '20021231',
  `online` int(4) unsigned zerofill NOT NULL default '0000',
  `licence` int(4) unsigned NOT NULL default '0',
  `netbar_ip` char(15) default '127.0.0.1',
  `ip_mask` char(15) default '255.255.255.255',
  `VIP` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ix_name` (`name`)
) TYPE=MyISAM;
[Msg] Finished - Unsuccessfully

Could someone PLEASE tell me what im doing wrong and tell me what i should do too fix this problem.

[F i n c h i]

For the 100000000000000 time, enable InnoDB when you are installing AppServ.

[duac]

Originally Posted by F i n c h i

For the 100000000000000 time, enable InnoDB when you are installing AppServ.

That did not help me at all !!!!!

[.Beatz]

Originally Posted by duac

That did not help me at all !!!!!

That did not help us.

Do you know how to enable InnoDB?

Does it not work with InnoDB enabled?

Please give us more details other than "That did not help me at all !!!!!" else we can't help you.

[Spirited]

The database doesn't use the InnoDB engine.
It uses MyISAM as it's database engine.

Solution: Uninstall that ghetto fake MySql Server (AppServ or something like that) and install MySql Community Server. It comes with all of the engines.

[_tao4229_]

Change TYPE=MyISAM to ENGINE=MYISAM (in all occurrences).

[duac]

Originally Posted by Fаng

The database doesn't use the InnoDB engine.
It uses MyISAM as it's database engine.

Solution: Uninstall that ghetto fake MySql Server (AppServ or something like that) and install MySql Community Server. It comes with all of the engines.

Hey fang. Sounds good, i will try it. am i gonna run just that program? if yes, do i gonna install All programs or just some of them ?=)

Thanks



Tryed!. Didn't worked. Also tryed what tao4229 said. Change TYPE=MyISAM to ENGINE=MYISAM (in all occurrences)
Still giving errors.

Also, im trying to run a 5095 server so you all know if it helps any lol..

[BaussHacker]

What version of MySQL do you use?

Also it has nothing to do with Navicat.

Same problem as you, but fixed it with tao's suggestion:


Might take a look here as well:


Referring to this as well:

"CREATE/ALTER TABLE ... ( ... ) TYPE=MyISAM
no longer works. The TYPE keyword is no longer accepted in this context."
Version: 5.1.7-BK,6.0.9,5.4.4

[duac]

Originally Posted by BaussHacker

What version of MySQL do you use?

Also it has nothing to do with Navicat.

Same problem as you, but fixed it with tao's suggestion:


Might take a look here as well:


Referring to this as well:

"CREATE/ALTER TABLE ... ( ... ) TYPE=MyISAM
no longer works. The TYPE keyword is no longer accepted in this context."
Version: 5.1.7-BK,6.0.9,5.4.4

Im using the Mysql community server. 5.5.15.

So i really have to change ALL TYPE=MyISAM to ENGINE=MyISAM ?!

[BaussHacker]

Originally Posted by duac

Im using the Mysql community server. 5.5.15.

So i really have to change ALL TYPE=MyISAM to ENGINE=MyISAM ?!

Yes.

[duac]

Well i did that but it still gives errors.. :S

Don't know what's wrong


Error i get now is

[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 '------------------------------
-- Records of accounts
-- ---------------------' at line 1
[Err] ------------------------------
-- Records of accounts
-- ----------------------------
INSERT INTO `accounts` VALUES ('0000', '01', '0099', '01', '15087280', '0001', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[.Beatz]

Originally Posted by duac

Well i did that but it still gives errors.. :S

Don't know what's wrong


Error i get now is

[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 '------------------------------
-- Records of accounts
-- ---------------------' at line 1
[Err] ------------------------------
-- Records of accounts
-- ----------------------------
INSERT INTO `accounts` VALUES ('0000', '01', '0099', '01', '15087280', '0001', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Is that the only record in the accounts table? If it is then take the record out of the Sql file and try again.

[duac]

I fixed the problem! I would like to say thanks alot for your help! I Appreciate it alot!.
I will hit Thanks!