db-update-plesk10.php shows Zend_Db_Statement_Exception: SQLSTATE[23000]

[EdwardDekker]

Zend_Db_Statement_Exception: SQLSTATE[23000]

Hello,

I do have some problems to update my Plesk DB when i run:

/usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/scripts/db-update-plesk10.php

Creating user for mail name with id 2...
Zend_Db_Statement_Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '[email protected]' for key 'login'
file: /usr/local/psa/admin/plib/Zend/Db/Statement/Pdo.php
line: 238
code: 0

And i have many more entries like this.

How could i resolve this problem.

Edward

 

[IgorG]

Duplicate entry '[email protected]' for key 'login'

Make sure that you haven't duplicate records in sys_users, clients, smb_users tables for this email address.

 

[EdwardDekker]

Hello Igor,

I have some duplicates by the vertical row for email into SMB_Users, but for now i don't have any clue how to figure it out. I see rows with users completley filled with personal info and also rows with e-mail addresses that ends with NULL.

What kind of row do i have to remove?

For the rest looks PSA DB fine.

Regards,
Edward