Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 26th December 2005, 04: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
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL problem on install badben Installation/Configuration 12 20th December 2005 13:59
MySQL installing problem n!x Server Operation 7 24th November 2005 10:44
MySQL connection problem cartdev Installation/Configuration 17 17th November 2005 23:30
SUSE 10.0. x86-64 mysql problem hobit007 Installation/Configuration 2 21st October 2005 17:51
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 17:37


All times are GMT +2. The time now is 09:38.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.