Cannot disable or enable reseller account

Created:

2016-11-16 13:11:18 UTC

Modified:

2017-08-08 13:36:58 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot disable or enable reseller account

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

Attempt to disable reseller failed with the error below:

Error: Some of the selected resellers were not suspended.
cObject::update() failed: Some fields are empty or contain an improper value. ('Unable to create Account object: Account: unable to select: no such row in the table' = '')

Cause

An entry in psa.accounts is missing.

Resolution

  1. Backup psa database

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --extended-insert=false psa > psa.dump.`date +%F.%s`.sql
  2. Find affected reseller account

    mysql> select cname, pname, login, account_id  from psa.clients where pname like 'RESELLER_NAME';
    *************************** 1. row ***************************
    cname: Some description
    pname: Reseller Name
    login: reseller_login
    account_id: 180
    1 row in set (0.00 sec)
  3. Find account having id=180 in psa.accounts :

    mysql> select * from psa.accounts where id=180; 
    Empty set (0.00 sec) <== Record is absent
  4. Create a new one account with id=180

    mysql> insert into accounts values (180,'plain','<PASSWORD>');
  5. Reset reseller password in Plesk

Have more questions? Submit a request
Please sign in to leave a comment.