Article ID: 111229, created on May 4, 2011, last review on Jun 17, 2016

  • Applies to:
  • Plesk 11.0 for Linux

Automatic import from KB #111229


Upgrade Plesk from version 9.5.4 to 10.2.

Try changing reseller's plan through Plesk, Home > Resellers > _RESELLER _> Change Plan. Choose any plan near 'New plan' and click OK to save configuration. The following error is shown:

Internal error

The following is shown in log of sw-cp-server:


 2011-04-29T06:33:20+02:00 CRIT (2): Zend_Db_Statement_Exception: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound
 file: /usr/local/psa/admin/plib/Zend/Db/Statement/Pdo.php
 line: 238
 code: 0


According to Provider's Guide to Switching to Panel 10:

 Reseller accounts are transferred without changes, and resources are allocated to them by means of custom subscription, which are not bound to plans.

Here are resellers transfered from version 9.5 to 10.2:

~#  MYSQL_PWD=`cat /etc/psa/.psa.shadow`  mysql -uadmin psa
 mysql> select id, pname from psa.clients where type='reseller';
 | id | pname              |
 | 2  | Reseller account 1 |
 | 11 | Reseller account 2 |
 2 rows in set (0.00 sec)


But client subscriptions were not created for the resellers:

mysql> select * from psa.Subscriptions where object_type='client';
 Empty set (0.01 sec)


Client subscriptions must exist for resellers in order to change hosting plan.


The problem will be fixed in future update of Parallels Plesk Panel after 10.2.

To fix the issue in Parallels Plesk Panel 10.2 create the records for all resellers manually:

mysql> insert into psa.Subscriptions (object_id,object_type) values (2,'client');
 Query OK, 1 row affected (0.00 sec)

 mysql> insert into psa.Subscriptions (object_id,object_type) values (11,'client');
 Query OK, 1 row affected (0.00 sec)

Where 2, 11 are IDs of transferred resellers that are stored in table psa.clients.

a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 56797cefb1efc9130f7c48a7d1db0f0c aea4cd7bfd353ad7a1341a257ad4724a 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article
Save as PDF