Symptoms
Unable to change service plan of a subscription in Plesk > Subscriptions > Change Plan:
error: DB query failed: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound, query was: SELECT `PlansSubscriptions`.* FROM `PlansSubscriptions` WHERE (`subscription_id` = ?)
Cause
A database record in table psa.Subscriptions is missing.
Resolution
Repair database inconsistency in Plesk Interface
- Log into Plesk
- Open Plesk Repair Kit at Tools & Settings > Diagnose & Repair
- Click Repair in row Plesk Database:
Repair database inconsistency on command-line with Plesk Repair Utility:
Plesk for Linux
-
Connect to the server via SSH
-
Execute this command:
# plesk repair db
-
Follow the on-screen instructions to automatically recreate a record for the missing subscription
Plesk for Windows
-
Connect to the server via RDP
-
Open an elevated command-line window
-
Execute the following command:
plesk repair db
-
Follow the on-screen instructions to automatically recreate a record for the missing subscription