Symptoms
-
Accessing a subscription via Plesk > Subscriptions fails with the following warning:
PLESK_WARN: Warning: No subscriptions are listed for your account; therefore, no operations are available. Please contact your service provider for assistance with subscribing to the services.
-
The following errors can be found in the
/var/log/plesk/panel.log
or%plesk_dir%adminlogsphp_error.log
files with the enabled debug logging:DEBUG [panel] Smb_Exception: Access to the foreign subscription is denied.
WARN [panel] No subscriptions are listed for your account; therefore, no operations are available.
Please contact your service provider for assistance with subscribing to the services.
DEBUG [panel] Unable to access task/task-progress without subscription -
The enabled show.sql_query option in the panel.ini file provides with the following info in the
/var/log/plesk/panel.log
or%plesk_dir%adminlogsphp_error.log
files:DEBUG [dbquery] [38] SQL: SELECT
domains
.* FROMdomains
WHERE (cl_id
= 1 ANDwebspace_id
= '0' ANDid
= '-1') -
The
smb_users.subscriptionDomainId
table contains an incorrect value:# plesk db “select id,login,subscriptionDomainId from smb_users where subscriptionDomainId=‘-1’“
+—-+———————-+———————-+
| id | login | subscriptionDomainId |
+—-+———————-+———————-+
| 1 | admin | -1 |
| 1 | user1 | -1 |
+—-+———————-+———————-+
Cause
Database inconsistencies in the smb_users
table.
Resolution
-
Create a backup of the
psa
database. -
Update the
subscriptionDomainId
value with the proper value:# plesk db “update smb_users set subscriptionDomainId=”0″ where subscriptionDomainId=”-1″ and isBuiltIn=1;”