error when deleting mail account

[xophe]

Hi all,

I get this error when I try to delete a particular email account. For the others it works fine.

Error: Can't create Account object: Account: unable to select: no such row in the table

0: /usr/local/psa/admin/plib/common_func.php3:156
psaerror(string 'Error: Can't create Account object: Account: unable to select: no such row in the table')
1: /usr/local/psa/admin/htdocs/domains/mail/mail_name_edit.php:145

Any idea?
Xophe

 

[Amin Taheri]

Make sure it really exists in the db first

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -b
use psa;
select * from mail where ( mail_name='test' and dom_id = ( select id from domains where displayname='domain.com') );

That will show you if the username (ie test if email is [email protected]) exists in the psa database for the domain test.com)

if it doesnt then you got problems. If it does, then you can manually delete it

delete from mail where ( mail_name='test' and dom_id = ( select id from domains where displayname='domain.com') );

You should see something like
Query OK, 1 row affected (0.03 sec)

Then it should no longer show up in plesk. After that you can manually clean the account out of any qmail places it may still exist if any.

 

[sanjsantoki]

Hi,

Also, please try to check manually whether user is there in mail server or not?

 

[xophe]

Thanks a lot for the answers.
I have found and deleted the line in the mail table and after deleted manually the qmail account.

There was a problem with the directory of the account to delete:
cd /var/qmail/mailnames/domain.com
ls -l test
ls: test/spamcheck16258: Input/output error