Falko help -Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Manage

[bobbob]

Falko help ,

I installed "Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Management) On Fedora 14" , but on FEDORA 15 with last MySQL ...and I received an error :

USE pureftpd;

CREATE TABLE ftpd (
User varchar(16) NOT NULL default '',
status enum('0','1') NOT NULL default '0',
Password varchar(64) NOT NULL default '',
Uid varchar(11) NOT NULL default '-1',
Gid varchar(11) NOT NULL default '-1',
Dir varchar(128) NOT NULL default '',
ULBandwidth smallint(5) NOT NULL default '0',
DLBandwidth smallint(5) NOT NULL default '0',
comment tinytext NOT NULL,
ipaccess varchar(15) NOT NULL default '*',
QuotaSize smallint(5) NOT NULL default '0',
QuotaFiles int(11) NOT NULL default 0,
PRIMARY KEY (User),
UNIQUE KEY User (User)
) TYPE=MyISAM;


ERROR MESSAGE :

"ERROR 1064 (42000): 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 'TYPE=MyISAM' at line 16 '

WHAT IS THE RIGHT SYNTAX ? Please help !

[bobbob]

Found the right syntax " ) ENGINE=MyISAM; " ...it created me the table ...so inserted some user , but here are some problemms ...don't create me in /home/www.example.com right dir. I thought if I access the new user, the directory will be created automatically, but that directory did not appear. How do I do?

Falko help !

[falko]

Originally Posted by bobbob

I thought if I access the new user, the directory will be created automatically, but that directory did not appear. How do I do?

Falko help !

Are there any errors in your logs?

What are the outputs of

ls -la /home/

and

getenforce

?