- Plesk for Windows
Creation of subscription user in Subscriptions > example.com > Users results in error:
PLESK_ERROR: Error: user already exists
There is no such user in Plesk. The output of the following command is empty:
C:\> plesk db "SELECT name FROM domains where id in (SELECT subscriptionDomainId FROM smb_users where firstname.lastname@example.org')"
To remove orphaned user from the database use the instructions below:
Connect to the server via RDP.
Open cmd.exe as Administrator.
Backup Plesk database.
Log into Plesk database.
Find record, with the corresponding user that causes error:
MYSQL_WIN: SELECT id FROM smb_users WHERE login="email@example.com";
| id |
| 5 |
1 row in set (0.00 sec)
MYSQL_WIN: DELETE FROM smb_users WHERE id=5;