Scanning for applications fails with error: Integrity constraint violation: 1062 Duplicate entry '/httpdocs/33...' for key 'path'

Created:

2016-11-16 13:23:02 UTC

Modified:

2017-08-08 13:39:58 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Scanning for applications fails with error: Integrity constraint violation: 1062 Duplicate entry '/httpdocs/33...' for key 'path'

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

The following error occurs while scanning application under reseller account:

Scanning for applications finished with errors.
ERR [util_exec] proc_close() failed ['/opt/psa/admin/bin/wpmng' '--user=domain' '--php=/usr/bin/php5' '--' '--path=/var/www/vhosts/domain.eu/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs' 'core' 'info' '--format=json' '--check-updates=true'] with exit code [255]

ERR [1] PleskMainDBException: DB query failed:
INSERT INTO `WordpressInstances` (`subscriptionId`, `path`, `isIgnored`) VALUES (?, ?, ?)

Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6-/httpdocs/33/root/httpdocs/33/root/httpdocs/33/root/httpdocs/3' for key 'path'
file: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php
line: 30

Cause

Symlink to root directory in domain vhost folder:

#  ls -la /var/www/vhosts/domain.eu/httpdocs/33
total 28
drwxr-xr-x 2 domain psacln 4096 Sep 23 03:41 .
drwxr-xr-x 8 domain psaserv 4096 Sep 22 16:20 ..
-rw-r--r-- 1 domain psacln 293 Sep 10 21:33 .htaccess
lrwxrwxrwx 1 domain psacln 1 Sep 10 21:34 root -> /

Resolution

Remove symlink to root directory as domain user does not even has access to it.

Have more questions? Submit a request
Please sign in to leave a comment.