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

Created:

2016-11-16 13:08:27 UTC

Modified:

2017-08-16 17:20:12 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

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.x for Linux

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.