error when trying to install nuke database i

New Member Joined: Nov 17, 2004 Posts: 9

Error

SQL-query :

CREATE TABLE nuke_authors(

aid varchar( 25 ) NOT NULL default '',
name varchar( 50 ) default NULL ,
url varchar( 255 ) NOT NULL default '',
email varchar( 255 ) NOT NULL default '',
pwd varchar( 40 ) default NULL ,
counter int( 11 ) NOT NULL default '0',
radminsuper tinyint( 1 ) NOT NULL default '1',
admlanguage varchar( 30 ) NOT NULL default '',
PRIMARY KEY ( aid ) ,
KEY aid( aid )
)ENGINE = MYISAM

MySQL said:

#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 'ENGINE=MyISAM' at line 12

registered · Regular Joined: May 28, 2005 Posts: 90

should be:

Quote:

DROP TABLE IF EXISTS `nuke_authors`;
CREATE TABLE `nuke_authors` (
`aid` varchar(25) NOT NULL default '',
`name` varchar(50) default NULL,
`url` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`pwd` varchar(40) default NULL,
`counter` int(11) NOT NULL default '0',
`radminsuper` tinyint(1) NOT NULL default '1',
`admlanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`aid`),
KEY `aid` (`aid`)
) TYPE=MyISAM;

... engine instead of type? mmm...

Posted: Sun Jun 05, 2005 6:12 am

all the tablesin the sql file have ENGINE = MYISAM in them...... not ) TYPE=MyISAM;

Posted: Sun Jun 05, 2005 6:17 am

so my sql doesn't work too?
this is strange because the #1064 say that you have an error near 'ENGINE=MyISAM'

also try to add ; at the end of line

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Make sure you have applied thi http://www.ravenphpscripts.com/postt5668.html .

Posted: Sun Jun 05, 2005 7:03 pm

i have applyed that fix sitll get the error it will not ever upload the sql file ......

Code:

Error 





SQL-query : 





CREATE TABLE nuke_authors( 





aid varchar( 25 ) NOT NULL default '', 


name varchar( 50 ) default NULL , 


url varchar( 255 ) NOT NULL default '', 


email varchar( 255 ) NOT NULL default '', 


pwd varchar( 40 ) default NULL , 


counter int( 11 ) NOT NULL default '0', 


radminsuper tinyint( 1 ) NOT NULL default '1', 


admlanguage varchar( 30 ) NOT NULL default '', 


PRIMARY KEY ( aid ) , 


KEY aid( aid ) 


)ENGINE = MYISAM 





MySQL said: 








#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 'ENGINE=MyISAM' at line 12

Posted: Sun Jun 05, 2005 7:18 pm

That code works perfectly for me. Try just running that code alone in an SQL window in phpMyAdmin.

Posted: Sun Jun 05, 2005 7:26 pm

i have changed ENGINE = MYISAM to TYPE=MyISAM but this forums admin is blank now, this newest version is a hunk of junk ......

Posted: Sun Jun 05, 2005 7:33 pm

Leave it as engine. Did you try what I suggested? What server version of MySQL are you using?

Posted: Sun Jun 05, 2005 7:43 pm

4.0.23_Debian-4-log no still get the error when its ENGINE = MYISAM
but when i use TYPE=MyISAM it works but no forums

when do you think you will have a patch for 7.8

Posted: Sun Jun 05, 2005 9:22 pm

For the third time! Did you try what I suggested - running the code as stand alone?

Posted: Sun Jun 05, 2005 10:19 pm

yes i still get the same result

Posted: Mon Jun 06, 2005 4:23 am

I would need to have access to your phpMyAdmin to debug any further. PM me the login information if you want me to debug.