1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Mailbox create issue

Discussion in 'Plesk 9.x for Windows Issue, Fixes, How-To' started by ecellini, Oct 1, 2009.

  1. ecellini

    ecellini Guest

    When I create a mailbox for a domain Plesk show this error, do you have some idea to resolve this issue?

    The Error details:

    - Operation failed

    Additional Information
    <b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Violation of PRIMARY KEY constraint 'permissionsPrimaryKey'. Cannot insert duplicate key in object 'dbo.permissions'.
    ---------------------- Debug Info -------------------------------
    0: common_func.php3:163
    com->execute(string 'INSERT INTO [Permissions] ([id],[permission],[value]) VALUES (2444,N'cp_access',N'true')', NULL null)
    1: common_func.php3:163
    db_query(string 'INSERT INTO [Permissions] ([id],[permission],[value]) VALUES (2444,'cp_access','true')')
    2: common_func.php3:207
    db_query_ex(string 'INSERT INTO [Permissions] ([id],[permission],[value]) VALUES ?(VALUES)', array)
    3: SQLInsertQuery.php:36
    4: class.ListTable.php:112
    5: class.aListSQL.php:232
    6: class.Permissions.php:191
    7: MailName.php:622
    Mailname->_onMailNameCPAccessUpdate(object of type MailNameCPAccess)
    8: MailNameCPAccess.php:145
    9: mail_name_preferences.php:129
    require(string 'C:\Program Files (x86)\Parallels\Plesk\admin\htdocs\domains\mail\mail_name_preferences.php')
    10: plesk.php:56

    Best Regards,
  2. Andrey Kucherov

    Andrey Kucherov Guest


    Probably you can troubleshoot this error using Microsoft SQL Server Management Studio Express:


    Then you can look through psa database in the table permissions and check if there are any values like in the following error string:

    db_query(string 'INSERT INTO [Permissions] ([id],[permission],[value]) VALUES (2444,'cp_access','true')')

    Most probably there are some old entries left in the database that were not removed to some circumstances.
    Also before applying any changes we recommend to dump the Parallels Plesk database.