Unable to create domain alias or Plesk upgrade fails: the parent domain does not appear in the list

Follow

Comments

2 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

Please sign in to leave a comment.

Have more questions? Submit a request