Unable to modify reseller service plan: SQLSTATE Invalid parameter number no parameters were bound

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • MG:12626b1a6bde427e95f74b7d4b435277
  • MT:f657e0aa3aeaf0453bb26cd5370c7be8

Created:

2016-11-16 13:08:27 UTC

Modified:

2017-02-13 06:36:42 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to modify reseller service plan: SQLSTATE Invalid parameter number no parameters were bound

Symptoms

Unable to change Reseller service plan. The following error appears in panel.log :

Error: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound

The following entries display different values:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne "select count(*) from clients where type='reseller'"
+----------+
| count(*) |
+----------+
| 10 |
+----------+

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne "select count(*) from Subscriptions where object_type='client'"
+----------+
| count(*) |
+----------+
| 2 |
+----------+

Cause

Database inconsistency.

Resolution

  1. Generate missing records by clicking on Customize in Reseller account

  2. Click **Update & Lock"

If there are a lot missing records, use the following command in order to add missing records:

 MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne "SELECT id,login from clients  where type='reseller' and id not in(select object_id from Subscriptions where object_type='client')"|while read id login ;do MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne"INSERT INTO Subscriptions (object_id,object_type,locked,synchronized,custom,uuid) VALUES ($id,'client','false','true','false','`uuidgen`')";done
Have more questions? Submit a request
Please sign in to leave a comment.