Problem with edit email account

[theprincy]

(09-15-2009 04:45 AM)sci2tech Wrote:  Try issue this query:

Code:

SELECT
            t1.*, t2.`domain_id`, t2.`domain_name`
        FROM
            `mail_users` AS t1,
            `domain` AS t2
        WHERE
            t1.`mail_id` = ?
        AND
            t2.`domain_id` = t1.`domain_id`
        AND
            t2.`domain_name` = ?

Replace ? with id of domain who own that email. I can not reproduce it

name domain is j-rent.net

#1054 - Unknown column 'j' in 'where clause'

---

(09-15-2009 06:03 AM)kilburn Wrote:  

Quote:User does not exist or you do not have permission to access this interface!

As you have this problem on multiple places, I think that the error is referring to your login user. Please try to add another domain, create a mail account on it and then change the password...

the problem occurs with different domains on different servers, but I have the same problem with SQL account