View Single Post
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

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 ('', 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 ('', ENCRYPT('blah' at line 1

Any ideas? :P
The correct syntax is

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


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