After the migration from Plesk 9.5 to Plesk 12, some customers do not have Manage Hosting button or link in Hosting Services > Customers section.
The issue is caused by database inconsistency.
First of all take a dump of Plesk database:
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > psa_db_dump_`date +%F`.sql
Find out the
idof affected customer:
mysql> select id,pname from clients where pname='customer2.tld'; +----+---------------+ | id | pname | +----+---------------+ | 4 | customer2.tld | +----+---------------+ 1 row in set (0.00 sec)
mysql> update domains set cl_id=4 where name='customer2.tld'; Query OK, 0 rows affected (0.60 sec) Rows matched: 1 Changed: 0 Warnings: 0
After that Manage Hosting link appears for affected customer, but it throws an error:
Internal error: Unable to find row by field login with value user_name in smb_users table. Message Unable to find row by field login with value user_name in smb_users table. File Abstract.php Line 173 Type Db_Table_Exception
In order to make Manage Hosting link working it is needed to update customer's password:
Open the customer in Plesk;
Click on Change Login Info;
- Set a new password.
After that Manage Hosting link will function fine.