4th January 2007, 15:40
|
|
Super Moderator
|
|
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,665
Thanks: 1,896
Thanked 2,592 Times in 2,443 Posts
|
|
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?
|