Unable to rename domain in Plesk: No backend DB entries were modified

Symptoms

• Unable to rename domain example.com to example.net with the following error message:

  mailmng-outgoing failed: ERROR:outgoing:No backend DB entries were modified.

• In /var/lib/plesk/mail/outgoing/data.db SQLite database, there is no record for example.com domain:

  # sqlite3 /var/lib/plesk/mail/outgoing/data.db

  sqlite> SELECT id,name,subscription_id,out_limit FROM domains WHERE name='example.com';
  sqlite>

Cause

Missing record for example.com domain in /var/lib/plesk/mail/outgoing/data.db SQLite database.

Resolution

1. Connect to the server via SSH.

2. Create a backup of /var/lib/plesk/mail/outgoing/data.db database:

   # cp -a /var/lib/plesk/mail/outgoing/data.db{,.bak}

3. Recreate the missing record:

   • If example.com is a main domain of a subscription:

     # plesk sbin mailmng-outgoing --add-subscription --main-domain-name=example.com

   • If example.com is an additional domain of a subscription:

     # plesk sbin mailmng-outgoing --add-domain --domain-name=example.com --main-domain-name=example.org

     Note: Replace example.org with the name of the subscription to which example.com belongs.