Cannot create/edit mailbox of admin: "Invalid parameter number: no parameters were bound"

Created:

2016-11-16 13:10:22 UTC

Modified:

2017-04-24 11:55:38 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot create/edit mailbox of admin: "Invalid parameter number: no parameters were bound"

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux

Symptoms

Cannot user or create/edit mailbox of admin in control panel:

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

Cause

Inconsistency in database.

Resolution

  1. Log into Plesk configuration database:

    MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin -Dpsa
  2. Find ID of client with login " admin ":

    mysql> select id, login from clients where type='admin';
    +----+-------+
    | id | login |
    +----+-------+
    | 8 | admin |
    +----+-------+
    1 row in set (0.00 sec)
  3. Update property " ownerId " in table " smb_users " for user " admin " using value obtained on previous step:

    mysql> update smb_users set ownerId=8 where login ='admin';
    Query OK, 1 row affected (0.02 sec)
    Rows matched: 1 Changed: 1 Warnings: 0
Have more questions? Submit a request
Please sign in to leave a comment.