Articles in this section

See more

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

Avatar
Permanently deleted user
Updated
Follow
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

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles