On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at MyPlesk.com/Plesk360/Platform360 please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

Unable to create domain alias or Plesk upgrade fails: Duplicate entry for key 'guid'

Follow

Comments

3 comments

  • Avatar
    Marcio Nunes

    -bash: syntax error near unexpected token `newline'

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello Marcio Nunes

    The script has worked fine on my test server. There could have been some issue with copying the code.

    The script I've used:

    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"

    Screenshot of it working:

    0
    Comment actions Permalink
  • Avatar
    Gilles Dumont

    We are getting the same error -bash: syntax error near unexpected token `newline' while executing:

    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"

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request