SymptomsThe following error is shown in Sitebuilder Wizard:
Internal Sitebuilder error.
File: /usr/local/sitebuilder/include/Zend/Db/Statement/Pdo.php; Line: 238
Message: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound; Code: 0
Internal SiteBuilder error.
File: /usr/local/sitebuilder/include/Zend/Zend/Db/Adapter/Abstract.php; Line: 156
Message: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound; Code: HY093
CauseThe problem is caused by PDO connector malfunction. For details please see: http://bugs.php.net/bug.php?id=40822 and http://framework.zend.com/issues/browse/ZF-347
The error appears when some field related to the site (for example site alias) contains apostrophe ("'") sign.
The problem has been fixed in PHP since version 5.2.2+
ResolutionThe problem is a know and will be fixed in future version of Parallels Plesk Sitebuilder.
To resolve the problem it is recommended to upgrade PHP or avoid usage of apostrophe ("'") sign in site configuration.