Error at line..... please help

[manelf2]

I upload all files to the root of my subdomain I made for it.. hxxp:forum.semperidem.ca [nonactive]
Then I create my sql database in my admin tool, I even set some of the settings in settings.php
When I goto the hxxp:forum.semperidem.ca/install.php [nonactive] I get a  500 internal server error....
So I tried manually importing the .sql file provided into my database. and I got this.l...

**** ERROR START ****

Database semperidem_ca_-_smf  running on localhost

Error

SQL-query :

CREATE TABLE {$db_prefix}attachments(
ID_ATTACH int( 11 ) unsigned NOT NULL auto_increment,
ID_MSG int( 10 ) unsigned NOT NULL default '0',
ID_MEMBER int( 10 ) unsigned NOT NULL default '0',
filename tinytext NOT NULL default '',
size mediumint( 8 ) unsigned NOT NULL default '0',
downloads mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( ID_ATTACH ) ,
KEY ID_MSG( ID_MSG ) ,
KEY ID_MEMBER( ID_MEMBER )
) TYPE = MyISAM

MySQL said:

You have an error in your SQL syntax near '{$db_prefix}attachments (
  ID_ATTACH int(11) unsigned NOT NULL auto_increment,
' at line 1

**** END ERROR ****

[Tomer]

Try starting from the beggining, as for the part when you said you set settings.php, you set it via the installer or did you open the settings.php file? Because dont open the file, do it with the installer.

Anways start over and do it with the ''.

-Lamper

[[Unknown]]

Did you chmod the install.php file?  If not, that might be why it's giving a 500.

Importing the .sql file is NOT the way to install SMF.

-[Unknown]

[manelf2]

I've tried all of those, manual and normal. Still internal server error... balls

[[Unknown]]

Make sure you've tried:

777
755
775
770
700
750

It veries depending on the host.

-[Unknown]