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.
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.