Migration warning: Error during user update: Unable to load object of type Mailname with id=xx: Unable create domain with ID "xx"

Created:

2016-11-16 12:49:36 UTC

Modified:

2017-04-24 12:10:34 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Migration warning: Error during user update: Unable to load object of type Mailname with id=xx: Unable create domain with ID "xx"

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Linux
  • Plesk 12.0 for Linux
  • Plesk 12.5 for Windows

Symptoms

Migration finished with warning:

Error during user update: Unable to load object of type Mailname with id=64: Unable create domain with ID "498"

The same error may occur during Customer or Reseller account removal.

Cause

Database inconsistency.

Resolution

In order to get migration finished without such warnings follow the steps:

  1. First of all, create database backup as per KB881

  2. Make sure that domain with id mentioned in warning does not exist:

    mysql> select id, name from domains where id=498;
    Empty set (0.00 sec)
  3. Check how many mailnames belong to non-existent domain:

    mysql>  select id,mail_name,dom_id from mail where dom_id=498;
    +----+-----------+--------+
    | id | mail_name | dom_id |
    +----+-----------+--------+
    | 26 | user1 | 498 |
    | 10 | user2 | 498 |
    | 11 | user3 | 498 |
    | 23 | user4 | 498 |
    | 64 | user5 | 498 |
    +----+-----------+--------+
  4. Remove these mailnames:

    mysql> delete from mail where dom_id=498;
Have more questions? Submit a request
Please sign in to leave a comment.