View Single Post
  #1  
Old 26th December 2005, 03:34
chris_87 chris_87 is offline
Junior Member
 
Join Date: Dec 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem related to How-to Pureftpd-mysql

I followed all the steps and most of them are ok, but I've got an error when I input a new virtual user in mysql.
When I insert a new virtual user:
INSERT INTO `ftpd` ( `User` , `status` , `Password` , `Uid` , `Gid` , `Dir` , `ULBandwidth` , `DLBandwidth` , `comment` , `ipaccess` , `QuotaSize` , `QuotaFiles` ) VALUES ( 'test' , '1' , MD5 ( 'testtest' ) , '2001' , '2001' , '/home/test' , '100' , '100' , '' , '*' , '50' , '0' ) ;

It appears on my screen
ERROR 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 '( 'testtest' ) , '2001' , '2001' , '/home/test' , '100' , '100'

Anyone would be able to help??

Thanks in advance
Reply With Quote
Sponsored Links