Automatic import from KB #111229

Symptoms

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:

/var/log/sw-cp-server/error_log

 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

Cause

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)

 mysql>

But client subscriptions were not created for the resellers:

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

 mysql>

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

Resolution

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.