Knowledge Base

Unable to change service plan for a subscription in Plesk: Invalid parameter number: no parameters were bound

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