• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

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

Blue Cube

New Pleskian
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!
 
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" ?
 
Back
Top