Welcome to Geeklog, Anonymous Saturday, October 01 2022 @ 10:42 pm EDT

Geeklog Forums

1064: parse error near \'TYPE=MyISAM \' at line 6


Cyber_777

Anonymous
hopeful
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. Cry Here are the first 6 lines of code at my mysql_tableanddata.php
 Quote

Cyber_777

Anonymous
$_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
";
 Quote

Status: offline

DTrumbower

Forum User
Moderator
Registered: 01/08/03
Posts: 507
What version of mysql are you using?
 Quote

Cyber_777

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

 Quote

Cyber_777

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

All times are EDT. The time is now 10:42 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content