Applicable to:
- Plesk 11.x for Linux
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.
Comments
0 comments
Please sign in to leave a comment.