View Single Post
  #11  
Old 4th January 2007, 16:40
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

Quote:
Originally Posted by Kyse
OK falko, check it..

I got it all working, now im trying to edit the database using mysql.

it gives me the same error for editing domains as users but I have users to copy/paste, so here it is:

mysql> INSERT INTO 'users' ('email', 'password', 'quota') VALUES ('kyse@kyse.us', ENCRYPT('blah'), 10485760);
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 ''users' ('email', 'password', 'quota') VALUES ('kyse@kyse.us', ENCRYPT('blah' at line 1
mysql>


Any ideas? :P
The correct syntax is

Code:
INSERT INTO users (email, password, quota) VALUES ('kyse@kyse.us', ENCRYPT('blah'), 10485760);
Quote:
I can send and receive email to and from the one account I craeted in the databases now. kyse@kyse.us. However if I try to send an email to internal user accounts on the mail server, such as root@kyse.us or external email addresses such as kyse@cox.net, I get undeliverable return messages back to outlook.
What's in your mail log when this happens?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Sponsored Links