- Plesk for Linux
When trying to create an alias in Plesk > Domains > Add domain Alias for the domain example.com, the domain is not listed and the following message is shown in the input line:
CONFIG_TEXT: No matches found
It is possible to create the domain alias directly in the subscription by going to Subscriptions > example.com > Add Domain Alias
Subscription is synchronized with its service plan and the Domain aliases parameter is set to Unlimited
There are domains configured with the same GUID in the Plesk database:
# plesk db -Ne "SELECT guid, count(guid) FROM domains GROUP BY guid HAVING COUNT(guid) > 1"
The following error might be shown when upgrading Plesk:
CONFIG_TEXT: ERROR: Duplicate guid were found in the 'domains' table:
Inconsistency in the Plesk database: Duplicated GUID records in domains table
Connect to the server via SSH
# plesk db dump psa > psa.backup`date +%F-%s`.sql
Fix the inconsistency by running the following script:
# plesk db -Ne "SELECT guid, count(guid) FROM domains GROUP BY guid HAVING COUNT(guid) > 1" | while read G C; do echo "> DUPLICATED GUID: $G"; for ((i=0;i<(C-1);i++)); do plesk db -Ne "SELECT id, name FROM domains WHERE guid = '$G' limit 1" | while read I D; do plesk db -Ne "UPDATE domains SET guid = UUID() WHERE id = '$I'"; echo "- FIXED: $D"; done; done; done; echo "> COMPLETED"