Articles in this section

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

Denis Pankov
Updated
kb: technical Plesk ABT: Group A

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
  1. Log into Plesk
  2. Open Plesk Repair Kit at Tools & Settings > Diagnose & Repair
  3. Click Repair in row Plesk Database:
    Repair database

 

Repair database inconsistency on command-line with Plesk Repair Utility:

Plesk for Linux

  1. Connect to the server via SSH

  2. Execute this command:

    # plesk repair db

  3. Follow the on-screen instructions to automatically recreate a record for the missing subscription

Plesk for Windows

  1. Connect to the server via RDP

  2. Open an elevated command-line window

  3. Execute the following command:

    plesk repair db

  4. Follow the on-screen instructions to automatically recreate a record for the missing subscription

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.