Posted on: 05/17/02 05:26pm
By: Anonymous (dappadon)
I'm new at this...I followed all of the installation directions, but when I tried to instal "mysql_tableanddata.php" using phpMyAdmin it came up with this error...& i have no clue of what i should do or what that even means...could some one please help.
<?php
$_SQL[1] = "
CREATE TABLE (
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
"
MySQL said:
You have an error in your SQL syntax near '<?php
$_SQL[1] = "
CREATE TABLE (
acc_ft_id mediumin' at line 1
Don't do that
Posted on: 05/18/02 01:09am
By: Dirk
I assume you were trying to follow the instructions in INSTALL.HTML
. Please ignore this file, it is out of date. Follow the instructions in the plain ASCII file named INSTALL
instead. Specifically, you don't need to do anything with the mysql_tableanddata.php
file - the install script will handle that for you.
bye, Dirk
Why this fails
Posted on: 05/18/02 02:54am
By: gene_wood
This may seem obvious, but the reason you're getting this error is that your passing php code to mysql as sql code.
MySQL is expecting "CREATE TABLE (
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=MyISA
"
Your sending "<?php
$_SQL[1] = "
CREATE TABLE (
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
"
"