Geeklog Forums

Is there anybody who is familiar with this error? 1064: parse error near \'TYPE=MyISAM \' at line 6. I encountered that error during the installation, after pressing the next button. I can’t install my site correctly. Pls. help. Here are the first 6 lines of code at my mysql_tableanddata.php

$_SQL[1] = "
CREATE TABLE {$_TABLES['access']} (
acc_ft_id mediumint(8) NOT NULL default '0',
acc_grp_id mediumint(8) NOT NULL default '0',
PRIMARY KEY (acc_ft_id,acc_grp_id)
) TYPE=MyISAM
";

What version of mysql are you using?

My server is using MySQL 3.22.26a version and PHP 4.2.3...


I removed the double quotes and now the error is on line 4

here's the code:

$_SQL[1] =
CREATE TABLE {$_TABLES['access']} (
acc_ft_id mediumint(8) NOT NULL default '0',
acc_grp_id mediumint(8) NOT NULL default '0',
PRIMARY KEY (acc_ft_id,acc_grp_id))
TYPE=MyISAM;

then it will go to success.php with this error:

1017: Can't find file: 'bd_blocks.frm' (errno: 2)

I am using table prefix bd_ instead of gl_

Now I know, the old MySQL 3.22 version don\'t support MyISAM.... thanks Dwight...