Add mailbox: Internal error: SQLSTATE[HY093]: Invalid parameter number

[ViacheslavG]

Hello!

After upgrading from 9.5 to 11.5.30 update #47 ( CentOS 5.8 (Final) 32bit) i'm getting error when trying to add an email box:



Internal error: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound Message SQLSTATE[HY093]: Invalid parameter number: no parameters were bound
File Pdo.php
Line 234
Type Zend_Db_Statement_Exception


KB http://kb.parallels.com/en/112885 doesn't helps:
mysql request "select objectId from Configurations where status='error';" gives nothing.

mailserver: postfix.

 

[IgorG]

The root cause of the issue is inconsistency in database. In order to fix the issue try to do following:

mysql> select id, login from clients where type='admin';
+----+-------+

| id | login |
+----+-------+

| XX | admin |
+----+-------+
1 row in set (0.00 sec)

mysql> update smb_users set ownerId=XX where login ='admin';

Where XX is admin's ID.