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

[Blue Cube]

I have an issue with my setup - I am running 11.0.9 Update #4.

I have this error on my landing page:

New files of configuration for Apache web server were not built due to errors in configuration templates: Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = SQLSTATE[HY093]: Invalid parameter number: no parameters were bound. The detailed error message was e-mailed to you, so please check the e-mail, fix the errors, and click here to retry generating broken configuration or click here to retry generating of all configurations.

I am following this knowledge base article: http://kb.parallels.com/en/112885

Here is the output:

mysql> select objectId from Configurations where status='error';
+----------+
| objectId |
+----------+
| 12 |
+----------+
1 row in set (0.00 sec)

mysql> select id,name,parentDomainId from domains where id=12;
+----+-------------------+----------------+
| id | name | parentDomainId |
+----+-------------------+----------------+
| 12 | somedomain.tld | 0 |
+----+-------------------+----------------+
1 row in set (0.00 sec)

mysql> select id, object_id from Subscriptions where object_id=12;
Empty set (0.00 sec)

mysql> select id, object_id from Subscriptions where object_id=12;
Empty set (0.00 sec)

mysql> SELECT `apsContexts`.* FROM `apsContexts` AS `apsContexts` WHERE (`pleskType` = 'hosting' AND `pleskId` = 12);
+----+-----------+---------+-------+----------------+
| id | pleskType | pleskId | ssl | subscriptionId |
+----+-----------+---------+-------+----------------+
| 7 | hosting | 12 | false | 14 |
+----+-----------+---------+-------+----------------+
1 row in set (0.00 sec)

As you can see, the 'select id, object_id from Subscriptions where object_id=12;' command comes up with an empty set.

Can anyone help me solve this issue??

Thank you!

 

[Blue Cube]

Bump (with at least 10 characters)

 

[Blue Cube]

Bump again.. I can't seem to figure this one out on my own, Igor do you have any suggestions?

 

[Nikolay.]

At a glance it looks like you're missing an entry from Subscriptions table with id=14 and object_id=12.

What is the output of "select * from Subscriptions where id=14" ?