Unable to open a subscription: No subscriptions are listed for your account; therefore, no operations are available.

Vincent Lauton

Updated December 09, 2024 14:52

Plesk for Windows Plesk for Linux kb: technical ABT: Group B

Applicable to:

Plesk for Linux
Plesk for Windows

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.

PLESK_WARN: Access to the foreign subscription is denied.

The following errors can be found in the /var/log/plesk/panel.log or %plesk_dir%admin\logs\php_error.log files with the enabled debug logging:

CONFIG_TEXT: 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%admin\logs\php_error.log files:

CONFIG_TEXT: DEBUG [dbquery] [38] SQL: SELECT domains.* FROM domains WHERE (cl_id = 1 AND webspace_id = '0' AND id = '-1')

Cause

Database inconsistencies in the smb_users table.

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

Resolution

Connect to the server via SSH/RDP
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;"