[Help]Navicat

09/14/2011 12:23 duac#1

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

Code:

[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 '',
  `sex` 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.

09/14/2011 13:04 F i n c h i#2

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

09/14/2011 13:54 duac#3

Quote:

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

09/14/2011 19:07 .Beatz#4

Quote:

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.

09/15/2011 01:49 Spirited#5

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.

09/15/2011 02:50 _tao4229_#6

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

09/15/2011 11:18 duac#7

Quote:

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

09/15/2011 12:39 BaussHacker#8

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:
[Only registered and activated users can see links. Click Here To Register...]

Might take a look here as well:
[Only registered and activated users can see links. Click Here To Register...]

Referring to this as well:
[Only registered and activated users can see links. Click Here To Register...]
"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

09/15/2011 13:13 duac#9

Quote:

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:
[Only registered and activated users can see links. Click Here To Register...]

Might take a look here as well:
[Only registered and activated users can see links. Click Here To Register...]

Referring to this as well:
[Only registered and activated users can see links. Click Here To Register...]
"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 ?!

09/15/2011 13:15 BaussHacker#10

Quote:

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.

09/15/2011 14:04 duac#11

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

Don't know what's wrong

Error i get now is

Code:

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

09/17/2011 14:32 .Beatz#12

Quote:

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

Code:

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

09/18/2011 12:44 duac#13

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